select
  H_RANK_H.CLASS_NAME CLASS,
  MAX(CASE H_RANK_H.RANK_HOUSEHOLDS WHEN 1 THEN H_RANK_H.PERSON_NAME ELSE NULL END) AS PERSON,
  MAX(CASE H_RANK_H.RANK_HOUSEHOLDS WHEN 1 THEN H_RANK_H.AMT ELSE NULL END) AS HOUSEHOLDS
from
(
  select
    CLASS_CODE,
    CLASS_NAME,
    PERSON_NAME,
    AMT,
    RANK() OVER ( 
                PARTITION BY
                    CLASS_CODE
                ORDER BY
                    AMT desc
            ) AS RANK_HOUSEHOLDS
  from HOUSEHOLD
  where PERSON_CODE != '1' AND CLASS_CODE != '01'
) H_RANK_H

group by H_RANK_H.CLASS_CODE

order by H_RANK_H.CLASS_CODE
;