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