WITH tmp1 AS(
SELECT
	USER_ID
	,POINT
	,(SELECT AVG(POINT) FROM TEST_RESULTS WHERE TEST_ID = '100') AS AVE
FROM
	TEST_RESULTS
WHERE TEST_ID = '100'
),tmp2 AS(
SELECT
    USER_ID
	,POINT
	,AVE
    ,(SELECT SQRT(AVG(POW(POINT-AVE,2))) FROM tmp1 ) AS STANDARD
FROM
    tmp1
)

SELECT
    USER_ID AS USER
	,POINT AS PT
	,CASE WHEN STANDARD = '0' THEN 50 ELSE ROUND((POINT-AVE)*10/STANDARD,1)+50 END AS DEV_VAL
FROM tmp2
ORDER BY DEV_VAL Desc,USER