--所得階層ごとの最大世帯数を取得する
with max_amt as (
  select  h.class_code
         ,max(h.amt) as max_amt
    from household as h
   where h.person_code <> '1'
     and h.class_code  <> '01'
   group by  h.class_code
)
--最大世帯数から所得階層名、世帯人員名を取得する
select h.CLASS_NAME as CLASS
       ,h.PERSON_NAME as PERSON
       ,m.max_AMT as HOUSEHOLDS
  from max_amt as m
  left outer join household as h
    on m.max_amt = h.amt
 order by h.class_code