with  hightdata as(
select CATEGORY_CODE,GENDER_CODE,AGE, sum(AVERAGE_VALUE)
from SCHOOL_HEALTH
where SURVEY_YEAR=2019
and CATEGORY_CODE='10'
GROUP BY AGE,CATEGORY_CODE,GENDER_CODE
),weightdata as (
select CATEGORY_CODE,GENDER_CODE,AGE, sum(AVERAGE_VALUE)
from SCHOOL_HEALTH
where SURVEY_YEAR=2019
and CATEGORY_CODE='20'
GROUP BY AGE,CATEGORY_CODE,GENDER_CODE
)


select 
AGE
, case GENDER_CODE
    when '20' then 'MALE'
    else            'FEMALE'
    end as GENDER
--,CATEGORY_CODE
--,SUM(AVERAGE_VALUE)
,round(AVG(AVERAGE_VALUE),2) as avg
from hightdata

where SURVEY_YEAR=2019
GROUP BY AGE,CATEGORY_CODE,GENDER_CODE
order by AGE desc,GENDER_CODE desc