SELECT CLASS_NAME AS CLASS, 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;