leetcode

Solution to some Leetcode problems written in C++
git clone git://git.dimitrijedobrota.com/leetcode.git
Log | Files | Refs | README | LICENSE

0602.sql (202B)

      1 SELECT id, COUNT(*) AS num
      2 FROM (
      3     SELECT requester_id AS ID
      4     FROM RequestAccepted
      5     UNION ALL
      6     SELECT accepter_id
      7     FROM RequestAccepted
      8 ) AS D
      9 GROUP BY id
     10 ORDER BY COUNT(*) DESC
     11 LIMIT 1
     12