select
    CLASS_NAME CLASS,
    PERSON_NAME PERSON,
    AMT HOUSEHOLDS
from
    HOUSEHOLD
where
    PERSON_CODE <> '1'
    and CLASS_CODE <> '01'
group by
    CLASS
having
    AMT = max(AMT)
order by
    CLASS_CODE;