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