WITH pop1 AS (
SELECT STDDEV(Los) st1, Avg(Los) x1, Count() n1
FROM Prepare Gndr vs LOS output
WHERE Gdr_Cd = 'M'
),
pop2 AS (
SELECT STDDEV(Los) st2, Avg(Los) x2, Count() n2
FROM Prepare Gndr vs LOS output
WHERE Gdr_Cd = 'F'
)
SELECT
(x1 - x2) / Sqrt((st1 st1 / N1) + (st2 st2/ N2)) AS t,
n1+n2-2 AS df
FROM pop1 CROSS JOIN pop2
WITH pop1 AS ( SELECT STDDEV(Los) st1, Avg(Los) x1, Count() n1 FROM
Prepare Gndr vs LOS output
WHERE Gdr_Cd = 'M' ), pop2 AS ( SELECT STDDEV(Los) st2, Avg(Los) x2, Count() n2 FROMPrepare Gndr vs LOS output
WHERE Gdr_Cd = 'F' ) SELECT (x1 - x2) / Sqrt((st1 st1 / N1) + (st2 st2/ N2)) AS t, n1+n2-2 AS df FROM pop1 CROSS JOIN pop2