select
	USER, PT,
	IFNULL(ROUND(AVG_POINT * 10.0 / SQRT(AVG(AVG_POINT_POW) OVER()) + 50.0, 1), 50.0) as DEV_VAL
from
	(select
		USER_ID as USER,
		POINT as PT,
		POINT - AVG(POINT) OVER() AVG_POINT,
		POW(POINT - AVG(POINT) OVER(), 2) AVG_POINT_POW
	from
		TEST_RESULTS
	where
		TEST_ID = '100'
	)
order by
	DEV_VAL desc, USER