题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select date_format(t_time,'%Y-%m') as time, sum(t_amount) as total from trade where t_cus = 101 and t_type = 1 and year(t_time) = 2023 group by time order by time
美团公司福利 3572人发布
查看12道真题和解析