SELECT
  T1.CLASS_NAME AS CLASS
  , T1.PERSON_NAME AS PERSON
  , T1.AMT AS HOUSEHOLDS
FROM
  HOUSEHOLD T1
INNER JOIN
  (
    SELECT
      CLASS_CODE
      , MAX(AMT) AS MAX_AMT
    FROM
      HOUSEHOLD
    WHERE
      CLASS_CODE <> '01'
      AND PERSON_CODE <> '1'
    GROUP BY
      CLASS_CODE
  ) T2
ON T1.AMT = T2.MAX_AMT
ORDER BY
  T1.CLASS_CODE ASC
;