select
h_data.AGE as AGE,
CASE h_data.GENDER_CODE
 -- 20なら
 WHEN 20 THEN 'MALE'
 -- 30なら
 WHEN 30 THEN 'FEMALE'
 end as GENDER,
AVG(h_data.AVERAGE_VALUE) as H_AVG,
count(h_data.AVERAGE_VALUE >= H_AVG)/count(h_data.AVERAGE_VALUE) as H_PER,
AVG(w_data.AVERAGE_VALUE) as W_AVG,
count(w_data.AVERAGE_VALUE >= W_AVG)/count(w_data.AVERAGE_VALUE) as W_PER

from
SCHOOL_HEALTH as h_data
inner join SCHOOL_HEALTH as w_data
on h_data.SURVEY_YEAR = w_data.SURVEY_YEAR
and h_data.GENDER_CODE = w_data.GENDER_CODE
and h_data.AGE = w_data.AGE
and w_data.CATEGORY_CODE = "20"

where
h_data.CATEGORY_CODE = "10"
and SURVEY_YEAR = 2019



order by
h_data.AGE desc,GENDER_CODE desc;

-- ああああああ・・・