SELECT  
AL1.ACAD_YEAR_BEGIN_TERM, 
AL2.INST_FULL_NAME, 
AL3.RESIDENCY, 
AL3.NUM_OF_APPLICATIONS, 
AL3.NUM_OF_ADMITS, 
AL3.NUM_OF_ENROLLED, 
AL3.APPLICATION_YIELD_PCNT, 
AL3.MATRICULATION_YIELD_PCNT 
FROM WAREUSER.ACADEMIC_YEAR AL1, 
     WAREUSER.INSTITUTION AL2, 
     WAREUSER.FROSH_YIELD_RESIDENCY_DETAIL AL3 
WHERE AL1.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY 
AND AL2.INSTITUTION_KEY=AL3.INSTITUTION_KEY  
AND AL1.ACAD_YEAR_BEGIN_TERM='Fall 2003'