select
    CLASS_NAME as CLASS
    ,PERSON_NAME as PERSON
    ,AMT as HOUSEHOLDS
from
    HOUSEHOLD
where
    PERSON_CODE is not '1'
and
    CLASS_CODE is not '01'
GROUP BY
    CLASS
having
  max(AMT)
order by
    CLASS_CODE asc