select subString(click_time,12,2) as click_hour, count(subString(click_time,12,2)) as click_cnt from user_ad_click_time a group by subString(click_time,12,2) limit 1 说句实话,这个题有毛病,第二个表有何用?