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