with SCHOOL_HEALTH_2019 as (
    select 
        * 
    from 
        SCHOOL_HEALTH
    where 
        SURVEY_YEAR = 2019
)
, HEIGHT as (
    select
        AGE
        , GENDER_CODE
        , avg(AVERAGE_VALUE) as H_AVG
    from 
        SCHOOL_HEALTH_2019
    group by 
        GENDER_CODE
        , AGE
    having 
        CATEGORY_CODE = '10'
)

select 
    *
from 
    HEIGHT 
order by 
    AGE desc
    , GENDER_CODE desc
;