with t1 as (
    select sales_id,brand_id,sales_amount,sales_quantity
    from sales_data
    where mid(sales_month,1,4) = 2023
)
select brand_id,sum(sales_amount) total_sales_amount,sum(sales_quantity) total_sales_quantity,
round(avg(satisfaction_score),2) avg_satisfaction_score 
from t1 join customer_feedback c on t1.sales_id = c.sales_id
group by brand_id