select
    R.USER_ID as USER
  , R.POINT as PT
  , round(((R.POINT - R3.AVG) * 10) / R3.HH + 50, 1) as DEV_VAL
from
    TEST_RESULTS as R
  , (
select
    R2.AVG as AVG
  , SQRT(AVG(POW(R.POINT - R2.AVG , 2))) as HH
from
    TEST_RESULTS as R
  , (select avg(POINT) as AVG
     from TEST_RESULTS) as R2
where
    R.TEST_ID = '100'

) as R3
where
    R.TEST_ID = '100'
order by
    round(((R.POINT - R3.AVG) * 10) / R3.HH + 50, 1) desc
  , R.USER_ID
;