SELECT
 DISTINCT 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;