WITH MaxHouseholds AS (
    SELECT CLASS_CODE, MAX(AMT) AS MAX_AMT
    FROM HOUSEHOLD
    WHERE PERSON_CODE != '1' AND CLASS_CODE != '01'
    GROUP BY CLASS_CODE
)

SELECT 
    H.CLASS_NAME AS CLASS,
    H.PERSON_NAME AS PERSON,
    H.AMT AS HOUSEHOLDS
FROM HOUSEHOLD H
INNER JOIN MaxHouseholds MH
ON H.CLASS_CODE = MH.CLASS_CODE AND H.AMT = MH.MAX_AMT
WHERE H.PERSON_CODE != '1' AND H.CLASS_CODE != '01'
ORDER BY H.CLASS_CODE ASC;