leetcode

commit f3da95d8d92f3f0b296789752589983a639dcd7b
parent 3d31af3aefc3b3e5a8cea7482becf05cdbc6acf5
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Fri, 14 Apr 2023 20:50:27 -0500

Completed employee bonus sql problem

Diffstat:
A
employee-bonus/employee-bonus.sql
 | 
8
++++++++

1 file changed, 8 insertions(+), 0 deletions(-)
diff --git a/employee-bonus/employee-bonus.sql b/employee-bonus/employee-bonus.sql
@@ -0,0 +1,8 @@
+--Show all employees with a bonus less than 1000 dollars
+--Runtime: 1928ms Beats: 35.82%
+
+SELECT E.name, B.bonus
+FROM Employee as E
+LEFT JOIN Bonus as B
+ON E.empId=B.empId
+WHERE B.bonus < 1000 OR B.bonus IS NULL