with tmp as(
    select CLASS_NAME as CLASS, max(amt) as HOUSEHOLDS
    from HOUSEHOLD
    where PERSON_NAME != '総数' and CLASS_NAME != '総数'
    group by CLASS_NAME
)
select t.CLASS as CLASS, h.PERSON_NAME as PERSON, t.HOUSEHOLDS as HOUSEHOLDS
from tmp as t
inner join HOUSEHOLD as h
on h.CLASS_NAME = t.CLASS and h.AMT = t.HOUSEHOLDS
order by CLASS_CODE
;