WITH one as (
SELECT USER_ID,
POINT,
(SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = '100') AS AVGP,
(SELECT count(*) FROM TEST_RESULTS WHERE TEST_ID = '100') AS NUM
FROM TEST_RESULTS
WHERE TEST_ID = '100'),
two AS (
SELECT 
USER_ID AS USER,
POINT AS PT,
AVGP,
(SELECT SUM((POINT - AVGP)*(POINT - AVGP))/NUM AS STD FROM one) AS STD
FROM one
)
SELECT USER,
PT,
ROUND((PT - AVGP)*10/STD + 50, 1) AS DEV_VAL
FROM two
ORDER BY DEV_VAL DESC, USER ASC
--SELECT * FROM two