qq_40473204的博客

查看每个城市每天完成订单数，取消订单数，下单订单数，下单用户数 select city_id, sum(case when order_status=5 then 1 else 0 end) as cnt_ord_succ_d, sum(case when order_status=3 then 1 else 0 end) as cnt_ord_cacel_d, sum(1) as cnt_ord_d, count(distinct CUST_ID) as cnt_ord_user /

sql with用法 https://blog.youkuaiyun.com/qq_36617521/article/details/55256382 https://blog.youkuaiyun.com/weixin_41600552/article/details/82958942 convert() https://www.runoob.com/sql/func-convert.html cube和rollup，grouping https://www.cnblogs.com/zzhangyuhang/p/9