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

【场景】：分组统计

【分类】：分组查询

分析思路

select 查询结果 [月份;GMV]
from 从哪张表中查询数据[订单总表]
where 查询条件 [2021年]
group by 分组条件 [月份] having 分组后条件[GMV大于10w]
order by 对查询结果排序 [货的数量降序];

求解代码

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