题解 | #每月各旬有多少人练题#
每月各旬有多少人练题
https://www.nowcoder.com/practice/48c8bef6528d4d838e9646682e2b395d
select concat( concat(substr(event_date,1,4),'年'), concat(substr(event_date,6,2),'月'), (CASE when day(event_date) between 1 and 9 then '上旬' when day(event_date) between 10 and 19 then '中旬' when day(event_date) >= 20 then '下旬' end) ) as dt_range, count(distinct device_id) as cnt from question_practice_detail group by dt_range order by substr(dt_range,7,1) desc, cnt desc;
投递腾讯云智研发等公司10个岗位