题解 | 评估2023年不同品牌商品的销售趋势和客户满意度

SELECT 
    a.brand_id,
    ROUND(SUM(a.sales_amount), 2) AS total_sales_amount,  
    SUM(a.sales_quantity) AS total_sales_quantity,        
    ROUND(AVG(b.satisfaction_score), 2) AS avg_satisfaction_score  
FROM 
    sales_data AS a
JOIN 
    customer_feedback AS b ON a.sales_id = b.sales_id
WHERE 
    a.sales_month between '2023-01' and '2023-12'
GROUP BY 
    a.brand_id
ORDER BY 
    a.brand_id ASC;  

sales_month不是日期类型而是字符串类型...不能用YEAR判断年份(我才知道为啥前面有个题一直错...)