SELECT  B.CLASS_NAME AS CLASS, B.PERSON_NAME AS PERSON, B.AMT AS HOUSEHOLDS
FROM (
    SELECT CLASS_CODE, MAX(AMT) AS AMT FROM HOUSEHOLD WHERE PERSON_CODE<>'1' AND CLASS_CODE<>'01' GROUP BY CLASS_CODE
    ) AS A
INNER JOIN HOUSEHOLD AS B ON A.CLASS_CODE = B.CLASS_CODE AND A.AMT = B.AMT
ORDER BY B.CLASS_CODE ASC;