with RankedHouseHold as (
    select
        PERSON_CODE,
        CLASS_CODE,
        PERSON_NAME,
        CLASS_NAME,
        AMT,
        rank() over(partition by CLASS_CODE order by AMT desc) as amt_rank
    from Household
    where person_code != '1'
    and class_code != '01'
)
select
    CLASS_NAME CLASS,
    PERSON_NAME PERSON,
    AMT HOUSEHOLDS
from RankedHouseHold
where amt_rank = 1
order by CLASS_CODE