with avg_value as(
    select avg(POINT) a,
            count(*) n
    from TEST_RESULTS
    where TEST_ID = '100'
    ),
    
    test_mem as(
    select *
    from TEST_RESULTS
    where TEST_ID = '100'
    ),
    
    dev_value_temp as(
    select pow((t.POINT - a.a),2) x2
    from TEST_RESULTS t,avg_value a
    where TEST_ID = '100'
    ),
    
    dev_value as(
    select sum(x2) as x2
    from dev_value_temp
    )
    
select t.USER_ID USER,
        t.POINT PT,
        round(50 + ((t.POINT - a.a)*10 / sqrt(d.x2 /a.n)), 1) DEV_VAL
from test_mem t, avg_value a, dev_value d
order by 3 desc,1 asc
;