SELECT
DISTINCT 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_NAME,CLASS_CODE
ORDER BY CLASS_CODE DESC