CREATE OR REPLACE TEMPORARY TABLE TBL_NUMBER
(
NUM FLOAT
)
AS
SELECT
*
FROM
VALUES(2),(3),(4);
SELECT
EXP
(
SUM
(
LN(NUM)
)
) AS RESULT
FROM
TBL_NUMBER
CREATE OR REPLACE TEMPORARY TABLE TBL_NUMBER
(
NUM FLOAT
)
AS
SELECT
*
FROM
VALUES(2),(3),(4);
SELECT
EXP
(
SUM
(
LN(NUM)
)
) AS RESULT
FROM
TBL_NUMBER