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