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 
        case when 0 then 50
        else SQRT(AVG(POWER(diff,2)))
        end as ave2
    from t
),
j as (
    select ROUND(((diff * 10) / ave2) + 50, 1) 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 DESC, USER_ID