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

#查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分
SELECT brand_id, brand_name,
    ROUND(SUM(IF(return_status = 1,1,0))/COUNT(return_status),2) AS return_rate_July_2024,
    ROUND(AVG(customer_satisfaction_score),2) AS average_customer_satisfaction_score
FROM sales_orders
JOIN brand_info
USING(brand_id)
JOIN customer_feedback
USING(order_id)
WHERE order_date BETWEEN '2024-07-01' AND '2024-07-31'
GROUP BY brand_id