select
    USER_ID POINT,
    ROUND(
        (
            POINT - (
                SELECT
                    AVG(POINT)
                FROM
                    TEST_RESULTS
                where
                    TEST_ID = '100'
            )
        ) * 10 / (
            select
                sqrt(AVG(POWER))
            from
                (
                    select
                        POWER(
                            POINT - (
                                SELECT
                                    AVG(POINT)
                                FROM
                                    TEST_RESULTS
                            ),
                            2
                        ) as POWER
                    from
                        TEST_RESULTS
                    where
                        TEST_ID = '100'
                )
        ) + 50,
        1
    ) as DEV_VAL
from
    TEST_RESULTS
where
    TEST_ID = '100'
order by
    DEV_VAL desc,
    USER_ID