SELECT 
AL3.FISCAL_YEAR, 
AL4.INST_NAME, 
AL4.AAUDE_INST_CODE, 
AL2.SCHOOL_NAME, 
AL1.DEGREE_TYPE, 
AL6.DISCIPLINE_CATEGORY,
AL6.DISCIPLINE_CODE,
AL6.DISCIPLINE_NAME,
AL5.STUDENT_COUNT 
FROM WAREUSER.NSF_GSS_DEGREE AL1, 
     WAREUSER.NSF_GSS_SCHOOL AL2, 
     WAREUSER.FISCAL_YEAR AL3, 
     WAREUSER.INSTITUTION AL4, 
     WAREUSER.NSF_POSTDOC_BY_DEG_FORGN_TOTAL AL5,           
     WAREUSER.NSF_DISCIPLINE A6
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_DEGREE_KEY=AL1.NSF_GSS_DEGREE_KEY 
AND AL6.NSF_DISCIPLINE_KEY=AL5.NSF_DISCIPLINE_KEY 
AND AL3.FISCAL_YEAR='2004' 
AND AL4.IS_AAUDE_INSTITUTION='Y'