MySQL sum 变量之和

Question

我将对 totalSale 变量求和并将其存储为 balanced:

这是我的查询:

SELECT
  sum((price * content.owner_percent) / 100) AS totalSale,
  sum(totalSale) as balanced
FROM customer_content
  INNER JOIN content ON content.id = customer.content_id
WHERE content_owner_id = 3;

我该怎么做？!

Answer 1

如果我是对的，您想要获得平均值总和(totalSale)。如果是，你可以这样做:

SELECT sum(src.totalSale) as balanced
FROM (
   SELECT
     sum((price * content.owner_percent) / 100) AS totalSale,
   FROM customer_content
   INNER JOIN content ON content.id = customer.content_id
   WHERE content_owner_id = 3
) AS src