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

ORDER BY CLASS_CODE