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, round((cast(point as REAL)-(select ave from ave))*10/(select sq from sq) + 50, 1) as DEV_VAL from TEST_RESULTS where TEST_ID ='100'
order by DEV_VAL desc, USER