with avg as (
    select 
        avg1.avgp as avg2,
        SQRT(avg(pow((POINT-avg1.avgp),2))) as st 
    from TEST_RESULTS cross join (select
                                    avg(POINT) as avgp 
                                        from TEST_RESULTS 
                                    where TEST_ID = '100') as avg1
        where TEST_ID = '100'
)
    select 
        USER_ID as USER,
        POINT as PT,
    case
        when avg.st = 0 then 50
            else round((((POINT- avg.avg2) * 10) / avg.st ) + 50,1) 
                end as DEV_VAL 
        from TEST_RESULTS cross join avg where TEST_ID = '100'
    order by 
        DEV_VAL desc,
        USER_ID asc;