SELECT
 DISTINCT CLASS_NAME AS CLASS,
 MAX(AMT) AS HOUSEHOLDS,
 PERSON_NAME AS PERSON
FROM
 HOUSEHOLD
GROUP BY
 CLASS_NAME;