;WITH HOUSEHOLD_Ext ([PERSON_CODE], [CLASS_CODE], [PERSON_NAME], [CLASS_NAME],[AMT],[順位]) AS (
    SELECT
          *
        , RANK() OVER(PARTITION BY [CLASS_NAME] ORDER BY [AMT] DESC)
    FROM HOUSEHOLD
    where PERSON_CODE >= 2
)
SELECT 
CLASS_NAME as CLASS
,PERSON_NAME as PERSON
,AMT as HOUSEHOLDS
FROM HOUSEHOLD_Ext
WHERE [順位] = 1 and CLASS_NAME <> '総数'
order by CLASS_CODE
;