Problem: 1633. 各赛事的用户注册率
Code
select contest_id, ROUND(COUNT(user_id) * 100 / (select count(*) from users),2) as percentage
from register
group by contest_id
order by percentage desc, contest_id asc
Problem: 1633. 各赛事的用户注册率
select contest_id, ROUND(COUNT(user_id) * 100 / (select count(*) from users),2) as percentage
from register
group by contest_id
order by percentage desc, contest_id asc