With AVG_P AS (
	SELECT AVG(POINT) AVGP
	FROM TEST_RESULTS
	WHERE TEST_ID = '100'
),
DIFF AS (
	SELECT
	 USER_ID
	,POINT-AVGP DIFP
	,(POINT-AVGP) * (POINT-AVGP) SQNM
	FROM TEST_RESULTS,AVG_P
	WHERE TEST_ID = '100'
),
HENSA AS (
	SELECT SQRT(AVG(SQNM)) HENSA
	FROM DIFF
)
SELECT
 USER_ID USER
 ,POINT PT
,ROUND((((POINT-AVGP) * 10) / HENSA) + 50,2)
FROM TEST_RESULTS,AVG_P,HENSA
WHERE TEST_ID = '100'
ORDER BY ROUND((((POINT-AVGP) * 10) / HENSA) + 50,2) DESC,USER_ID
;