题解 | 计算商城中2021年每月的GMV
计算商城中2021年每月的GMV
https://www.nowcoder.com/practice/5005cbf5308249eda1fbf666311753bf
with a as(
select
date_format(event_time,'%Y-%m') as month,
sum(total_amount) as GMV
from tb_order_overall
where status!=2 and year(event_time)=2021
group by date_format(event_time,'%Y-%m')
)
select
month,
GMV
from a
where GMV>100000
order by GMV
;
腾讯音乐娱乐集团公司福利 285人发布
