select
  a.CLASS_NAME as CLASS,
  a.PERSON_NAME as PERSON,
  a.AMT as HOUSEHOLDS
from
  HOUSEHOLD a,
  (select
    CLASS_CODE as CLASS_CODE,
    max(AMT) as MAX_AMT
  from
    HOUSEHOLD
  where
    PERSON_CODE <> '1' and
    CLASS_CODE <> '01'
  group by
    CLASS_CODE) b
where
  a.CLASS_CODE = b.CLASS_CODE and
  a.AMT = b.MAX_AMT
order by
  a.CLASS_CODE asc