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;