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