select
hour(click_time) as click_hour,
count(click_time) as click_cnt
from
user_ad_click_time
group by hour(click_time)
order by count(click_time) desc
limit 1

select
hour(click_time) as click_hour,
count(click_time) as click_cnt
from
user_ad_click_time
group by hour(click_time)
order by count(click_time) desc
limit 1