题解 | #获取指定客户每月的消费额#
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
with tiaojian as ( select date_format(t_time,"%Y-%m") as time, t_cus, sum(t_amount) as total from trade where t_type=1 and year(t_time)=2023 group by date_format(t_time,"%Y-%m"),t_cus ) select time, total from tiaojian t inner join customer c on t.t_cus=c.c_id where c_name="Tom" order by time
查看3道真题和解析
滴滴公司福利 221人发布