如何使用SQL中的条件计算每月的总销售额？

最新推荐文章于 2025-03-15 09:32:18 发布

奔跑的棒槌

最新推荐文章于 2025-03-15 09:32:18 发布

阅读量2.4k

点赞数 1

分类专栏：记录自己学习过程笔记文章标签： sql

本文链接：https://blog.youkuaiyun.com/m0_50518517/article/details/125997357

版权

记录自己学习过程同时被 2 个专栏收录

39 篇文章

订阅专栏

笔记

4 篇文章

订阅专栏

create_time 分组月份的依据
deal_number 按照月份分组的金额

select Month(create_time) as 'Month'
    , sum(deal_number) as 'Total Sales'
    -- You can even add a count of loans at the same time.
    , sum(case when deal_number <= 0 then 1 else 0 end) as 'Total Loans'
from pay_order
group by Month(create_time);