SELECT
t1.CLASS_NAME AS CLASS,
t1.PERSON_NAME AS PERSON,
t1.AMT AS HOUSEHOLDS
FROM HOUSEHOLD as t1
    INNER JOIN (SELECT
                    CLASS_CODE,
                    MAX(AMT) AS HOUSEHOLDS
                FROM
                    HOUSEHOLD 
                    where NOT (PERSON_CODE = '1' or CLASS_CODE = '01')
                GROUP BY
                    CLASS_CODE) t2
ON t1.CLASS_CODE =t2.CLASS_CODE
and t1.AMT =t2.HOUSEHOLDS
ORDER BY t1.CLASS_CODE ASC;