题解 | #计算商城中2021年每月的GMV#

完整答案

select
  date_format(event_time, '%Y-%m') month,
  sum(total_amount) GMV
from
  tb_order_overall
where
  status != 2
  and year(event_time) = 2021
group by
  month
having
  GMV > 100000
order by
  GMV