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