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 asc;