SELECT
CLASS_NAME AS CLASS,
MAX(PERSON_NAME) AS PERSON,
AMT AS HOUSEHOLDS

FROM HOUSEHOLD

WHERE PERSON_CODE != '1' AND
CLASS_CODE != '01'

GROUP BY CLASS_NAME

ORDER BY CLASS_CODE ASC;