select
    CLASS_NAME as CLASS
    , ( case AMT when max(AMT) then PERSON_NAME  else NULL end) as PERSON
    , ( case AMT when max(AMT) then AMT else 0 end ) as HOUSEHOLDS
from HOUSEHOLD
where
    CLASS_CODE != "01"
    and PERSON_CODE != "1"
group by
    CLASS_CODE
having
    PERSON is not NULL
order by
    CLASS_CODE
;