select 
 CLASS_NAME as CLASS
,PERSON_NAME as PERSON
,AMT as HOUSEHOLDS
from (
select 
 CLASS_NAME
,PERSON_NAME
,AMT
,ROW_NUMBER() OVER(PARTITION BY CLASS_NAME ORDER BY AMT DESC)  rank
from HOUSEHOLD
where 1=1
and PERSON_CODE <> '1'
and CLASS_CODE <> '01'
order by CLASS_CODE asc
) a
where 1=1
and rank = 1