SELECT
	AGE AS AGE
	, CASE GENDER_CODE
		WHEN '20' THEN 'MALE' 
		WHEN '30' THEN 'FEMALE'
	  END AS GENDER
	, (SELECT AVG(AVERAGE_VALUE) FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '10') AS H_AVG
	, (SELECT (SELECT COUNT(AVERAGE_VALUE) FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '10' AND AVERAGE_VALUE >=  (SELECT AVG(AVERAGE_VALUE) FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '10')) / COUNT(AVERAGE_VALUE) * 100 FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '10') AS H_PER
	, (SELECT AVG(AVERAGE_VALUE) || '％' FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '20') AS W_AVG
	, (SELECT (SELECT COUNT(AVERAGE_VALUE) FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '20' AND AVERAGE_VALUE >=  (SELECT AVG(AVERAGE_VALUE) FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '20')) / COUNT(AVERAGE_VALUE) * 100 || '％' FROM SCHOOL_HEALTH WHERE CATEGORY_CODE = '20') AS W_PER
FROM
	SCHOOL_HEALTH
WHERE
	SURVEY_YEAR = 2019
ORDER BY
	AGE    DESC
	, GENDER_CODE DESC
;
	--絶対違う～～～時間ない～～～(>_<。)