SELECT
    AGE,
    CASE GENDER_CODE
        WHEN '20' THEN 'MALE'
        WHEN '30' THEN 'FEMALE'
    END AS GENDER,
    ROUND(AVG(CASE WHEN CATEGORY_CODE = '10' THEN AVERAGE_VALUE END), 2) AS H_AVG,
    ROUND(AVG(CASE WHEN CATEGORY_CODE = '20' THEN AVERAGE_VALUE END), 2) AS W_AVG,
    ROUND(SUM(CASE WHEN CATEGORY_CODE = '10' AND AVERAGE_VALUE >= H_AVG THEN 1 ELSE 0 END) * 100.0 / COUNT(*), 2)　over AS H_PER,
    ROUND(SUM(CASE WHEN CATEGORY_CODE = '20' AND AVERAGE_VALUE >= W_AVG THEN 1 ELSE 0 END) * 100.0 / COUNT(*), 2) over AS W_PER
FROM
    SCHOOL_HEALTH
WHERE
    SURVEY_YEAR = 2019
GROUP BY
    AGE,
    GENDER_CODE
ORDER BY
    AGE DESC,
    GENDER_CODE DESC;