COVAR_POP
Returns the population covariance for non-NULL pairs across all input values.
Syntax
COVAR_POP(expression1 numeric, expression2 numeric) → double
expression1: An expression that evaluates to a numeric type. This parameter is the dependent value.
expression2: An expression that evaluates to a numeric type. This parameter is the independent value.
Examples
SELECT COVAR_POP(transaction_count, gas_used)
FROM eth.recent_blocks
-- 31.70536771189994
SELECT COVAR_POP(DISTINCT transaction_count, gas_used)
FROM eth.recent_blocks
-- 302.592806814443e
SELECT COVAR_POP(transaction_count, gas_used)
OVER (PARTITION BY transaction_count)
FROM eth.recent_blocks
-- 1.5543122344752192e-15
Usage Note
This function supports the use of ALL
and DISTINCT
:
SELECT COVAR_POP( [ { ALL | DISTINCT } ] expression1, expression2)
Last updated
Was this helpful?