employee-bonus.sql (212B)
1 --Show all employees with a bonus less than 1000 dollars 2 --Runtime: 1928ms Beats: 35.82% 3 4 SELECT E.name, B.bonus 5 FROM Employee as E 6 LEFT JOIN Bonus as B 7 ON E.empId=B.empId 8 WHERE B.bonus < 1000 OR B.bonus IS NULL