with base  as(
select
	CLASS_CODE
,	CLASS_NAME as CLASS
,	PERSON_NAME as PERSON
,	AMT as HOUSEHOLDS
,	DENSE_RANK() over (partition by CLASS_NAME order by AMT DESC) as 順位
from
	HOUSEHOLD
where
	PERSON_CODE <> '1'
and	CLASS_CODE <> '01'
)
select
	CLASS
,	PERSON
,	HOUSEHOLDS
from
	base
where
	順位 = 1
order by
	CLASS_CODE