select h1.class_name as CLASS, h1.person_name as PERSON, h1.amt as HOUSEHOLDS
from household as h1
join (
    select class_name, max(amt) as amt
    from HOUSEHOLD
    where not (PERSON_CODE = "1" or CLASS_CODE = "01" or CLASS_NAME is NULL or PERSON_NAME is NULL or AMT is NULL)
    group by class_name) as h2
    on (h1.class_name = h2.class_name and h1.amt = h2.amt)
ORDER BY h1.class_name;