题解 | #获取指定客户每月的消费额#
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select max(CONCAT(YEAR(t_time), '-', LPAD(MONTH(t_time), 2, '0'))) time,
sum(t_amount) total
from (select t_time,
t_amount
from trade t
join customer c on t.t_cus = c.c_id
where c.c_name = 'Tom' and year(t_time) = 2023 and t_type = 1) tb1
group by month(tb1.t_time)
order by month(tb1.t_time);
腾讯公司福利 674人发布
三环集团开奖44人在聊