© 2026 Hedgehog Software, LLC
CREATE VIEW view1 AS SELECT t.index_no, ( (t.total - AVG(t.total) OVER()) / ( SELECT SQRT(AVG(t.total * t.total) - (AVG(t.total) * AVG(t.total))) FROM view2 ) ) as zscore FROM view2 AS t`);