leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1204.sql (156B)
0 SELECT Q1.person_name
1 FROM Queue Q1
2 JOIN Queue Q2
3 ON Q1.turn >= Q2.turn
4 GROUP BY Q1.turn
5 HAVING SUM(Q2.weight) <= 1000
6 ORDER BY SUM(Q2.weight) DESC
7 LIMIT 1