leetcode

commit ba76f37f4141b4ef1d48ecee03a3ba64766293d0
parent 3ad473ebfe0bfd76823d0feb0623d800261c16c1
Author: AndrewLockVI <andrewlaack1@gmail.com>
Date:   Sun,  9 Jul 2023 14:39:38 -0500

Completed percentage of users attended a contest using mySQL

Diffstat:
A
percentage-of-users-attended-a-contest/percent-attended.sql
 | 
13
+++++++++++++

1 file changed, 13 insertions(+), 0 deletions(-)
diff --git a/percentage-of-users-attended-a-contest/percent-attended.sql b/percentage-of-users-attended-a-contest/percent-attended.sql
@@ -0,0 +1,13 @@
+--Given a table that has contest sign ups return the percentage
+--of all users who are at every given contest.
+
+SELECT
+    Register.contest_id,
+    ROUND(COUNT(Register.user_id) / (SELECT COUNT(*) FROM Users) * 100, 2) AS percentage
+FROM
+    Register
+GROUP BY
+    Register.contest_id
+ORDER BY
+    percentage DESC,
+    Register.contest_id ASC;