题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分

# 按照品牌分组，查询每个品牌在24年7月的退货率、平均客户满意度评分
with
t1 as(
    select
        brand_id,
        brand_name,
        return_status as rs,
        customer_satisfaction_score as css
    from
        sales_orders
        left join customer_feedback using(order_id)
        left join brand_info using(brand_id)
    where
        date_format(order_date,'%Y%m')='202407'
)
,
t2 as(
    select
        brand_id,
        brand_name,
        round(sum(rs)/count(rs),2) as return_rate_July_2024,
        round(avg(css),2) as average_customer_satisfaction_score
    from
        t1
    group by
        brand_id,
        brand_name
    order by
        brand_id
)


select * from t2