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