WITH temp AS (
    SELECT
        class_name AS CLASS
        , class_code
        , person_name AS PERSON
        , AMT AS HOUSEHOLDS
        , MAX(amt) OVER(PARTITION BY class_name) AS max_amt
    FROM
        household
    WHERE
        person_code != '1'
        AND class_code != '01'
)
SELECT
    CLASS
    , PERSON
    , HOUSEHOLDS
    --, _rank
FROM
    temp
WHERE
    max_amt = HOUSEHOLDS
ORDER BY
    class_code ASC