select channel_id, count(order_id)
`订单数`, count(distinct user_id)
`下单人数`, sum(amount)
`总金额` from order where dt = '2021-08-04' group by channel_id
select channel_id, count(order_id)
`订单数`, count(distinct user_id)
`下单人数`, sum(amount)
`总金额` from order where dt = '2021-08-04' group by channel_id