题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select
substring(t_time, 1, 7) as time,
sum(t_amount) as total
from
trade as p1
inner join customer as p2 on p1.t_cus = p2.c_id
where
c_name = 'Tom'
and year(t_time) = 2023
and t_type = 1
group by
substring(t_time, 1, 7)
order by
time;
查看15道真题和解析