The Merit Rewards SQL problem is a question presented in the HackerRank Basic SQL Certification exam.
Merit Rewards
SELECT
ei.employee_ID,
ei.name
FROM employee_information ei
JOIN last_quarter_bonus b ON b.employee_ID = ei.employee_ID
WHERE ei.division LIKE 'HR'
AND b.bonus >= 5000;
This is one question solution to the HackerRank SQL Basic Certification problem and this is shared for your increasing knowledge.
Here’s GitHub Repo: https://github.com/adminazhar/hackerrank-SQL-basic-skills-certification-test-solution