题解 | 评估2023年不同品牌商品的销售趋势和客户满意度
评估2023年不同品牌商品的销售趋势和客户满意度
https://www.nowcoder.com/practice/a32c7ff803054a919e2b65334463002f
select sa.brand_id, sum(sa.sales_amount) as total_sales_amount, sum(sales_quantity) as total_sales_quantity, ROUND(AVG(cf.satisfaction_score), 2) AS avg_satisfaction_score from sales_data sa inner join customer_feedback cf on cf.sales_id = sa.sales_id WHERE sa.sales_month LIKE '2023-%' group by sa.brand_id order by sa.brand_id asc
细心
查看4道真题和解析
