SELECT 
AL3.FISCAL_YEAR, 
AL4.INST_NAME, 
AL4.AAUDE_INST_CODE, 
AL2.SCHOOL_NAME, 
AL1.GENDER, 
AL6.DISCIPLINE_CATEGORY,
AL6.DISCIPLINE_CODE,
AL6.DISCIPLINE_NAME,
AL5.STUDENT_COUNT 
FROM WAREUSER.NSF_GSS_GENDER AL1, 
     WAREUSER.NSF_GSS_SCHOOL AL2, 
     WAREUSER.FISCAL_YEAR AL3, 
     WAREUSER.INSTITUTION AL4, 
     WAREUSER.NSF_POSTDOC_BY_GEN_FORGN_TOTAL AL5,
     WAREUSER.NSF_DISCIPLINE AL6 
WHERE AL5.FISCAL_YEAR_KEY=AL3.FISCAL_YEAR_KEY 
AND AL4.INSTITUTION_KEY=AL5.INSTITUTION_KEY 
AND AL5.NSF_GSS_SCHOOL_KEY=AL2.NSF_GSS_SCHOOL_KEY 
AND AL5.NSF_GSS_GENDER_KEY=AL1.NSF_GSS_GENDER_KEY 
AND AL6.NSF_DISCIPLINE_KEY=AL5.NSF_GSS_FOREIGN_TYPE_KEY 
AND AL3.FISCAL_YEAR='2004' 
AND AL4.INST_NAME='MIT'