WITH DIF AS(
SELECT
    USER_ID
    ,TEST_ID
    ,POINT AS PT
    ,POINT - (SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = '100') AS DIFF
FROM
    TEST_RESULTS
WHERE
    TEST_ID = '100'
)
,STDE AS(
SELECT
    USER_ID
    ,PT
    ,SQRT(AVG(DIFF*DIFF) OVER()) AS STD
FROM
    DIF
)
SELECT
    USER_ID
    ,PT
    ,CASE WHEN STD != 50 THEN ROUND(10*(PT - (SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = '100'))/STD + 50,1) ELSE 50 END AS DEV_VAL
FROM
    STDE
ORDER BY
    DEV_VAL DESC
    ,USER_ID ASC
;