题解 | #广告点击的高峰期#
广告点击的高峰期
https://www.nowcoder.com/practice/6756d65784f9413b8505c1d0c6754b3a
SELECT
HOUR(click_time) AS click_hour, -- 计算点击的小时
COUNT(click_time) AS click_cnt -- 计算点击的次数
FROM user_ad_click_time
GROUP BY click_hour -- 按照点击的小时分组
ORDER BY click_cnt DESC -- 按照点击次数排序
LIMIT 1