SELECT a.CLASS_NAME AS CLASS
       ,b.PERSON_NAME AS PERSON
       ,MAX(a.AMT) AS HOUSEHOLDS
       
FROM HOUSEHOLD as a
JOIN HOUSEHOLD as b
 ON a.PERSON_CODE = b.PERSON_CODE

WHERE 0=0
AND a.PERSON_CODE <> "1"
AND a.CLASS_CODE <> "01"

GROUP BY a.CLASS_CODE
        ,a.CLASS_NAME
        
ORDER BY a.CLASS_CODE ASC