with
a as (
    select
        CLASS_NAME
        ,MAX(AMT) as max_amt
    from HOUSEHOLD h
    where h.PERSON_CODE != '1' and h.CLASS_CODE != '01'
    group by CLASS_NAME
)
select
h.CLASS_NAME as CLASS
,h.PERSON_NAME as PERSON
,h.AMT as HOUSEHOLDS
from HOUSEHOLD h
join a
    on h.amt = a.max_amt
group by h.CLASS_NAME
order by class_code