with rank as (
    select
        CLASS_NAME
        ,CLASS_CODE
        ,PERSON_NAME
        ,AMT
        ,RANK() OVER(PARTITION BY CLASS_CODE ORDER BY AMT DESC) AS ranking
    from HOUSEHOLD
    where 
        PERSON_CODE != '1'
        and CLASS_CODE != '01'
    group by CLASS_CODE,PERSON_CODE
    )

select
    CLASS_NAME as CLASS
    ,MAX(CASE ranking WHEN 1 THEN PERSON_NAME ELSE NULL end) as PERSON
    ,MAX(CASE ranking WHEN 1 THEN AMT ELSE NULL end) as HOUSEHOLDS
from rank
group by CLASS_CODE
order by CLASS_CODE asc