VAR_POP
Returns the population variance of non-NULL records.
Syntax
VAR_POP(numeric_expression int64) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_POP(pop)
FROM eth.recent_blocks
-- 1.5167869917122573E8
VAR_POP(numeric_expression double) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_POP(gas_used)
FROM eth.recent_blocks
-- 181.26187022731304
VAR_POP(numeric_expression float) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_POP(gas_used)
FROM eth.recent_blocks
-- 181.26187022731304
VAR_POP(numeric_expression int32) → double
numeric_expression: The set of records to calculate variance for.
Examples
SELECT VAR_POP(pop)
FROM eth.recent_blocks
-- 1.5167869917122573E8
Last updated
Was this helpful?