SELECT 
AL5.FISCAL_YEAR, 
AL4.INST_NAME, 
AL2.SCHOOL_NAME, 
AL6.ENROLL_STATUS, 
AL3.GENDER, 
AL3.ETHNICITY, 
AL7.DISCIPLINE_CATEGORY,
AL7.DISCIPLINE_CODE,
AL7.DISCIPLINE_NAME,
AL1.STUDENT_COUNT 
FROM WAREUSER.NSF_GSS_ENROLLMENT_DETAIL AL1, 
     WAREUSER.NSF_GSS_SCHOOL AL2, 
     WAREUSER.NSF_GSS_DEMOGRAPHIC AL3, 
     WAREUSER.INSTITUTION AL4, 
     WAREUSER.FISCAL_YEAR AL5, 
     WAREUSER.NSF_GSS_ENROLL_STATUS AL6, 
     WAREUSER.NSF_DISCIPLINE AL7 
WHERE 
 AL1.FISCAL_YEAR_KEY=AL5.FISCAL_YEAR_KEY 
 AND AL1.INSTITUTION_KEY=AL4.INSTITUTION_KEY 
 AND AL1.NSF_GSS_SCHOOL_KEY=AL2.NSF_GSS_SCHOOL_KEY 
 AND AL1.NSF_GSS_ENROLL_STATUS_KEY=AL6.NSF_GSS_ENROLL_STATUS_KEY 
 AND AL1.NSF_GSS_DEMOGRAPHIC_KEY=AL3.NSF_GSS_DEMOGRAPHIC_KEY  
 AND AL1.NSF_DISCIPLINE_KEY=AL7.NSF_DISCIPLINE_KEY
 AND AL5.FISCAL_YEAR='2004'
 AND AL4.IS_AAUDE_INSTITUTION = 'Y'