var_pop.md

description
Returns the population variance of non-NULL records.

VAR_POP

Syntax

VAR_POP(numeric_expression int64) → double

• numeric_expression: The set of records to calculate variance for.

Examples

{% code title="VAR_POP example" %}

SELECT VAR_POP(pop) 
FROM eth.recent_blocks
-- 1.5167869917122573E8

{% endcode %}

VAR_POP(numeric_expression double) → double

• numeric_expression: The set of records to calculate variance for.

Examples

{% code title="VAR_POP example" %}

SELECT VAR_POP(gas_used) 
FROM eth.recent_blocks
-- 181.26187022731304

{% endcode %}

VAR_POP(numeric_expression float) → double

• numeric_expression: The set of records to calculate variance for.

Examples

{% code title="VAR_POP example" %}

SELECT VAR_POP(gas_used) 
FROM eth.recent_blocks
-- 181.26187022731304

{% endcode %}

VAR_POP(numeric_expression int32) → double

• numeric_expression: The set of records to calculate variance for.

Examples

{% code title="VAR_POP example" %}

SELECT VAR_POP(pop) 
FROM eth.recent_blocks
-- 1.5167869917122573E8

{% endcode %}