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 Household
    where person_code != '1'
    and class_code != '01'
)
where rank = 1
order by CLASS_CODE