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