select brand_info.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 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 substring_index(order_date,'-',2)='2024-07'
group by brand_info.brand_id
order by brand_info.brand_id