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