leetcode

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

1633.sql (175B)

      1 SELECT contest_id, ROUND(COUNT(user_id) / (SELECT COUNT(user_id) FROM Users) * 100, 2) AS percentage
      2 FROM Register R
      3 GROUP BY contest_id
      4 ORDER BY percentage DESC, contest_id
      5