with 
    sub as(
        select
            USER_ID
            ,TEST_ID
            ,POINT
            --平均値
            ,AVG(POINT) OVER() as Ave
        from TEST_RESULTS
        where TEST_ID = '100'
    )
    ,sub2 as (
        select
            SQRT(AVG((POINT-Ave)*(POINT-Ave))) as Dev 
        from sub
        )
--select * from sub2
select
    sub.USER_ID as USER
    ,sub.POINT as PT
    ,round(((sub.POINT - sub.Ave)*10)/sub2.Dev,1)+50 as DEV_VAL
from 
    sub
    join sub2
where sub.TEST_ID = '100'
order by
    DEV_VAL desc
    ,USER asc