题解 | 评估2023年不同品牌商品的销售趋势和客户满意度
评估2023年不同品牌商品的销售趋势和客户满意度
https://www.nowcoder.com/practice/a32c7ff803054a919e2b65334463002f
select brand_id ,sum(sales_amount) total_sales_amount ,sum(sales_quantity) total_sales_quantity ,round(avg(satisfaction_score), 2) avg_satisfaction_score from sales_data sf join customer_feedback cf on sf.sales_id = cf.sales_id where substring(sales_month,1,4) = '2023' group by 1 order by 1