select brand_id
,brand_name
,round(sum(return_status)/count(*),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,brand_name
order by brand_id