题解 | #广告点击的高峰期#
广告点击的高峰期
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;
你很难想象题目根本不告诉你高峰期指的是30分钟还是1个小时,如果面试遇到这种情况只能GG了
