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

# 各个品牌在2023年的总销售额、总销售数量、平均客户满意度评分

with
t1 as(
    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
        customer_feedback left join sales_data using(sales_id)
    where
        sales_month between '2023-01' and '2023-12'
    group by
        brand_id
    order by
        brand_id
)

select * from t1