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