SELECT
H1.CLASS_NAME AS CLASS,
H1.PERSON_NAME AS PERSON,
H1.AMT AS HOUSEHOLDS

FROM
HOUSEHOLD as H1

WHERE
H1.CLASS_CODE<>'01'
AND H1.PERSON_CODE<>'1'
AND H1.AMT=
 (
 SELECT
 MAX(H2.AMT)
 FROM
 HOUSEHOLD AS H2
 WHERE 
 H2.CLASS_CODE = H1.CLASS_CODE 
AND H2.CLASS_CODE<>'01'
AND H2.PERSON_CODE<>'1'
)