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