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