select
   USER_ID as USER
   ,POINT as PT
   ,case when sorta=0 then  round((POINT -  (select avg(POINT)  from TEST_RESULTS where TEST_ID = '100'))*10/50+ 50,1)
         else round((POINT -  (select avg(POINT)  from TEST_RESULTS where TEST_ID = '100'))*10/sorta+ 50,1)
    end as DEV_VAL
from TEST_RESULTS,
(
    select 
       sqrt(avg((POINT -  (select avg(POINT)  from TEST_RESULTS where TEST_ID = '100') ) * (POINT -  (select avg(POINT)  from TEST_RESULTS where TEST_ID = '100')))) as sorta --偏差値
    from TEST_RESULTS
    where TEST_ID = '100'
)
where TEST_ID = '100'
order by 
    round((POINT -  (select avg(POINT)  from TEST_RESULTS where TEST_ID = '100'))*10/sorta+ 50,1) desc,
    USER_ID