SELECT 
CLASS_NAME AS CLASS,
PERSON_NAME AS PERSON,
MAX_OUSEHOLDS AS HOUSEHOLDS
FROM (
SELECT * FROM HOUSEHOLD
WHERE PERSON_CODE != "1" AND CLASS_CODE != "01"
) JOIN (
SELECT CLASS_CODE, MAX(AMT) AS MAX_OUSEHOLDS
FROM HOUSEHOLD
WHERE PERSON_CODE != "1" AND CLASS_CODE != "01"
GROUP BY CLASS_CODE
) USING (CLASS_CODE)
WHERE MAX_OUSEHOLDS = AMT
ORDER BY CLASS_CODE