SELECT HH.CLASS_NAME AS CLASS
       ,HH.PERSON_NAME AS PERSON
       ,MAX(DISTINCT HH.AMT) AS HOUSEHOLDS

FROM HOUSEHOLD AS HH
     
WHERE 1=1
AND HH.PERSON_CODE<>'1'
AND HH.CLASS_CODE<>'01'
   
GROUP BY CLASS
         ,PERSON 
    
ORDER BY HH.CLASS_CODE