select 
a.CLASS_NAME as CLASS,
a.PERSON_NAME as PERSON,
a.AMT as HOUSEHOLDS
from HOUSEHOLD a join (
 select 
 CLASS_CODE,
 MAX(AMT) as amt2
from HOUSEHOLD 
where PERSON_CODE <> '1'
 and CLASS_CODE <> '01'
group by CLASS_CODE)
 wk
 on a.CLASS_CODE = wk.CLASS_CODE
  and a.AMT = wk.amt2