SELECT CLASS_NAME AS CLASS, MAX(PERSON_NAME) AS PERSON, MAX(AMT) AS HOUSEHOLDS
FROM HOUSEHOLD
WHERE PERSON_CODE != "01" AND CLASS_CODE != "01"
GROUP BY CLASS_NAME
ORDER BY CLASS_CODE;