with ave as(
select cast(sum(point) as REAL )/cast(count(*) as REAL) as ave, cast(count(*) as REAL) as num from TEST_RESULTS where TEST_ID ='100'
), sabun as(
select *, cast(point as REAL)-(select ave from ave) sabun from TEST_RESULTS where TEST_ID ='100'
), beki as (
select *, sabun*sabun as beki from sabun
), sq as(
select sum(beki), sqrt(sum(beki)/(select num from ave)) as sq from beki
)
select USER_ID as USER, POINT as PT, 
case 
    when  (select sq from sq) <>0
    then round((cast(point as REAL)-(select ave from ave))*10/(select sq from sq) + 50, 1) 
    else 50
    end as DEV_VAL 
from TEST_RESULTS 
where TEST_ID ='100'
order by DEV_VAL desc, USER