题解 | 获取指定客户每月的消费额
获取指定客户每月的消费额
https://www.nowcoder.com/practice/ed04f148b63e469e8f62e051d06a46f5
select date_format(t_time,'%Y-%m') as 'time', round(sum(t_amount),1) as total from trade t join customer c on t.t_cus = c.c_id where c_name ='Tom' and t.t_type = 1 and year(t_time) = '2023' group by date_format(t_time,'%Y-%m') order by date_format(t_time,'%Y-%m');
date_format(t_time,'%Y-%m') 格式化日期
round(,)结果取小数点后几位
查看9道真题和解析
投递华为HUAWEI等公司10个岗位
