SELECT
      CLASS_NAME AS CLASS
    , PERSON_NAME AS PERSON
    , max(AMT) AS HOUSEHOLDS

FROM 
    HOUSEHOLD 
WHERE
    PERSON_CODE <> '1' and
    CLASS_CODE <> '01' and
    AMT is not null
GROUP BY 
    CLASS_CODE
ORDER BY
    CLASS_CODE ASC;
;