select
    CLASS_NAME as CLASS,
    PERSON_NAME as PERSON,
    AMT as HOUSEHOLDS
from
    HOUSEHOLD
where
    PERSON_CODE != '1' and
    CLASS_CODE != '01' and
    PERSON_CODE is not null and
    CLASS_CODE is not null and
    PERSON_NAME is not null and 
    CLASS_NAME is not null and
    AMT is not null
group by
    CLASS_CODE
HAVING
    AMT = MAX(AMT)
order by
    CLASS_CODE asc
;