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