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

    order by CLASS_CODE)
    where rank =1
    order by CLASS_CODE
    ;