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