select brand_id,brand_name,round(avg(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 using(brand_id)
join customer_feedback using( order_id)
where month(order_date)=7
group by brand_id,brand_name,month(order_date)