leetcode

Leetcode submissions
git clone git://git.laack.co/leetcode.git
Log | Files | Refs | README

percent-attended.sql (343B)

      1 --Given a table that has contest sign ups return the percentage
      2 --of all users who are at every given contest.
      3 
      4 SELECT
      5     Register.contest_id,
      6     ROUND(COUNT(Register.user_id) / (SELECT COUNT(*) FROM Users) * 100, 2) AS percentage
      7 FROM
      8     Register
      9 GROUP BY
     10     Register.contest_id
     11 ORDER BY
     12     percentage DESC,
     13     Register.contest_id ASC;