题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select date_format(t_time,'%Y-%m')as time,sum(t_amount) as total from customer left join trade on customer.c_id = trade.t_cus where c_name = 'Tom' and t_type = 1 and year(t_time)= 2023 group by time,c_id order by time#我的秋招日记#
投递阿里巴巴集团等公司10个岗位
查看7道真题和解析