with max_amt as(
    select
        CLASS_CODE,
        max(AMT) as AMT
    from
        HOUSEHOLD
    where
        PERSON_CODE not in ('1')
        and CLASS_CODE not in ('01')
    group by
        1
)
select
    h.CLASS_NAME as CLASS,
    h.PERSON_NAME as PERSON,
    h.AMT as HOUSEHOLDS
from
    HOUSEHOLD as h
inner join
    max_amt as m
    on h.CLASS_CODE = m.CLASS_CODE
        and h.AMT = m.AMT
where
    h.PERSON_CODE not in ('1')
    and h.CLASS_CODE not in ('01')
order by
    h.CLASS_CODE