SELECT
	TS1.USER_ID AS USER,
	POINT AS PT,
	(CASE 
	    WHEN TMPSQRT = 0
	        THEN 50
	    ELSE
	        ROUND((((POINT - AVGPOINT) * 10) / (TMPSQRT)) + 50, 1)
	END)AS DEV_VAL
FROM
	TEST_RESULTS AS TS1
INNER JOIN
	(
		SELECT
			TEST_ID,
			USER_ID,
			AVGPOINT,
			SQRT(AVG((POINT - AVGPOINT) * (POINT - AVGPOINT))) AS TMPSQRT
		FROM
			TEST_RESULTS
		INNER JOIN
		    (SELECT AVG(T.POINT) AS AVGPOINT FROM TEST_RESULTS AS T WHERE TEST_ID = '100') AS AVGTBL
		WHERE
			TEST_ID = '100'
	) AS TS2
    ON TS1.TEST_ID = TS2.USER_ID AND TS1.TEST_ID = TS2.USER_ID
WHERE
	TS1.TEST_ID = '100'
ORDER BY
	DEV_VAL DESC,
	USER