"MySQl" by all, today, this month, 24 hours per hour statistics

--24 hours
SELECTHOUR (create_date) ashours,SUM(Source_amount) Sm_source_amount,SUM(Ticket_count*Purchase_price) asSm_purchase_amount fromTicket_orderWHEREdate_format (Create_date,'%y-%m-%d')= '2017-05-12' andscenic_idinch(1,2,3);GROUP  byHOUR (create_date);SelectHour (create_date) asHours,ticket_count,create_date fromTicket_orderwhereDate_format (Create_date,'%y-%m-%d')= '2017-05-12'  Group  byhour (create_date);--DaysSELECT    SUM(Source_amount) asSm_source_amount,SUM(Ticket_count) asSm_ticket_count fromTicket_orderWHEREdate_format (Create_date,'%y-%m-%d')= '2017-05-17';--monthSELECT    SUM(Source_amount) asSm_source_amount,SUM(Ticket_count) asSm_ticket_count fromTicket_orderWHEREdate_format (Create_date,'%y-%m')= '2017-05';--AllSELECT    SUM(Source_amount) asSm_source_amount,SUM(Ticket_count) asSm_ticket_count fromTicket_order;

"MySQl" by all, today, this month, 24 hours per hour statistics