力扣---高频SQL题---18---1633. 各赛事的用户注册率

一、题目

二、代码

-- # 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

三、运行结果