[LeetCode/SQL] 1633. Percentage of Users Attended a Contest

[LeetCode/SQL]

---

📌 1633. Percentage of Users Attended a Contest

문제

풀이

- contest_id별 유저가 등록한 비율을 출력하라

방법

SELECT contest_id
      ,ROUND(COUNT(DISTINCT user_id)/(SELECT COUNT(user_id) FROM Users) *100,2) AS percentage
FROM Register
GROUP BY contest_id
ORDER BY percentage DESC,contest_id