WITH test_data AS (
SELECT USER_ID, POINT
FROM TEST_RESULTS
WHERE TEST_ID = '100'
)
SELECT
USER_ID AS "USER",
POINT AS "PT",
CASE
WHEN STDDEV_SAMP(POINT) = 0 THEN 50
ELSE ROUND((POINT - AVG(POINT) OVER ()) / STDDEV_SAMP(POINT) OVER () * 10 + 50, 1)
END AS "DEV_VAL"
FROM test_data
ORDER BY "DEV_VAL" DESC, "USER" ASC;