with
a as (
    select
        CLASS_NAME
        ,MAX(PERSON_CODE) as max_person_code
    from HOUSEHOLD
    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 a.CLASS_NAME = h.CLASS_NAME
where h.PERSON_CODE != '1' and h.CLASS_CODE != '01'
group by h.CLASS_NAME
order by class_code