SELECT DISTINCT CLASS_NAME AS CLASS
, DISTINCT PERSON_NAME AS PERSON
, MAX(AMT) AS HOUSEHOLDS
FROM HOUSEHOLD
WHERE 1=1
AND PERSON_CODE NOT LIKE '1'
AND CLASS_CODE NOT LIKE '01'
ORDER BY CLASS_CODE