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