SELECT
CLASS_NAME AS CLASS,
PERSON_NAME AS PERSON,
MAX(AMT) AS HOUSEHOLDS
FROM HOUSEHOLD 
where NOT (PERSON_CODE = '1' or CLASS_CODE = '01')
group by CLASS_CODE
ORDER BY CLASS_CODE ASC;