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