select
    AGE as AGE,
    GENDER_CODE('20'は 'MALE' 、'30'は 'FEMALE' と表示する) as GENDER,
    身長の平均値 as H_AVG,
    身長平均値以上の割合 as H_PER,
    体重の平均値 as W_AVG,
    体重平均値以上の割合 as W_PER
from
    SCHOOL_HEALTH
where
    SURVEY_YEAR = 2019