with k AS (SELECT CLASS_NAME AS CLASS
,PERSON_NAME AS PERSON
,CLASS_CODE
,PERSON_CODE
,AMT 
,RANK() OVER(PARTITION BY CLASS_CODE ORDER BY MAX(AMT) asc ) AS lank
FROM HOUSEHOLD
WHERE 1=1
AND PERSON_CODE<>'1'
AND CLASS_CODE<>'01'
GROUP BY CLASS_CODE
ORDER BY CLASS_CODE asc)

SELECT  CLASS
,MAX(CASE WHEN lank=1 THEN PERSON ELSE NULL END) AS PERSON
,MAX(CASE WHEN lank=1 THEN AMT ELSE 0 END) AS HOUSEHOLDS
FROM k
WHERE 1=1
AND PERSON_CODE<>'1'
AND CLASS_CODE<>'01'
GROUP BY CLASS_CODE
ORDER BY CLASS_CODE asc