leetcode

Solution 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