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

ORDER BY HH.CLASS_CODE;