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