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