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