with s as(
select s.sales_id,brand_id,sales_amount,sales_quantity,satisfaction_score
from sales_data s
left join customer_feedback c
on s.sales_id = c.sales_id
where sales_month between '2023-01' and '2023-12'
)

select brand_id
, round(sum(sales_amount),2) total_sales_amount 
, round(sum(sales_quantity),2) total_sales_quantity
, round(avg(satisfaction_score),2) avg_satisfaction_score
from s
group by 1