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 CLASS_CODE
ORDER BY CLASS_CODE asc