finding outlier in sql

PHOTO EMBED

Tue Apr 05 2022 05:09:27 GMT+0000 (Coordinated Universal Time)

Saved by @Bambibo9799

no
2
3
4
5
56
676
43
4
5
----dataset

with t1 as(
select *
, STDDEV ("no") OVER () AS ST 
, AVG ("no") OVER ()    AS AV
from pizza_runner.zz_csv
)

select *
from t1
WHERE no BETWEEN AV - ST AND AV + ST;
content_copyCOPY