题解 | #广告点击的高峰期#
广告点击的高峰期
https://www.nowcoder.com/practice/6756d65784f9413b8505c1d0c6754b3a
花钱买的题,哭着也得做下去
思路:要小时,构造小时,要次数就group count
select h click_hour,count(user_id) click_cnt
from
(select user_id,date_format(click_time,'%H') h
from user_ad_click_time)t1
group by h
limit 1
