select
        a.age,
        case
            when a.gender_code = 20 then 'MALE'
            when a.gender_code = 30 then 'FEMALE'
            else null end as "GENDER",
        round(avg(case when a.category_code = 10 and a.average_value >= b.average_value then a.average_value else null end), 1) as "H_AVG",
        round(100.0 * cast(sum(case when a.category_code = 10 and a.average_value >= b.average_value then 1 else null end) as numeric)
        / cast(sum(case when a.category_code = 10 then 1 else null end) as numeric), 1) as "H_PER",
        
        round(avg(case when category_code = 20 and a.average_value >= b.average_value then a.average_value else null end), 1) as "W_AVG",
        round(100.0 * cast(sum(case when category_code = 20 and a.average_value >= b.average_value then 1 else null end) as numeric)
        / cast(sum(case when category_code = 20 then 1 else null end) as numeric), 1) as "W_PER"
        
        
        
    from (select * from school_health where survey_year = 2019) as a
    inner join (
        select
            category_code,
            gender_code,
            age,
            round(avg(average_value), 1) as average_value
        from school_health
        where survey_year = 2019
        group by 1, 2, 3) as b
    using(category_code, gender_code, age)
    group by 1, 2
    order by 1 desc, a.gender_code desc