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 |
반응형
'SQL' 카테고리의 다른 글
| leetcode 619. Biggest Single Number (0) | 2023.06.09 |
|---|---|
| leetcode 1517. Find Users With Valid E-Mails (0) | 2023.06.07 |
| leetcode 570. Managers with at Least 5 Direct Reports (0) | 2023.06.01 |
| leetcode 570. Managers with at Least 5 Direct Reports (0) | 2023.05.31 |
| leetcode 584. Find Customer Referee (0) | 2023.05.29 |
댓글