SELECT
 y.CLASS_NAME as CLASS
 , y.PERSON_NAME as PERSON
 , x.HOUSEHOLDS as HOUSEHOLDS
FROM
(
 SELECT
  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.CLASS_CODE = y.CLASS_CODE
 and x.HOUSEHOLDS = y.AMT
ORDER BY
 x.CLASS_CODE