-- 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 = (SELECT MAX(AMT) as HOUSEHOLDS FROM HOUSEHOLD  WHERE CLASS_NAME = H.CLASS_NAME and PERSON_CODE <> 1 and CLASS_CODE <> "01")
GROUP BY CLASS_NAME, PERSON_NAME
HAVING PERSON_CODE <> 1 and CLASS_CODE <> "01"
ORDER BY CLASS_CODE