select 
    brand_id,
    sum(sales_amount) as total_sales_amount,
    sum(sales_quantity) as total_sales_quantity,
    round(avg(satisfaction_score),2) as 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 1
order by 1;