SELECT 
AL3.ACAD_YEAR_BEGIN_TERM, 
AL2.INST_FULL_NAME, 
AL2.CONTROL, 
AL1.RESIDENCY, 
AL1.PROFILE_CATEGORY, 
AL1.PROFILE_TYPE, 
AL4.FRESHMEN_COUNT, 
AL4.FRESHMEN_PERCENT 
FROM WAREUSER.FROSH_PROFILE_RESIDENCY AL1, 
     WAREUSER.INSTITUTION AL2, 
     WAREUSER.ACADEMIC_YEAR AL3, 
     WAREUSER.FROSH_ENROLL_RESIDENCY_DETAIL AL4 
WHERE AL4.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY 
AND AL2.INSTITUTION_KEY=AL4.INSTITUTION_KEY 
AND AL4.FROSH_PROFILE_KEY=AL1.FROSH_PROFILE_KEY  
AND AL3.ACAD_YEAR_BEGIN_TERM='Fall 2003'