题解 | 评估2023年不同品牌商品的销售趋势和客户满意度
评估2023年不同品牌商品的销售趋势和客户满意度
https://www.nowcoder.com/practice/a32c7ff803054a919e2b65334463002f
select brand_id, sum(sales_amount) as total_sales_amount, sum(sales_quantity) as total_sales_quantity, round(avg(satisfaction_score), 2) as avg_satisfaction_score from sales_data join customer_feedback using (sales_id) where sales_month between '2023-01-01' and '2023-12-31' group by brand_id order by brand_id