See
STDDEV_POP is allowed only on expressions that evaluate to numeric data types.
The expression can contain multiple column references or expressions, but it cannot contain another aggregate or subquery. It must evaluate to a built-in numeric data type. If an expression evaluates to NULL, the aggregate skips that value.
The resulting data type is DOUBLE (it might overflow).
Standard deviation is calculated as follows: