SELECT
    CLASS
    ,PERSON
    ,AMT AS HOUSEHOLDS
FROM(
    SELECT
        CLASS_NAME AS CLASS
        ,PERSON_NAME AS PERSON
        ,AMT
        ,RANK() OVER (PARTITION BY CLASS_NAME ORDER BY AMT DESC)AS AMT_RANK
    FROM HOUSEHOLD
    WHERE PERSON_CODE != '1' AND CLASS_NAME != '総数'
)
WHERE AMT_RANK = 1;