SELECT
    CLASS_NAME AS CLASS
    , PERSON_NAME AS PERSON
    , AMT AS HOUSEHOLDS

FROM (
    SELECT
        CLASS_CODE
        , CLASS_NAME
        , PERSON_CODE
        , PERSON_NAME
        , AMT
        , MAX(AMT) OVER (PARTITION BY CLASS_CODE) AS HOGE
    
    FROM HOUSEHOLD
    
    WHERE
        PERSON_CODE != '1'
        AND CLASS_CODE != '01'
)

WHERE
    hoge = AMT