WITH
L AS
(
    SELECT DISTINCT
        CLASS_NAME
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE <> '1'
    AND CLASS_CODE <> '01'
)
SELECT
    L.CLASS_NAME AS CLASS
,   R.PERSON_NAME AS PERSON
,   MAX(IFNULL(R.AMT, 0)) AS HOUSEHOLDS
FROM
    L
LEFT JOIN
    HOUSEHOLD R
    ON L.CLASS_NAME = R.CLASS_NAME
WHERE
    R.PERSON_CODE <> '1'
AND R.CLASS_CODE <> '01'
AND R.CLASS_NAME IS NOT NULL
AND R.PERSON_NAME IS NOT NULL
GROUP BY
    R.CLASS_NAME
ORDER BY
    R.CLASS_CODE ASC