SELECT 
AL3.INSTITUTION_NAME, 
AL3.ENTERING_YEAR, 
AL3.RESIDENT, 
AL3.FIRST_TIME_FRESHMEN, 
AL3.ACT_MEAN_SCORE, 
AL3.SAT_VERBAL_MEAN_SCORE, 
AL3.SAT_MATH_MEAN_SCORE, 
AL1.BEGINNING_OF_YEAR, 
AL1.RETENTION_TYPE, 
AL2.STUDENT_COUNT, 
AL2.STUDENT_PERCENTAGE 
FROM WAREUSER.RETENTION_TYPE AL1, 
     WAREUSER.RETENTION_RESIDENT_DETAIL AL2,
     WAREUSER.RETENTION_CLASS_RESIDENT AL3 
WHERE 
(AL2.RETENTION_TYPE_KEY=AL1.RETENTION_TYPE_KEY 
 AND AL3.RETENTION_CLASS_RESIDENT_KEY=AL2.RETENTION_TRACKING_KEY)  
AND 
(AL3.ACADEMIC_YEAR_FALL='Fall 2000' 
 AND AL3.INSTITUTION_NAME='Virginia'
)