select class_name as CLASS, person_name as PERSON, max(amt) as HOUSEHOLDS from HOUSEHOLD where not (class_name = "総数" or person_name = "総数") group by CLASS_NAME;