千亿数仓的sql

需求1
数据：

链接: 链接: https://pan.baidu.com/s/1xGebplPwEccjN8fjUa-nYg 提取码: tyqe

• 统计2019年期间每个季度的销售订单笔数、订单总额

select case
When month(createTime) between 1 and 3 then ‘一季度’
When month(createTime) between 4 and 6 then ‘二季度’
When month(createTime) between 7 and 9 then ‘三季度’
When month(createTime) between 10 and 12 then ‘四季度’ end,count(orderid),sum(totalMoney)
From itcast_orders where year(createTime)=2019 group by case
When month(createTime) between 1 and 3 then ‘一季度’
When month(createTime) between 4 and 6 then ‘二季度’
When month(createTime) between 7 and 9 then ‘三季度’
When month(createTime) between 10 and 12 then ‘四季度’ end;
结果：

• 统计2019年期间每个月的销售订单笔数、订单总额

select case when substr(createtime,6