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