with source as(
    select
        AGE 
        , GENDER_CODE
        , CATEGORY_CODE
        , round(avg(AVERAGE_VALUE), 1) as 'AVG'
        , cast(count(*) as REAL) 'TOTAL_COUNT'
    from
        SCHOOL_HEALTH s
    where
        SURVEY_YEAR = 2019
    group by
        AGE
        , GENDER_CODE
        , CATEGORY_CODE
)