SELECT CLASS_NAME AS "CLASS"
      ,PERSON_NAME AS "PERSON"
      ,MAX(AMT) AS "HOUSEHOLDS"
  FROM HOUSEHOLD
 WHERE CLASS_CODE <> '01'
   AND CLASS_NAME <> '総数'
   AND PERSON_NAME <> '総数'
 GROUP BY CLASS_CODE
 ORDER BY CLASS_CODE
;