题解 | 评估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 s join customer_feedback c on s.sales_id=c.sales_id where left(sales_month,4)=2023 group by brand_id order by brand_id
