18 - 各赛事的用户注册率 -- 注册率=注册用户数/所有用户数selectr.contest_id,round(100*count(*)/(select count(*) from Users),2) percentage from Register rgroup by r.contest_idorder bypercentage desc,r.contest_id AS
题目描述 leetcode题目:1633. 各赛事的用户注册率 Code select contest_id, round(count(*)/(select count(*) from Users)*100, 2) as percentagefrom Registergroup by contest_idorder by percentage desc, contest_id