SELECT
 CLASS_NAME AS CLASS,
 PERSON_NAME AS PERSON,
 MAX(AMT) AS HOUSEHOLDS
FROM
 HOUSEHOLD
WHERE NOT (
 PERSON_CODE = '1'
OR 
 CLASS_CODE = '01' )
GROUP BY
 CLASS
ORDER BY
 CLASS_CODE ASC;