SELECT
 CLASS_NAME AS CLASS,
 MAXPERSON_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;