SELECT 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_CODE
ORDER BY CLASS_CODE ASC