题目描述:
写一条 SQL 语句,查询各赛事的用户注册百分率,保留两位小数。
返回的结果表按 percentage 的降序排序,若相同则按 contest_id 的升序排序。
查询结果如下示例所示:
方法1:
主要思路:解题链接汇总
select r.contest_id as contest_id,round(count(r.user_id)/(select count(*) from Users)*100,2) as percentage
from Register as r
group by r.contest_id
order by percentage desc ,contest_id asc