SQL
leetcode 1633. Percentage of Users Attended a Contest
무적김두칠
2023. 6. 1. 14:50
Percentage of Users Attended a Contest - LeetCode
Can you solve this real interview question? Percentage of Users Attended a Contest - Table: Users +-------------+---------+ | Column Name | Type | +-------------+---------+ | user_id | int | | user_name | varchar | +-------------+---------+ user_id is the
leetcode.com
|
1
2
3
4
5
6
|
# Write your MySQL query statement below
select r.contest_id, round((count(r.user_Id)/(select count(user_id) from Users))*100, 2) percentage
from Users u
join Register r on u.user_id = r.user_id
group by r.contest_id
order by percentage desc, r.contest_id
|
cs |
반응형