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