WITH TMP AS(
SELECT 
    USER_ID
    ,POINT
    ,AVG(POINT) OVER (PARTITION BY TEST_ID) AS KEI
    ,(POINT - AVG(POINT) OVER (PARTITION BY TEST_ID)) * (POINT - AVG(POINT) OVER (PARTITION BY TEST_ID)) AS A
FROM TEST_RESULTS
WHERE TEST_ID = '100'
)

,COUNT_USER AS(
    SELECT
        COUNT(USER_ID) AS COUNT
    FROM TEST_RESULTS
    WHERE TEST_ID = '100'
)

SELECT
    USER_ID
    ,POINT AS PT
    ,ROUND(((POINT-KEI)/SQRT(SUM(A) OVER()/COUNT))*10+50, 1) AS DEV_VAL
FROM TMP CROSS JOIN COUNT_USER
ORDER BY 3 DESC,1