select
    HOUSEHOLD.CLASS_NAME as CLASS,
    PERSON_NAME as PERSON,
    HOUSEHOLD.AMT as HOUSEHOLD
    
from
    HOUSEHOLD
inner join (
    select
        class_name,
        max(amt) as HOUSEHOLDS
    from
        HOUSEHOLD
    where
        PERSON_CODE != "1"
        and CLASS_CODE != "01"
    group by
        class_name
) as a
on
    HOUSEHOLD.AMT = a.HOUSEHOLDS
    and HOUSEHOLD.class_name = a.class_name
order by
    cast(CLASS_CODE as int64) asc