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