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