SELECT
CLASS_NAME AS CLASS,
PERSON_NAME AS PERSON,
AMT AS HOUSEHOLDS
FROM
HOUSEHOLD
WHERE (PERSON_CODE <> '1' AND CLASS_CODE <> '01')
GROUP BY CLASS_NAME
HAVING MAX(AMT);