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