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