题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select substr(t_time, 1, 7) as time, sum(t_amount) as total
from trade t1
join customer t2
on t1.t_cus = t2.c_id
where t1.t_cus = 101 and t1.t_type = 1
and t1.t_time >= '2023-01-01' and t1.t_time <= '2023-12-31'
group by substr(t_time, 1, 7)
order by substr(t_time, 1, 7) asc