题解 | 计算商城中2021年每月的GMV
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
with a as(
select
substring(event_time,1,7) as month,
sum(total_amount) as GMV
from tb_order_overall
where status!=2 and year(event_time)=2021
group by substring(event_time,1,7)
)
select
month,
GMV
from a
where GMV>100000
order by GMV
;
