题解 | #获取指定客户每月的消费额#
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select DATE_FORMAT(t_time, '%Y-%m') as time, sum(t_amount) as total from trade left join customer on trade.t_cus = customer.c_id where year(t_time) = 2023 and c_name = 'Tom' and t_type = 1 group by time order by time asc;
