WITH BASE AS(
  SELECT
    *
  FROM
    TEST_RESULTS
  WHERE
    TEST_ID = '100'
),
AVG_POINT AS (
  SELECT
    avg(POINT)
  FROM
    BASE
),
BASE2 AS (
  SELECT
    USER_ID,
    POINT,
    (
      POINT - (
        SELECT
          *
        FROM
          AVG_POINT
      )
    ) * (
      POINT - (
        SELECT
          *
        FROM
          AVG_POINT
      )
    ) AS vari
  FROM
    BASE
),
STD_DEV AS(
  SELECT
    SQRT(SUM(vari) / count(*))
  FROM
    BASE2
),
BASE3 AS(
  SELECT
    USER_ID AS USER,
    POINT AS PT,
    ROUND(
      (
        CASE
          WHEN (
            SELECT
              *
            FROM
              STD_DEV
          ) = 0 THEN 50
          ELSE(
            (
              POINT - (
                SELECT
                  *
                FROM
                  AVG_POINT
              )
            ) * 10 / (
              SELECT
                *
              FROM
                STD_DEV
            ) + 50
          )
        END
      ),
      1
    ) AS DEV_VAL
  FROM
    BASE AS _
)
SELECT
  *
FROM
  BASE3
ORDER BY
  DEV_VAL DESC,
  USER