SELECT H1.CLASS_NAME AS CLASS,H1.PERSON_NAME AS PERSON ,
       H1.AMT AS HOUSEHOLDS
       
       FROM HOUSEHOLD AS H1
       
       WHERE H1.PERSON_CODE<>'1' AND H1.CLASS_CODE<>'01'
             AND H1.AMT=(SELECT MAX(H2.AMT)
                          FROM HOUSEHOLD AS H2
                          WHERE H2.CLASS_CODE=H1.CLASS_CODE
                            AND  H2.PERSON_CODE<>'1' AND H2.CLASS_CODE<>'01'
       
                          GROUP BY H2.CLASS_CODE)

       
       ORDER BY H1.CLASS_CODE ASC;