577. Employee Bonus

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

SELECT name, bonus

  FROM Employee e LEFT JOIN Bonus b ON e.empId = b.empId

 WHERE bonus < 1000;

select name, bonus from Employee eleft join Bonus b on e.empId = b.empIdwhere bonus < 1000;

posted @ 2018-10-20 03:03  ffeng0312  阅读(120)  评论(0)    收藏  举报