select
    brand_id,
    sum(sales_amount) total_sales_amount,
    sum(sales_quantity) total_sales_quantity,
    round(avg(satisfaction_score),2) avg_satisfaction_score
from
    sales_data s join customer_feedback c on s.sales_id = c.sales_id
where  
    sales_month between '2023-01' and '2023-12'
group by
    brand_id