Employee Bonus --leetcode

2019独角兽企业重金招聘Python工程师标准>>>

leetCode sql没几道题 就开始 收费模式了

Select all employee's name and bonus whose bonus is < 1000.Table:Employee+-------+--------+-----------+--------+ | empId | name | supervisor| salary | +-------+--------+-----------+--------+ | 1 | John | 3 | 1000 | | 2 | Dan | 3 | 2000 | | 3 | Brad | null | 4000 | | 4 | Thomas | 3 | 4000 | +-------+--------+-----------+--------+ empId is the primary key column for this table. Table: Bonus+-------+-------+ | empId | bonus | +-------+-------+ | 2 | 500 | | 4 | 2000 | +-------+-------+ empId is the primary key column for this table. Example ouput:+-------+-------+ | name | bonus | +-------+-------+ | John | null | | Dan | 500 | | Brad | null | +-------+-------+这些被锁的题目 不能在线验证了solution：SELECTEmployee.name, Bonus.bonus FROMEmployeeLEFT JOINBonus ON Employee.empid = Bonus.empid WHEREbonus < 1000 OR bonus IS NULL ;Note: "LEFT OUTER JOIN" could be written as "LEFT JOIN".

转载于:https://my.oschina.net/u/2277632/blog/1589125

总结

以上是生活随笔为你收集整理的Employee Bonus --leetcode的全部内容，希望文章能够帮你解决所遇到的问题。

如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。