with grep as(
    select
        *
    from
        TEST_RESULTS
    where
        TEST_ID = '100'
),
ave as (
    select
        avg(POINT) a
    from
        grep
),
res as(
    select
        sqrt(avg(POINT * POINT) - avg(POINT) * avg(POINT)) r
    from
        grep
),
com as(
    select
        case
            when r = 0 then 50
            else round(((POINT - a) * 10) / r + 50, 1)
        end c,
        USER_ID,
        POINT
    from
        grep,
        ave,
        res
)
select
    USER_ID USER,
    POINT PT,
    c DEV_VAL
from
    com
ORDER BY
    c DESC,
    USER_ID