SELECT
    AGE,
    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), 1) AS H_AVG,
    ROUND(AVG(CASE WHEN CATEGORY_CODE = '20' THEN AVERAGE_VALUE END), 1) AS W_AVG,
    H_PER,
    W_PER
FROM
    SCHOOL_HEALTH
WHERE
    SURVEY_YEAR = 2019
GROUP BY
    AGE, GENDER
ORDER BY
    AGE DESC, GENDER DESC;