[leetcode] 577. Employee Bonus / COALESCE

577. Employee Bonus

 

https://leetcode.com/problems/employee-bonus/

Employee Bonus - LeetCode

 

Write an SQL query to report the name and bonus amount of each employee with a bonus less than 1000.

 

# 1
SELECT name, bonus
FROM Employee E LEFT JOIN Bonus B USING(empID)
WHERE bonus < 1000 or bonus IS NULL;

# 2
SELECT name, bonus
FROM Employee LEFT JOIN Bonus USING(empId)
WHERE COALESCE(bonus, 0) < 1000;