select
    CLASS_NAME as CLASS,
    case when AMT = max(AMT) then PERSON_NAME else null end as PERSON,
    case when AMT = max(AMT) then AMT else null end as HOUSEHOLDS
from
    HOUSEHOLD
where
    PERSON_CODE <> '1'
    and
    CLASS_CODE <> '01'
group by
    CLASS_CODE,
    CLASS_NAME
order by
    CLASS_CODE;