题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
SELECT date_format(t.t_time,'%Y-%m') as time,
sum(t.t_amount) as total
FROM trade t
left join customer c on c.c_id=t.t_cus
where c.c_name='Tom'
and year(t.t_time)='2023'
and t.t_type=1
group by date_format(t.t_time,'%Y-%m')
order by time asc
这个太简单了
，感觉有些诈骗短信就这么发的