SELECT
 CLASS_NAME as CLASS
 , PERSON_NAME as PERSON
 , MAX(AMT) as HOUSEHOLDS
FROM
 HOUSEHOLD
WHERE
 PERSON_CODE <> '1'
 and CLASS_CODE <> '01'
GROUP BY
 CLASS_NAME
ORDER BY
 CLASS_CODE