题解 | 评估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
投递快手等公司10个岗位
百度HR面16人在聊