SKEWNESS

Aggregate function.

The SKEWNESS() function returns the skewness of all input values.

Analyze Syntax

func.skewness(<expr>)

Analyze Examples

func.skewness(table.temperature).alias('temperature_skewness') | temperature_skewness | |----------------------| | 0.68 |

SQL Syntax

SKEWNESS(<expr>)

Arguments

ArgumentsDescription
<expr>Any numerical expression

Return Type

Nullable Float64.

SQL Examples

Create a Table and Insert Sample Data

CREATE TABLE temperature_data ( id INT, city_id INT, temperature FLOAT ); INSERT INTO temperature_data (id, city_id, temperature) VALUES (1, 1, 60), (2, 1, 65), (3, 1, 62), (4, 2, 70), (5, 2, 75);

Query Demo: Calculate Skewness of Temperature Data

SELECT SKEWNESS(temperature) AS temperature_skewness FROM temperature_data;

Result

| temperature_skewness | |----------------------| | 0.68 |