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