一、题目
二、代码
-- # Write your MySQL query statement below
-- select count(distinct user_id) from Users
select table1.contest_id , round(table1.co_user/ table2.co_sum*100,2) as percentage from
(
select contest_id , count(distinct user_id) as co_user from Register
group by contest_id
order by contest_id asc
) as table1
join
(
select count(distinct user_id) as co_sum from Users
) as table2
order by percentage desc,contest_id asc