select s.brand_id
, brand_name
, round(sum(return_status)/count(*),2) return_rate_July_2024
, round(avg(customer_satisfaction_score),2) average_customer_satisfaction_score
from sales_orders s
left join brand_info b on s.brand_id = b. brand_id
left join customer_feedback c on s.order_id = c. order_id
where order_date between '2024-07-01' and '2024-07-31'
group by 1,2