with t 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 r
  from HOUSEHOLD
  where PERSON_CODE != '1' and CLASS_CODE != '01'
)
select CLASS, PERSON, HOUSEHOLDS 
from t
where r = 1
order by CLASS_CODE