SELECT AL4.FISCAL_YEAR, 
       AL3.INST_NAME, 
       AL2.SCHOOL_NAME, 
       AL5.ENROLL_STATUS, 
       AL6.GENDER, 
       AL7.DISCIPLINE_CATEGORY,
       AL7.DISCIPLINE_CODE,
       AL7.DISCIPLINE_NAME,
       AL1.STUDENT_COUNT 
FROM WAREUSER.NSF_GSS_ENRL_GENDER_DETAIL AL1, 
     WAREUSER.NSF_GSS_SCHOOL AL2, 
     WAREUSER.INSTITUTION AL3, 
     WAREUSER.FISCAL_YEAR AL4, 
     WAREUSER.NSF_GSS_ENROLL_STATUS AL5, 
     WAREUSER.NSF_GSS_GENDER AL6,
     WAREUSER.NSF_DISCIPLINE AL7
WHERE AL1.FISCAL_YEAR_KEY=AL4.FISCAL_YEAR_KEY 
AND AL3.INSTITUTION_KEY=AL1.INSTITUTION_KEY 
AND AL1.NSF_GSS_SCHOOL_KEY=AL2.NSF_GSS_SCHOOL_KEY 
AND AL1.NSF_GSS_ENROLL_STATUS_KEY=AL5.NSF_GSS_ENROLL_STATUS_KEY 
AND AL1.NSF_DISCIPLINE_KEY=AL7.NSF_DISCIPLINE_KEY
AND AL6.NSF_GSS_GENDER_KEY=AL1.NSF_GSS_GENDER_KEY  
AND AL4.FISCAL_YEAR IN ('1974', '1984', '1994', '2004')
AND AL3.IS_AAUDE_INSTITUTION = 'Y'