with tt as (
    select
        CLASS_NAME as CLASS,
        PERSON_NAME as PERSON,
        AMT as HOUSEHOLDS,
        CLASS_CODE,
        PERSON_CODE,
        rank() over(
            partition by CLASS_NAME
            order by
                AMT desc
        ) as R
    from
        HOUSEHOLD
    where
        PERSON_CODE != "1"
        and CLASS_CODE != "01"
    order by
        CLASS_CODE,
        PERSON_CODE desc
)
select
    CLASS,
    max(
        case
            when tt.R == 1 then tt.PERSON
            else null
        end
    ) as PERSON,
    max(
        case
            when tt.R == 1 then tt.HOUSEHOLDS
            else null
        end
    ) as HOUSEHOLDS
from
    tt,
    HOUSEHOLD as H
where
    tt.CLASS_CODE == H.CLASS_CODE
    and tt.PERSON_CODE == H.PERSON_CODE
group by
    tt.CLASS_CODE
order by
    tt.CLASS_CODE