SELECT 
CLASS_NAME AS CLASS
, PERSON_NAME AS PERSON
, AMT AS HOUSEHOLDS
FROM (SELECT * FROM HOUSEHOLD ORDER BY CLASS_CODE ASC)
WHERE PERSON_CODE <> '1' AND CLASS_CODE <> '01'
GROUP BY CLASS_NAME
HAVING MAX(AMT)