with TESTID_100 as (
    select USER_ID, POINT
    from TEST_RESULTS
    where TEST_ID = '100'
),
a as (
    select AVG(POINT) as ave
    from TESTID_100
    
),
t as (
    select POINT - ave as diff,
        USER_ID
    from a, TESTID_100
    
),
a1 as (
    select POWER(AVG(POWER(diff,2)), 0.5) as ave2
    from t
),
j as (
    select ROUND(((diff * 10) / ave2) + 50, 2) as waru,
        USER_ID
    from t, a1
)


select t.USER_ID as USER,
    t.POINT as PT,
    j.waru as DEV_VAL
from TESTID_100 t
inner join j using(USER_ID)
order by waru, USER_ID