select
    R.USER_ID as USER
  , R.POINT as PT
  , case
      when R3.HH = 0 then 50
      else round(((R.POINT - R3.AVG) * 10) / R3.HH + 50, 1)
    end 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
;