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