select
    USER_ID as USER,
    POINT as PT,
    (
        (POINT - avg.avg) * 10 / (sqrt(avg(power(avg.avg, 2))))
    ) + 50 as DEV_VAL
from
    TEST_RESULTS
    inner join(
        select
            avg(POINT) as avg
        from
            TEST_RESULTS
        where
            TEST_ID = '100'
    ) as avg
where
    TEST_ID = '100'
order by
    DEV_VAL desc,
    USER_ID;

select
    USER_ID as USER,
    POINT as PT,
    case
        when hyoujyunhensa <> 0 then ROUND(
            (
                POINT - (
                    SELECT
                        AVG(POINT)
                    FROM
                        TEST_RESULTS
                    where
                        TEST_ID = '100'
                )
            ) * 10 / hyoujyunhensa + 50,
            1
        )
        else 50.0
    end as DEV_VAL
from
    TEST_RESULTS
    inner join(
        select
            sqrt(AVG(POWER)) as hyoujyunhensa
        from
            (
                select
                    POWER(
                        POINT - (
                            SELECT
                                AVG(POINT)
                            FROM
                                TEST_RESULTS
                            where
                                TEST_ID = '100'
                        ),
                        2
                    ) as POWER
                from
                    TEST_RESULTS
                where
                    TEST_ID = '100'
            )
    ) as hyoujyunhensa
where
    TEST_ID = '100'
order by
    DEV_VAL desc,
    USER_ID