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