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 (
    select *
    from sales_data
    where left(sales_month, 4)=2023
) a join customer_feedback b on a.sales_id=b.sales_id
group by brand_id
order by brand_id