SELECT 
AL5.FISCAL_YEAR, 
AL4.INST_NAME, 
AL2.NSF_FIELD_NAME, 
AL2.NSF_FIELD_CATEGORY, 
AL3.FINANCE_TYPE, 
AL1.EXPENDITURE_AMOUNT 
FROM WAREUSER.NSF_RDEXP_CURR_FUND_DETAIL AL1, 
     WAREUSER.NSF_RDEXP_FIELD AL2, 
     WAREUSER.NSF_RDEXP_FINANCE_TYPE AL3,  
     WAREUSER.INSTITUTION AL4, 
     WAREUSER.FISCAL_YEAR AL5 
WHERE 
(AL1.FISCAL_YEAR_KEY=AL5.FISCAL_YEAR_KEY 
 AND AL1.INSTITUTION_KEY=AL4.INSTITUTION_KEY 
 AND AL2.NSF_RDEXP_FIELD_KEY=AL1.NSF_RDEXP_FIELD_KEY 
 AND AL3.NSF_RDEXP_FINANCE_TYPE_KEY=AL1.NSF_RDEXP_FINANCE_TYPE_KEY)  
AND 
(AL5.FISCAL_YEAR='2000' 
 AND AL4.INST_NAME='Cal Tech' 
 AND AL3.FINANCE_TYPE IN ('Federally Financed', 'Non Federally Financed') 
 AND AL2.NSF_FIELD_NAME IN ('Computer Sciences', 'Engineering', 
                           'Environmental Sciences', 'Life Sciences', 
                           'Mathematical Sciences', 'Other Sciences', 
                           'Physical Sciences', 'Psychology', 'Social Sciences')
)