select a.CLASS_NAME as CLASS
, a.PERSON_NAME as PERSON
, a.AMT as HOUSEHOLDS
from (
select h0.*
, rank() over(partition by h0.CLASS_CODE order by h0.AMT desc) as rank
from HOUSEHOLD h0
where h0.PERSON_CODE <> '1'
and h0.CLASS_CODE <> '01'
) a
where a.rank = 1
order by a.CLASS_CODE
;