SELECT
 y.CLASS_NAME as CLASS
 , y.PERSON_NAME as PERSON
 , x.HOUSEHOLDS as HOUSEHOLDS
FROM
 (
 SELECT
  PERSON_CODE
  , CLASS_CODE
  , MAX(AMT) as HOUSEHOLDS
 FROM
  HOUSEHOLD
 WHERE
  PERSON_CODE <> '1'
  and CLASS_CODE <> '01'
 GROUP BY
  CLASS_CODE
 ) x
 inner join HOUSEHOLD y
 on x.PERSON_CODE = y.PERSON_CODE
 and x.CLASS_CODE = y.CLASS_CODE
ORDER BY
 x.CLASS_CODE