题解 | #广告点击的高峰期#
广告点击的高峰期
https://www.nowcoder.com/practice/6756d65784f9413b8505c1d0c6754b3a
select new.time click_hour, new.count click_cnt from( select date_format(click_time, '%H') time, row_number()over(order by sum(trace_id) desc) as rk, count(trace_id) count from user_ad_click_time group by date_format(click_time, '%H') ) new where new.rk = 1
查看13道真题和解析