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
        ((POINT - a) * 10) / r + 50 DEV_VAL,
        USER_ID,
        POINT
    from
        grep,
        ave,
        res
)
select
    USER_ID USER,
    POINT PT,
    round(DEV_VAL, 1) DEV_VAL
from
    com
ORDER BY
    DEV_VAL DESC,
    USER_ID