select AGE,GENDER,H_AVG,H_PER,W_AVG,W_PER from 
(
select havg.age                                                        AGE
     , case when havg.gender_code = '30' then 'FEMALE' else 'MALE' end GENDER

     , havg.val                                                        H_AVG
     , round((select 100.0 * cast(sum(case when cast(AVERAGE_VALUE as real) >= havg.val then 1 else 0 end) as real) /
                     cast(count(*) as real)
              from SCHOOL_HEALTH
              where SURVEY_YEAR = 2019
                and CATEGORY_CODE = '10'
                and age = havg.age
                and gender_code = havg.gender_code), 1) || '%'         H_PER
     , wavg.val                                                        W_AVG
     , round((select 100.0 * cast(sum(case when cast(AVERAGE_VALUE as real) >= wavg.val then 1 else 0 end) as real) /
                     cast(count(*) as real)
              from SCHOOL_HEALTH
              where SURVEY_YEAR = 2019
                and CATEGORY_CODE = '20'
                and age = havg.age
                and gender_code = havg.gender_code), 1) || '%'         W_PER
from (select age
           , GENDER_CODE
           , round(avg(AVERAGE_VALUE), 1) as val
      from SCHOOL_HEALTH
      where SURVEY_YEAR = 2019
        and CATEGORY_CODE = '10'
      group by age, GENDER_CODE) havg

     inner join
     (select age
           , GENDER_CODE
           , round(avg(AVERAGE_VALUE), 1) as val
      from SCHOOL_HEALTH
      where SURVEY_YEAR = 2019
        and CATEGORY_CODE = '20'
      group by age, GENDER_CODE) wavg
     on havg.age = wavg.age and
        havg.GENDER_CODE = wavg.GENDER_CODE

order by 1 desc, havg.gender_code desc
    )