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_NAME
        order by CLASS_CODE asc;