题解 | 计算商城中2021年每月的GMV
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
with
t0 as(
select
date_format(event_time,'%Y-%m') as month,
total_amount
from tb_order_overall
where year(event_time)=2021 and status<>2)
select
month,
sum(total_amount) as GMV
from t0
group by month
having sum(total_amount)>100000
order by GMV