leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
0602.sql (202B)
0 SELECT id, COUNT(*) AS num
1 FROM (
2 SELECT requester_id AS ID
3 FROM RequestAccepted
4 UNION ALL
5 SELECT accepter_id
6 FROM RequestAccepted
7 ) AS D
8 GROUP BY id
9 ORDER BY COUNT(*) DESC
10 LIMIT 1