with t1 as(
select
    CLASS_NAME as CLASS
    -- ,PERSON_NAME as PERSON
    ,max(AMT) as HOUSEHOLDS
from HOUSEHOLD
where PERSON_CODE <> '1' and CLASS_CODE <> '01'
group by 1
order by 1
)
-- select * from 
select 
    H.CLASS_NAME AS CLASS
    ,H.PERSON_NAME AS PERSON
    ,H.AMT AS HOUSEHOLDS
from
t1
inner join HOUSEHOLD H
on t1.CLASS = H.CLASS_NAME and t1.HOUSEHOLDS = H.AMT
order by 1