题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
with t1 as( select t.*,c_name from trade t Inner join customer c on t.t_cus = c.c_id where c_name = 'Tom' and year(t_time) = 2023 and t_type = 1 ) #找出Tom在2023年的消费交易明细 select substr(cast(t_time as char),1,7) time, sum(t_amount) total from t1 group by substr(cast(t_time as char),1,7) order by time
查看20道真题和解析
文远知行公司福利 588人发布