with T as (
select
  CLASS_CODE
  ,CLASS_NAME
  , PERSON_NAME
  , AMT
  , ROW_NUMBER() OVER (PARTITION BY CLASS_CODE ORDER BY AMT DESC) AS RANK
from HOUSEHOLD
where PERSON_CODE <> '1' and CLASS_CODE <> '01'
)
select
  CLASS_NAME as CLASS
  , PERSON_NAME as PERSON
  , AMT as HOUSEHOLDS
from T
where RANK = 1
order by CLASS_CODE ASC;