select brand_id
,round(sum(coalesce(sales_amount,0)),2) as total_sales_amount
,sum(coalesce(sales_quantity,0)) 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 substring(sales_month,1,4) = "2023"
group by brand_id
order by brand_id