SELECT
    HH.CLASS_NAME AS CLASS,
    HH.PERSON_NAME AS PERSON,
    MAX(HH.AMT) AS HOUSEHOLDS
FROM
    HOUSEHOLD AS HH
WHERE
    HH.PERSON_CODE != '1'
    AND HH.CLASS_CODE != '01'
GROUP BY
    HH.PERSON_CODE
ORDER BY
    HH.PERSON_CODE;