按月比较产品销售额的 SQL 查询

SELECT 
    DATE_TRUNC('month', order_date) AS month,
    product_id,
    SUM(quantity * price) AS total_sales
FROM 
    orders
GROUP BY 
    month, product_id
ORDER BY 
    month, product_id