题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select left(t_time,7) as time,
sum(t_amount) as total
from trade t
left join customer c
on t.t_cus=c.c_id
where c.c_id = 101
and t.t_type=1
and year(t.t_time)=2023
group by time
order by time
;
投递美团等公司8个岗位