select USER, PT,
  round((PT- 平均) * 10 / sqrt(分散) + 50, 1) as DEV_VAL
  
from
(
select
  USER_ID as USER,
  POINT as PT,
  (select avg(POINT) from TEST_RESULTS) as 平均,
  (select avg(pow(t1.POINT - t2.average, 2))
   from TEST_RESULTS t1,
   (select avg(POINT) as average from TEST_RESULTS) as t2
  ) as 分散
from TEST_RESULTS
where 
  TEST_ID == '100'
)
order by DEV_VAL desc, USER asc
;