SELECT h1.CLASS_NAME AS CLASS, PERSON_NAME AS PERSON, AMT AS HOUSEHOLDS
FROM HOUSEHOLD h1
JOIN (
    SELECT CLASS_NAME, MAX(PERSON_CODE) AS MAX_PERSON_CODE
    FROM HOUSEHOLD
    WHERE PERSON_CODE<>'1' AND CLASS_CODE<>'01'
    GROUP BY CLASS_NAME
) h2 ON h1.CLASS_NAME=h2.CLASS_NAME AND h1.PERSON_CODE=h2.MAX_PERSON_CODE