SELECT
	r1.USER_ID AS USER,
	r1.POINT AS PT,
	CASE WHEN c.SVG = 0 THEN 0
	ELSE (r1.POINT - c.AVG) * 10 / c.SVG + 50
	END AS DEV_VAL
FROM
	TEST_RESULTS r1
	CROSS JOIN
(
SELECT
	SQRT(AVG(POW((r.POINT - a.AVG), 2))) AS SVG,
	MIN(a.AVG) AS AVG
FROM
	TEST_RESULTS r
	CROSS JOIN
	(
		SELECT
			AVG(POINT) AS AVG
		FROM
			TEST_RESULTS
		WHERE
			TEST_ID = 100
	) a
WHERE
	r.TEST_ID = 100
) c
WHERE
	r1.TEST_ID = 100
ORDER BY
	DEV_VAL DESC,
	r1.USER_ID