select 
    CLASS_NAME AS CLASS
    ,PERSON_NAME AS PERSON
    ,max(AMT) AS HOUSEHOLDS
from
HOUSEHOLD
where PERSON_CODE <> '1' and CLASS_CODE <> '01' 
group by 1
order by CLASS_CODE