select 
  CLASS
  ,PERSON
  ,HOUSEHOLDS
from(
  select
    class_code
    ,class_name as CLASS
    ,person_name as PERSON
    ,amt as HOUSEHOLDS
    ,rank() over(partition by class_code order by amt desc) as ranking
  from household
  where person_code != '1'
    and class_code != '01'
) as sub
where ranking = 1
order by class_code
;