SQL problem - Percentage of Users Attended a Contest

Problem

Query

SELECT
    r.contest_id,
    ROUND((COUNT(*) / (SELECT COUNT(*) FROM Users) * 100.00), 2) AS percentage
FROM
    Register AS r
GROUP BY
    r.contest_id
ORDER BY
    percentage DESC,
    r.contest_id ASC