SELECT
    H.CLASS_NAME AS CLASS,
    H.PERSON_NAME AS PERSON,
    H.AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD H
WHERE
    H.PERSON_CODE != '1'
    AND
    H.CLASS_CODE != '01'
    AND
    H.AMT = (
        SELECT
            MAX(S.AMT)
        FROM
            HOUSEHOLD S
        WHERE
            S.CLASS_CODE = H.CLASS_CODE
            AND
            S.PERSON_CODE != '1'
            AND
            S.CLASS_CODE != '01'
        GROUP BY
            S.CLASS_CODE
            )
ORDER BY
    H.CLASS_CODE;