select
    CLASS
    , PERSON
    , HOUSEHOLDS
from (select
    	CLASS_NAME as CLASS
    	, CLASS_CODE as CODE
    	, first_value(PERSON_NAME) 
    	    over(partition by CLASS_NAME order by AMT desc) as PERSON
    	, max(AMT)
    	    over(partition by CLASS_NAME) as HOUSEHOLDS
    from HOUSEHOLD
    where PERSON_CODE<>'1' and CLASS_CODE<>'01')
group by CLASS
order by CODE asc;