题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select substr(t.t_time,1,7) as time, sum(t.t_amount) as total from trade t join customer c on t.t_cus = c.c_id where c.c_name = 'Tom' and year(t.t_time) =2023 and t.t_type =1 group by substr(t.t_time,1,7) order by time
简单查询