0577.sql (110B)
1 SELECT name, bonus 2 FROM Employee E 3 LEFT JOIN Bonus B 4 ON E.empId = B.empId 5 WHERE bonus < 1000 OR bonus is NULL