with temp_tbl as
(
select
  CLASS_CODE
  ,CLASS_NAME as CLASS
  ,PERSON_NAME as PERSON
  ,AMT as HOUSEHOLDS
  ,row_number() over (partition by CLASS_NAME order by AMT desc) as ranking
from HOUSEHOLD
where PERSON_CODE <> '1'
 and CLASS_CODE <> '01'
)
select 
  CLASS
  ,PERSON
  ,HOUSEHOLDS
from temp_tbl
where ranking=1
order by CLASS_CODE