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_NAME
ORDER BY
    CLASS_CODE ASC