with SCH as
(
SELECT CATEGORY_CODE,AGE,GENDER_CODE,round(AVG(AVERAGE_VALUE),1) avgv,COUNT(AVERAGE_VALUE) CNT from
SCHOOL_HEALTH
where SURVEY_YEAR='2019'  AND CATEGORY_CODE='10'
group by CATEGORY_CODE,AGE,GENDER_CODE
),
SCH2 as
(
SELECT PF_CODE,CATEGORY_CODE,AGE,GENDER_CODE,round(AVG(AVERAGE_VALUE),1) avgv,COUNT(1)  from
SCHOOL_HEALTH
where SURVEY_YEAR='2019' AND CATEGORY_CODE='10'
group by PF_CODE,CATEGORY_CODE,AGE,GENDER_CODE
)
select A.*,COUNT(1),A.CNT FROM SCH A
join SCH2 B on A.CATEGORY_CODE =B.CATEGORY_CODE AND A.AGE =B.AGE AND A.GENDER_CODE AND B.GENDER_CODE
AND A.avgv<= B.avgv
GROUP BY A.CATEGORY_CODE,A.AGE,A.GENDER_CODE
order by A.AGE DESC,A.GENDER_CODE DESC