SELECT
    CLASS_NAME AS CLASS ,
    MAX(PERSON_NAME) AS PERSON ,
    MAX(AMT) AS HOUSEHOLDS
FROM 
    HOUSEHOLD
WHERE 
    PERSON_CODE <> '1' AND 
    CLASS_CODE <> '01'
GROUP BY 
    CLASS