select 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 sales_orders s join brand_info b using(brand_id) join customer_feedback c using(order_id)
where order_date between '2024-07-01' and '2024-07-31'
group by brand_id