首先举个栗子(不想看的话直接下面看总结):order_type:订单类型open_id:用户唯一标识SELECTdate(create_time) AS '当天日期',sum(real_price) AS '