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