SELECT
    USER_ID AS USER,
    POINT AS PT,
    ROUND((POINT - AVERAGE) * 10 / STD, 1) + 50 AS DEV_VAL
FROM (
    SELECT
        USER_ID,
        POINT,
        AVERAGE,
        SQRT(AVG(POW(HENSA, 2)) OVER ()) AS STD
    FROM (
        SELECT
            USER_ID,
            POINT,
            AVG(POINT) OVER () AS AVERAGE,
            ABS(AVG(POINT) OVER () - POINT) AS HENSA
        FROM
            TEST_RESULTS
        WHERE
            TEST_ID = '100'
    )
)
ORDER BY 
    DEV_VAL DESC,
    USER_ID ASC
;