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 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;