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