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