with AV as (
	select avg(POINT) AVP from TEST_RESULTS where TEST_ID = '100'
),
ST as (
	select
		sqrt(avg((T.POINT - AV.AVP) * (T.POINT - AV.AVP))) as STD
	from
		(select * from TEST_RESULTS where TEST_ID = '100') T
	cross join
		AV
)
select
	T.USER_ID as USER,
	T.POINT as PT,
	(case when ST.STD = 0 then 50 else round((((T.POINT - AV.AVP) * 10) / ST.STD) + 50, 1) end) as DEV_VAL
from
	(select * from TEST_RESULTS where TEST_ID = '100') T
cross join
	AV
cross join
	ST
order by 
	DEV_VAL desc,
	USER_ID asc