add 602

fishercoder1534 · fishercoder1534 · commit f5dc7addd738 · 2017-07-22T16:34:27.000-07:00
diff --git a/README.md b/README.md
@@ -569,6 +569,7 @@ Your ideas/fixes/algorithms are more than welcome!
 |612|[Shortest Distance in a Plane](https://leetcode.com/problems/shortest-distance-in-a-plane/)|[Solution](../master/database/_612.sql) | || Medium|
 |610|[Triangle Judgement](https://leetcode.com/problems/triangle-judgement/)|[Solution](../master/src/main/java/com/fishercoder/solutions/_610.java) | | | Easy | 
 |607|[Sales Person](https://leetcode.com/problems/sales-person/)|[Solution](../master/database/_607.sql) | | | Easy |
+|602|[Friend Requests II: Who Has the Most Friends](https://leetcode.com/problems/friend-requests-ii-who-has-the-most-friends/)|[Solution](../master/database/_602.sql) | | | Medium |
 |597|[Friend Requests I: Overall Acceptance Rate](https://leetcode.com/problems/friend-requests-i-overall-acceptance-rate/)|[Solution](../master/database/_597.sql) | | | Easy |
 |596|[Classes More Than 5 Students](https://leetcode.com/problems/classes-more-than-5-students/)|[Solution](../master/database/_596.sql) | || Easy |
 |595|[Big Countries](https://leetcode.com/problems/big-countries/)|[Solution](../master/database/_595.sql) | O(n) |O(1) | Easy |
diff --git a/database/_602.sql b/database/_602.sql
@@ -0,0 +1,7 @@
+select id, count(*) num from
+(
+    (select requester_id id from request_accepted)
+    union all
+    (select accepter_id id from request_accepted)
+) as A
+group by id order by num desc limit 1;
