sql聚合查询顺序
where
group by
having
order by
按15分钟为粒度统计每个时间段的数据
select concat(DATE_FORMAT(create_time,'%H'), FLOOR(DATE_FORMAT(create_time,'%i')/15)) time_period, COUNT(ticket_id) ticket_count from {$this->ticketTable} where service_channel={$mcChannelCode} and create_time > '{$start}' and create_time < '{$end}' group by time_period