select 
  h1.CLASS_NAME as CLASS
  ,h1.PERSON_NAME as PERSON
  ,h1.AMT as HOUSEHOLDS
from HOUSEHOLD h1
left outer join (select MAX(AMT) as MAX_AMT,CLASS_CODE FROM HOUSEHOLD where PERSON_CODe != 1 and CLASS_CODE != '01' and AMT is not null GROUP BY CLASS_CODE) h2
on h1.CLASS_CODE = h2.CLASS_CODE
where
  h1.PERSON_CODE != 1
  and h1.CLASS_CODE != '01'
  and h1.AMT = h2.MAX_AMT
group by h1.CLASS_CODE
order by h1.CLASS_CODE asc