-- SELECT CLASS_NAME as CLASS, PERSON_NAME as PERSON, MAX(AMT) as HOUSEHOLDS
-- FROM HOUSEHOLD
-- GROUP BY CLASS_NAME, PERSON_NAME
-- HAVING PERSON_CODE <> 1 and CLASS_CODE <> "01"
-- ORDER BY CLASS_CODE

SELECT CLASS_NAME as CLASS, PERSON_NAME as PERSON, AMT as HOUSEHOLDS
FROM HOUSEHOLD as H
WHERE AMT in (SELECT MAX(AMT) as HOUSEHOLDS FROM HOUSEHOLD  WHERE PERSON_CODE <> 1 and CLASS_CODE <> "01"  GROUP BY CLASS_NAME)
GROUP BY CLASS_NAME, PERSON_NAME
HAVING PERSON_CODE <> 1 and CLASS_CODE <> "01"
ORDER BY CLASS_CODE