题解 | #获取指定客户每月的消费额#
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
#现需要查询 Tom 这个客户在 2023 年每月的消费金额（按月份正序显示） #2023 tom 每月 消费 消费金额 with mon_tom_23 as (select *, date_format(t_time,'%Y-%m') as mon from trade t left join customer c on t.t_cus=c.c_id where year(t.t_time)=2023 and c.c_name='Tom' and t.t_type = 1 ) select mon as time ,sum(t_amount) as total from mon_tom_23 group by mon order by mon
投递银联等公司10个岗位 >
查看8道真题和解析