SELECT AL1.FISCAL_YEAR, 
       AL2.INST_NAME, 
       AL2.AAUDE_INST_CODE, 
       AL3.SCHOOL_NAME, 
       AL4.DEGREE_TYPE, 
       AL5.POSTDOC_OR_NONFAC, 
       AL6.DISCIPLINE_CATEGORY,
       AL6.DISCIPLINE_CODE,
       AL6.DISCIPLINE_NAME,
       AL5.STUDENT_COUNT 
FROM WAREUSER.FISCAL_YEAR AL1, 
     WAREUSER.INSTITUTION AL2, 
     WAREUSER.NSF_GSS_SCHOOL AL3, 
     WAREUSER.NSF_GSS_DEGREE AL4, 
     WAREUSER.NSF_GSS_BY_DEGREE_TOTAL AL5,
     WAREUSER.NSF_DISCIPLINE AL6
WHERE AL1.FISCAL_YEAR_KEY=AL5.FISCAL_YEAR_KEY 
AND AL2.INSTITUTION_KEY=AL5.INSTITUTION_KEY 
AND AL5.NSF_GSS_SCHOOL_KEY=AL3.NSF_GSS_SCHOOL_KEY 
AND AL5.NSF_GSS_DEGREE_KEY=AL4.NSF_GSS_DEGREE_KEY  
AND AL6.NSF_DISCIPLINE_KEY=AL5.NSF_DISCIPLINE_KEY 
AND AL1.FISCAL_YEAR='2004' 
AND AL2.INST_NAME = 'MIT'