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