select 
(CLASS_NAME) AS CLASS,
(PERSON_NAME) AS PERSON,
MAX
(AMT) AS HOUSEHOLDS
from HOUSEHOLD
where PERSON_CODE NOT IN(1) AND CLASS_CODE NOT IN(01) 
group by CLASS
order by CLASS asc;