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