with tmp as(
select CLASS_NAME as CLASS,CLASS_CODE,
PERSON_NAME as PERSON,
amt,
max(amt) over(partition by CLASS_CODE) as maxamt
  from HOUSEHOLD
 where PERSON_CODE != '1'
   and CLASS_CODE != '01')
select CLASS,PERSON,amt as HOUSEHOLDS
  from tmp
 where amt= maxamt
order by CLASS_CODE