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