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