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