SELECT
    SUB.CLASS_NAME AS CLASS,
    SUB.PERSON_NAME AS PERSON,
    SUB.AMT AS HOUSEHOLDS
FROM
    (
        SELECT
            *,
            RANK() OVER(PARTITION BY CLASS_NAME ORDER BY AMT DESC) AS RANK
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE != 1
            AND CLASS_CODE != '01'
    ) AS SUB
WHERE
    SUB.RANK = 1
ORDER BY
    SUB.CLASS_CODE ASC