select
  h.CLASS_NAME as CLASS
  ,h.PERSON_NAME as PERSON
  ,h.AMT as HOUSEHOLDS
from HOUSEHOLD h
inner join (
  select
    max(AMT) AMT
    ,CLASS_CODE
  from HOUSEHOLD
  where
    PERSON_CODE <> '1'
    and CLASS_CODE <> '01'
  group by
    CLASS_CODE
) h2
on h.CLASS_CODE = h2.CLASS_CODE
and h.AMT = h2.AMT

order by
  h.CLASS_CODE asc