select
    CLASS_NAME as CLASS,
    PERSON_NAME as PERSON,
    AMT as HOUSEHOLD
from
    HOUSEHOLD
where
    PERSON_CODE <> "1"
    and CLASS_CODE <> "01"
    and AMT in (
        select
            max(AMT) as AMT_MAX
        from
            HOUSEHOLD
        where
            PERSON_CODE <> "1"
            and CLASS_CODE <> "01"
        group by
            CLASS_NAME
    )
order by
    CLASS_CODE;