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