select h1.class_name as CLASS, h1.person_name as PERSON, h1.amt as HOUSEHOLDS
from household as h1
join (
    select class_name, person_name, max(amt) as amt
    from HOUSEHOLD as h3
    where not (class_name = "総数" or person_name = "総数")
    group by class_name) as h2
    on (h1.class_name = h2.class_name and h1.person_name = h2.person_name and h1.amt = h2.amt)
ORDER BY h1.class_name;