如何在查询包含聚合函数时向查询结果"添加"列？

WITH aggregated_sales AS (
  SELECT product_id, SUM(quantity * price) AS total_sales
  FROM sales
  GROUP BY product_id
)
SELECT products.product_id, products.product_name, aggregated_sales.total_sales
FROM products
JOIN aggregated_sales ON products.product_id = aggregated_sales.product_id;

SELECT product_id, product_name, SUM(quantity * price) OVER (PARTITION BY product_id) AS total_sales
FROM sales;