文章目录 题目代码(7.17 首刷自解) 题目 Leetcode 1633. 各赛事的用户注册率 代码(7.17 首刷自解) 用了个嵌套,计算Users的总数 # Write your MySQL query statement below select contest_id, round(count(1)/(select count(1) from Users)*100, 2) percentage from Register r left join Users u on u.user_id = r.user_id group by contest_id order by percentage desc, contest_id;