_577. Employee Bonus.md

577. Employee Bonus

All prompts are owned by LeetCode. To view the prompt, click the title link above.

Back to top

---

First completed : May 22, 2024

Last updated : July 01, 2024

---

Related Topics : Database

Acceptance Rate : 77.04 %

---

Solutions

• e577.sql

SQL

e577.sql

SELECT name, bonus
    FROM Employee e LEFT OUTER JOIN Bonus b ON e.empId = b.empId
    WHERE IFNULL(bonus, 0) < 1000;