with T1 as(
select
    avg(POINT) as AV
from TEST_RESULTS 
where TEST_ID = '100'
)
,T2 as(
select
    sqrt(avg(pow(POINT-T1.AV,2))) as DV
from TEST_RESULTS 
cross join T1
where TEST_ID = '100'
)

select
USER_ID as USER
,POINT as PT
,case when DV!=0 then round((TR.POINT-T1.AV)*10/T2.DV,1)+50 else 50 end as DEV_VAL
from TEST_RESULTS as TR
cross join T1
cross join T2
where TEST_ID = '100'
order by DEV_VAL desc,USER_ID asc