SELECT
        CLASS
        , PERSON
        , HOUSEHOLDS
FROM
    (
        SELECT DISTINCT
            CLASS_CODE
        FROM
            HOUSEHOLD
    ) X
    LEFT OUTER JOIN(
        SELECT
                CLASS_CODE
                , PERSON_CODE
                , CLASS
                , PERSON
                , HOUSEHOLDS
            FROM
                (
                    SELECT
                        CLASS_CODE
                        , PERSON_CODE
                        , PERSON_NAME PERSON
                        , CLASS_NAME CLASS
                        , AMT HOUSEHOLDS
                        , ROW_NUMBER() OVER (
                            PARTITION BY CLASS_CODE
                            ORDER BY AMT DESC) AS PRIORITY
                    FROM
                        HOUSEHOLD
                    WHERE
                        CLASS_CODE <>'01'
                        AND PERSON_CODE <> '1'
        
                ) T
            WHERE
                PRIORITY = 1
    ) T2
    USING(CLASS_CODE)
ORDER BY
        CLASS_CODE
;