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