题解 | 广告点击的高峰期
广告点击的高峰期
https://www.nowcoder.com/practice/6756d65784f9413b8505c1d0c6754b3a
select
hour(click_time) as click_hour,
count(hour(click_time)) as click_cnt
from
user_ad_click_time
group by
click_hour
order by
click_cnt desc
limit
1
投递中国电信等公司6个岗位