select
    t.USER_ID as USER
    ,t.POINT as PT
    ,case when round(50+10*(t.POINT - t1.avg_POINT)/t4.avg_db,1) = 0 then 50
        else round(50+10*(t.POINT - t1.avg_POINT)/t4.avg_db,1) end as DEV_VAL
from TEST_RESULTS t
    cross join (
        select AVG(POINT) as avg_POINT from TEST_RESULTS
        where TEST_ID = '100'
    ) t1
    cross join (
        select sqrt(avg((t2.POINT - t3.avg_POINT)*(t2.POINT - t3.avg_POINT))) as avg_db
        from TEST_RESULTS t2
            cross join (
                select AVG(POINT) as avg_POINT from TEST_RESULTS
                where TEST_ID = '100'
            ) t3
        WHERE t2.TEST_ID = '100'
    ) t4
WHERE t.TEST_ID = '100'
ORDER BY DEV_VAL desc, USER