select
    t1.brand_id brand_id,
    t1.brand_name brand_name,
    round(sum(t2.return_status)/count(t2.return_status),2) return_rate_July_2024,
    round(avg(t3.customer_satisfaction_score),2) average_customer_satisfaction_score
from
    brand_info t1 join sales_orders t2 on t1.brand_id = t2.brand_id
    join customer_feedback t3 on t2.order_id = t3.order_id
where
    t2.order_date between '2024-07-01' and '2024-07-31'
group by 
    t1.brand_id, t1.brand_name
order by
    t1.brand_id