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