WITH HMAX AS (  
SELECT  
	CLASS_CODE  
	,MAX(AMT) AS HM  
FROM HOUSEHOLD  
WHERE   
	PERSON_CODE <> 1  
	AND CLASS_CODE <> '01'  
GROUP BY CLASS_CODE  
)  
SELECT   
	CLASS_NAME AS CLASS  
	,PERSON_NAME AS PERSON  
	,HM AS HOUSEHOLDS  
FROM   
	HOUSEHOLD H  
	INNER JOIN HMAX M  
		ON H.CLASS_CODE = M.CLASS_CODE  
		AND H.AMT = M.HM  
ORDER BY   
	H.CLASS_CODE