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

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