题解 | 查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分
查询出每个品牌在特定时间段内的退货率以及平均客户满意度评分
https://www.nowcoder.com/practice/39f4ccb8ac1b47a89d092b4d8ed08bc8
select so.brand_id, brand_name, round(sum(return_status)/count(so.order_id), 2) as return_rate_July_2024, round(avg(customer_satisfaction_score), 2) as average_customer_satisfaction_score from sales_orders so left join brand_info b on so.brand_id = b.brand_id left join customer_feedback cf on cf.order_id = so.order_id where order_date between '2024-07-01' and '2024-07-31' group by 1,2 order by 1;
