Merit Rewards SQL HackerRank Solution

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