select warehouse

select passenger_id, count(*) total_orders,case when left(time(gmt_create),8) < "06:00:00" then date_sub(date(gmt_create),interval 1 day)  else date(gmt_create)  end as date, "level" as level from daijia_order.valet_order where status in (7, 8) and risk_type in (1, 5)                 and gmt_create between "2016-09-01 06:00:00" and  "2016-11-17 06:00:00" group by passenger_id,date;