SELECT
    H1.CLASS_NAME AS CLASS,
    H1.PERSON_NAME AS PERSON,
    H1.AMT AS HOUSEHOLDS

FROM HOUSEHOLD AS H1

WHERE
    H1.CLASS_CODE <> '01'
    AND H1.PERSON_CODE <> '1'
    AND H1.AMT = (
    SELECT
        MAX(H2.AMT)
        
    FROM HOUSEHOLD AS H2
    WHERE
        H2.CLASS_CODE = H1.CLASS_CODE
        AND H2.CLASS_CODE <> '01'
        AND H2.PERSON_CODE <> '1'
    GROUP BY
        H2.CLASS_CODE
    )    
ORDER BY
    H1.CLASS_CODE;