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