题目描述：
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 | +-------+-------+
题目大意：
选出所有奖金<1000元的雇员姓名及奖金数额
解题思路：
左连接（Left Join）
SQL语句：
# Write your MySQL query statement below
SELECT name, bonus
FROM Employee LEFT JOIN Bonus USING (empId)
WHERE IFNULL(bonus, 0) < 1000
本文链接：https://bookshadow.com/weblog/2017/05/05/leetcode-employee-bonus/
请尊重作者的劳动成果，转载请注明出处！书影博客保留对文章的所有权利。
如果这篇博客对你有帮助，请支持书影博客
你的捐赠将用于服务器与域名费用，帮助免费技术内容持续更新。
支付宝
微信
建议金额：¥5 / ¥10 / ¥20 / ¥50（扫码后自行输入）