SELECT
	TR.USER_ID AS USER,
	TR.POINT AS PT,
	ROUND(((TR.POINT - T_AVG.AP) * 10) / (SQRT(T_BUN.BUN)) + 50, 1) AS DEV_VAL
FROM
	TEST_RESULTS TR
	LEFT JOIN (SELECT TEST_ID, AVG(POINT) AS AP FROM TEST_RESULTS WHERE TEST_ID = '100') T_AVG
	ON TR.TEST_ID = T_AVG.TEST_ID
	CROSS JOIN (SELECT
					AVG((TR3.POINT - T_AVG2.AP) * (TR3.POINT - T_AVG2.AP)) AS BUN
				FROM TEST_RESULTS TR3
					 LEFT JOIN (SELECT TEST_ID, AVG(POINT) AS AP FROM TEST_RESULTS WHERE TEST_ID = '100') T_AVG2
					 ON TR3.TEST_ID = T_AVG2.TEST_ID
				) AS T_BUN
WHERE
	TR.TEST_ID = '100'
GROUP BY
	TR.USER_ID,
	TR.POINT
ORDER BY
	DEV_VAL DESC,
	TR.USER_ID
	;