题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select date_format(t.t_time,'%Y-%m') as time,sum(t.t_amount) as total from trade t inner 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 group by time order by time asc