SELECT
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD
    LEFT JOIN (
        SELECT
            CLASS_CODE,
            MAX(AMT) AS MAX_AMT
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE != '1'
            AND CLASS_CODE != '01'
        GROUP BY
            CLASS_CODE
    ) USING (
        CLASS_CODE
    )
WHERE
    HOUSEHOLDS = MAX_AMT
ORDER BY
    CLASS_CODE ASC
;