题解 | 评估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 (
select *
from sales_data
where left(sales_month, 4)=2023
) a join customer_feedback b on a.sales_id=b.sales_id
group by brand_id
order by brand_id
查看12道真题和解析
