WITH TMP AS
(
    SELECT
         CLASS_CODE  AS CLASS_CODE
        ,CLASS_NAME  AS CLASS
        ,PERSON_CODE AS PERSON_CODE
        ,PERSON_NAME AS PERSON
        ,AMT         AS HOUSEHOLDS
    FROM HOUSEHOLD
    WHERE
         PERSON_CODE != '1'
     AND CLASS_CODE  != '01'
)
SELECT
     MAIN.CLASS
    ,MAIN.PERSON
    ,MAIN.HOUSEHOLDS
FROM TMP AS MAIN
     INNER JOIN (SELECT CLASS_CODE, MAX(HOUSEHOLDS) AS MAX_HOUSEHOLDS FROM TMP GROUP BY CLASS_CODE) AS MAX_VAL
     ON MAIN.CLASS_CODE = MAX_VAL.CLASS_CODE
    AND MAIN.HOUSEHOLDS = MAX_VAL.MAX_HOUSEHOLDS
ORDER BY MAIN.CLASS_CODE
;