leetcodeSolution to some Leetcode problems written in C++ |
git clone git://git.dimitrijedobrota.com/leetcode.git |
Log | Files | Refs | README | LICENSE |
1633.sql (175B)
0 SELECT contest_id, ROUND(COUNT(user_id) / (SELECT COUNT(user_id) FROM Users) * 100, 2) AS percentage 1 FROM Register R 2 GROUP BY contest_id 3 ORDER BY percentage DESC, contest_id 4