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)
        from
            HOUSEHOLD
        where
            PERSON_CODE != "1"
            and CLASS_CODE != "01"
        group by
            CLASS_NAME
    )
order by
    CLASS_CODE;