Update managers-with-at-least-5-direct-reports.sql (#6)

the1Riddle · web-flow · commit 0341ea135057 · 2024-05-19T15:35:12.000+03:00
diff --git a/MySQL/managers-with-at-least-5-direct-reports.sql b/MySQL/managers-with-at-least-5-direct-reports.sql
@@ -1,17 +1,9 @@
 # Time:  O(n)
 # Space: O(n)
 
-SELECT
-    Name
-FROM
-    Employee AS t1 INNER JOIN
-    (SELECT
-        ManagerId
-    FROM
-        Employee
-    GROUP BY ManagerId
-    HAVING COUNT(ManagerId) >= 5
-    ORDER BY NULL) AS t2
-    ON t1.Id = t2.ManagerId
-;
+SELECT name FROM Employee WHERE id IN (
+    SELECT managerId
+    FROM Employee
+    GROUP BY managerId
+    HAVING COUNT(*) >= 5)
 
