您可以使用这样的临时表：
假设主表的名称是 args ```
CREATE TEMPORARY TABLE TempSums
SELECT
args.id,
arg1 + arg2 + arg3 as sum from args

现在，你可以用 `TempSums` 像这样的table：

SELECT SUM( ( sum ) / ( sum ) * ( sum ) ) FROM TempSums

您可以使用compute来计算它们的值，并在“from”子句中使用的表表达式中命名它们。例如：

create table abc (
  id int,
  arg1 int,
  arg2 int,
  arg3 int
);

insert into abc (id, arg1, arg2, arg3) values (1, 7, 3, 9); -- sum = 19
insert into abc (id, arg1, arg2, arg3) values (2, 4, 9, 5); -- sum = 18

select *, sum(arg_sum  / arg_sum * arg_sum) as result
  from (
    select *, (arg1 + arg2 + arg3) as arg_sum from abc
  ) x
  where id = 1;

结果：

id  arg1  arg2  arg3  arg_sum  result
--  ----  ----  ----  -------  ------
1   7     3     9     19       19

举个例子。。。

DROP TABLE IF EXISTS my_table;

CREATE TABLE my_table
(id INT NOT NULL
,arg INT NOT NULL
,val INT NOT NULL
,PRIMARY KEY(id,arg)
);

INSERT INTO my_table VALUES
(1,1,7),
(1,2,3),
(1,3,9),
(2,1,5),
(2,2,9),
(2,3,5);

SELECT SUM(arg_sum/(arg_sum*arg_sum)) 
  FROM 
     ( SELECT id, SUM(val) arg_sum FROM my_table GROUP BY id)n;
+--------------------------------+
| SUM(arg_sum/(arg_sum*arg_sum)) |
+--------------------------------+
|                         0.1053 |
+--------------------------------+