with
    t as
    (
        select
            USER_ID,
            POINT
        from
            TEST_RESULTS
        where
            TEST_ID = 100
    ),
    a as
    (
        select
            avg(POINT) as av
        from
            t
    ),
    t1 as
    (
        select
            USER_ID,
            POINT - av as s,
            POINT
        from
            t, a
    ),
    a2 as
    (
        select
            pow(avg(pow(s, 2)), 0.5) as av2
        from
            t1
    )
select
    USER_ID as USER,
    POINT as PT,
    round(s * 10 / av2 + 50, 1) as DEV_VAL
from
    t1, a2
order by
    DEV_VAL desc,
    USER_ID
;