with AVERAGE AS
(
SELECT
平均,
分散,
pow(分散,0.5) AS 標準偏差
FROM
(
SELECT
平均,
AVG(pow(POINT - 平均,2)) AS 分散
FROM
(SELECT
POINT,
AVG(POINT) AS 平均
FROM
TEST_RESULTS
WHERE
TEST_ID = '100' )
)
)

SELECT 
USER_ID AS USER,
POINT AS PT,
(((POINT - 平均)*10)/AVERAGE.標準偏差) + 50 AS 偏差値
FROM
TEST_RESULTS,AVERAGE
WHERE
TEST_RESULTS.TEST_ID = '100' 
ORDER BY 偏差値 DESC,USER_ID ASC