SELECT
	TS1.USER_ID AS USER,
	POINT AS PT,
	ROUND((((POINT - AVGPOINT) * 10) / (SQRT(BUNSAN))) + 50, 1) AS DEV_VAL
FROM
	TEST_RESULTS AS TS1
INNER JOIN
	(
		SELECT
			TEST_ID,
			USER_ID,
			AVGPOINT,
			AVG((POINT - AVGPOINT) * (POINT - AVGPOINT)) AS BUNSAN
		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