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