1、一天中每小时数据

  1. SELECT HOUR
  2.     (
  3.     FROM_UNIXTIME( create_time )) AS HOUR,
  4.     count(
  5.     IF
  6.     ( pay_status = 1,1,null )) AS pay_num,
  7.     count(
  8.     IF
  9.     ( pay_status = 0 ,1,null)) AS wait_pay_num 
  10. FROM
  11.     order_table 
  12. WHERE
  13.     FROM_UNIXTIME( create_time, '%Y-%m-%d' ) = '2021-04-26' 
  14.     AND appid = 4 
  15. GROUP BY
  16.     HOUR (
  17.     FROM_UNIXTIME( create_time )) 
  18. ORDER BY
  19.     HOUR (
  20.     FROM_UNIXTIME( create_time ));