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