SELECT
 AGE as  AGE
 --,GENDER_CODE('20'は 'MALE' 、'30'は 'FEMALE' と表示する) as  GENDER
 ,CASE WHEN GENDER_CODE = 20 THEN 'MALE' 
       WHEN GENDER_CODE = 30 THEN 'FEMALE' END AS GENDER
 ,ROUND(avg(CASE WHEN CATEGORY_CODE = 10 THEN AVERAGE_VALUE END),2) AS H_AVG
--  ,身長平均値以上の割合 as  H_PER
 ,ROUND(avg(CASE WHEN CATEGORY_CODE = 20 THEN AVERAGE_VALUE END),2) AS W_AVG
--  ,体重平均値以上の割合 as  W_PER
FROM 
 SCHOOL_HEALTH
WHERE
 SURVEY_YEAR = '2019'
 and GENDER_CODE = '20'
GROUP BY 
 AGE,GENDER
ORDER BY 
 AGE desc
 ,GENDER_CODE desc
;