select
    CLASS_NAME as CLASS,
    PERSON_NAME as PERSON,
    HOUSEHOLDS
from (
    select
        CLASS_NAME,
        CLASS_CODE,
        PERSON_NAME,
        sum(AMT) as HOUSEHOLDS,
        row_number() over(partition by CLASS_NAME order by sum(AMT) desc) as rank
    from
        HOUSEHOLD
    where
        PERSON_CODE != "1"
        and CLASS_CODE != "01"
    group by
        class_name,
        class_code,
        person_name
)
where
    rank = 1
order by
    cast(CLASS_CODE as int64) asc