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;