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