select 
    TESTUSER_TBL.USER_ID as USER, 
    TESTUSER_TBL.POINT as PT, 
--    TESTUSER_TBL.AVGPOINT, 
--    STD_HENSA.STDHENSA,
    CASE WHEN STD_HENSA.STDHENSA=0 THEN 50.0
    ELSE ROUND((TESTUSER_TBL.DIVPOINT * 10 / STD_HENSA.STDHENSA) + 50.0, 1)
    END  as DEV_VAL
FROM (SELECT T2.USER_ID, T2.POINT, AVGTBL.AVGPOINT, (T2.POINT-AVGTBL.AVGPOINT) as DIVPOINT
                FROM TEST_RESULTS T2,
                     (SELECT AVGPOINT FROM (select AVG(POINT) as AVGPOINT from TEST_RESULTS where TEST_ID='100')) AVGTBL
               WHERE T2.TEST_ID='100'
     ) TESTUSER_TBL,
     (SELECT SQRT(AVG(BUNSAN)) as STDHENSA
        FROM (SELECT T1.USER_ID, T1.POINT, AVGTBL.AVGPOINT, T1.POINT-AVGTBL.AVGPOINT as DIVPOINT, (T1.POINT-AVGTBL.AVGPOINT)*(T1.POINT-AVGTBL.AVGPOINT) as BUNSAN
                FROM TEST_RESULTS T1,
                     (SELECT AVGPOINT FROM (select AVG(POINT) as AVGPOINT from TEST_RESULTS where TEST_ID='100')) AVGTBL
               WHERE T1.TEST_ID='100') BUNSAN_TBL
     ) STD_HENSA
order by DEV_VAL desc,
USER asc
;