Update README.md

ieshreya · ieshreya · commit 91afb6b95854 · 2023-06-04T09:05:45.000+05:30
diff --git a/README.md b/README.md
@@ -3,30 +3,30 @@ Solutions for [SQL 50 Study Plan](https://leetcode.com/studyplan/top-sql-50/) on
 
 ---
 
-1757 - Recyclable and Low Fat Products
+[1757 - Recyclable and Low Fat Products](https://leetcode.com/problems/recyclable-and-low-fat-products/)
 ```sql
 SELECT product_id
 FROM Products
 WHERE low_fats = 'Y'
 AND recyclable = 'Y'
 ```
 
-584 - Find Customer Referee
+[584 - Find Customer Referee](https://leetcode.com/problems/find-customer-referee)
 ```sql
 SELECT name 
 FROM Customer 
 WHERE referee_id != 2 OR referee_id IS null
 ```
 
-595 - Big Countries
+[595 - Big Countries](https://leetcode.com/problems/big-countries/)
 ```sql
 SELECT name, population, area
 FROM WORLD
 WHERE area >= 3000000
 OR population >= 25000000
 ```
 
-1148 - Article Views I
+[1148 - Article Views I](https://leetcode.com/problems/article-views-i)
 ```sql
 SELECT DISTINCT author_id as id
 FROM Views
@@ -35,39 +35,38 @@ AND author_id = viewer_id
 ORDER BY author_id
 ```
 
-1683 - Invalid Tweets
+[1683 - Invalid Tweets](https://leetcode.com/problems/invalid-tweets/)
 ```sql
 SELECT tweet_id
 FROM Tweets
 WHERE length(content) > 15
 ```
 
-1378 - Replace Employee ID With The Unique 
-Identifier
+[1378 - Replace Employee ID With The Unique Identifier](https://leetcode.com/problems/replace-employee-id-with-the-unique-identifier)
 ```sql
 SELECT unique_id, name
 FROM Employees e
 LEFT JOIN EmployeeUNI eu
 ON e.id = eu.id
 ```
 
-1068 - Product Sales Analysis I
+[1068 - Product Sales Analysis I](https://leetcode.com/problems/product-sales-analysis-i/)
 ```sql
 SELECT product_name, year, price
 FROM Sales s
 LEFT JOIN Product p
 ON s.product_id = p.product_id
 ```
 
-1581 - Customer Who Visited but Did Not Make Any Transactions
+[1581 - Customer Who Visited but Did Not Make Any Transactions](https://leetcode.com/problems/customer-who-visited-but-did-not-make-any-transactions/)
 ```sql
 SELECT customer_id, COUNT(*) as count_no_trans
 FROM Visits 
 WHERE visit_id NOT IN (SELECT DISTINCT visit_id FROM Transactions)
 GROUP BY customer_id
 ```
 
-197. Rising Temperature 
+[197 - Rising Temperature](https://leetcode.com/problems/rising-temperature/) 
 ```sql
 SELECT w1.id 
 FROM Weather w1, Weather w2
@@ -81,7 +80,7 @@ WHERE w1.temperature > w2.temperature
 AND SUBDATE(w1.recordDate, 1) = w2.recordDate
 ```
 
-1661. Average Time of Process per Machine
+[1661 - Average Time of Process per Machine](https://leetcode.com/problems/average-time-of-process-per-machine/)
 ```sql
 SELECT machine_id, ROUND(AVG(end - start), 3) AS processing_time
 FROM 
@@ -93,7 +92,7 @@ FROM
 GROUP BY machine_id
 ```
 
-577. Employee Bonus
+[577 - Employee Bonus](https://leetcode.com/problems/employee-bonus/solutions/)
 ```sql
 SELECT name, bonus
 FROM Employee e
@@ -103,7 +102,7 @@ WHERE bonus < 1000
 OR bonus IS NULL
 ```
 
-1280. Students and Examinations
+[1280 - Students and Examinations](https://leetcode.com/problems/students-and-examinations/)
 ```sql
 SELECT a.student_id, a.student_name, b.subject_name, COUNT(c.subject_name) AS attended_exams
 FROM Students a
@@ -113,4 +112,23 @@ ON a.student_id = c.student_id
 AND b.subject_name = c.subject_name
 GROUP BY 1, 3
 ORDER BY 1, 3 
+```
+[570. Managers with at Least 5 Direct Reports](https://leetcode.com/problems/managers-with-at-least-5-direct-reports)
+```sql
+SELECT name 
+FROM Employee 
+WHERE id IN
+  (SELECT managerId 
+   FROM Employee 
+   GROUP BY managerId 
+   HAVING COUNT(*) >= 5
+  )
+
+-- OR
+SELECT a.name
+FROM Employee a
+JOIN Employee b
+WHERE a.id = b.managerId
+GROUP BY b.managerId
+HAVING COUNT(*) >= 5
 ```
