题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select distinct substring(trade.t_time,1,7) as time ,
sum(trade.t_amount) over (partition by substring(t_time,6,2)) as total
from trade join customer
on trade.t_cus=customer.c_id
where customer.c_name='Tom' and year(t_time)='2023' and trade.t_type='1'
order by time
截取字符串