select d.num, d.jflx, d.mytime
from (select count(1) num,
a.jflx,
to_char(a.create_time, 'yyyy-mm-dd hh') mytime
from zklt_sjjl a
where to_char(a.create_time, 'yyyy-mm-dd') = '2019-05-13'
group by a.jflx, to_char(a.create_time, 'yyyy-mm-dd hh')) d
根据时间和活动类型,统计每个活动在每小时的参加人数