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