统计每一天的用户注册数sql语句 SELECT count(*), DATE_FORMAT(FROM_UNIXTIME(ctime),'%m-%d') as time FROM zj_admin WHERE ctime BETWEEN unix_timestamp('2014-3-1') AND (unix_timestamp('2014-4-30')+3600*24*3
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