题解 | 评估2023年不同品牌商品的销售趋势和客户满意度

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