SELECT
  t.user_id as 'USER',
  t.point as 'PT',
  round(tmp97.p7, 1) as 'DEV_VAL'
FROM
TEST_RESULTS t
inner join (
select t97.*, 
  (t97.point - tmp98.p1),
  ((t97.point - tmp98.p1) * 10) as p5, 
  (((t97.point - tmp98.p1) * 10) / p4) as p6,
  ((((t97.point - tmp98.p1) * 10) / p4) + 50) as p7
from TEST_RESULTS t97,
(  
  select tmp99.p1 as p1, 
  case abs(sqrt(avg((t98.point - tmp99.p1) * (t98.point - tmp99.p1)))) 
  when 0 then 50
  else abs(sqrt(avg((t98.point - tmp99.p1) * (t98.point - tmp99.p1)))) 
  end as p4
  from TEST_RESULTS t98, (
    select avg(t99.point) as p1 from TEST_RESULTS t99
     where t99.TEST_ID = '100'
  ) tmp99
  where t98.TEST_ID = '100'
) tmp98
where t97.TEST_ID = '100'
) tmp97 on tmp97.user_id = t.user_id
where t.TEST_ID = '100'
ORDER BY
  tmp97.p7 desc,
  t.user_id