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