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
    )
order by CLASS_CODE