WITH Average AS (
    SELECT AVG(POINT) AS AVG_POINT
    FROM TEST_RESULTS
    WHERE TEST_ID=100
),
Variance AS (
    SELECT SUM(POWER((POINT - (SELECT AVG_POINT FROM Average)), 2)) / COUNT(USER_ID) AS VAR_POINT
    FROM TEST_RESULTS
    WHERE TEST_ID=100
)
SELECT
    TR.USER_ID AS USER,
    TR.POINT AS PT,
    ROUND(((TR.POINT - (SELECT AVG_POINT FROM Average)) * 10 / POWER((SELECT VAR_POINT FROM Variance), 0.5)) + 50,1) AS DEV_VAL
FROM TEST_RESULTS TR
WHERE TEST_ID=100
ORDER BY
DEV_VAL DESC,
USER_ID ASC