SELECT A.AGE
,CASE WHEN A.GENDER_CODE = 20 THEN 'MALE'
	WHEN A.GENDER_CODE = 30 THEN 'FEMALE'
 END GENDER
,A.H_AVG,B.W_AVG
FROM
(
	SELECT AGE,GENDER_CODE,ROUND(AVG(AVERAGE_VALUE),1) H_AVG
	FROM SCHOOL_HEALTH
	WHERE SURVEY_YEAR = 2019
	AND CATEGORY_CODE = 10
	GROUP BY CATEGORY_CODE,GENDER_CODE,AGE
) A,(
	SELECT AGE,GENDER_CODE,ROUND(AVG(AVERAGE_VALUE),1) W_AVG
	FROM SCHOOL_HEALTH
	WHERE SURVEY_YEAR = 2019
	AND CATEGORY_CODE = 20
	GROUP BY CATEGORY_CODE,GENDER_CODE,AGE
) B
WHERE A.AGE = B.AGE
AND A.GENDER_CODE = B.GENDER_CODE