SELECT 
AL1.ENTERING_YEAR, 
AL1.INSTITUTION_NAME, 
AL1.PAGE_NUMBER, 
AL1.GENDER, 
AL1.ETHNICITY, 
AL1.FIRST_TIME_FRESHMEN, 
AL1.ACT_MEAN_SCORE, 
AL1.SAT_VERBAL_MEAN_SCORE, 
AL1.SAT_MATH_MEAN_SCORE, 
AL3.BEGINNING_OF_YEAR, 
AL3.RETENTION_TYPE, 
AL2.STUDENT_COUNT, 
AL2.STUDENT_PERCENTAGE 
FROM WAREUSER.RETENTION_CLASS_DEMOGRAPHIC AL1, 
     WAREUSER.RETENTION_DEMOGRAPHIC_DETAIL AL2, 
     WAREUSER.RETENTION_TYPE AL3 
WHERE 
(AL2.RETENTION_TYPE_KEY=AL3.RETENTION_TYPE_KEY 
 AND AL1.RETENTION_CLASS_DEMOG_KEY=AL2.RETENTION_CLASS_DEMOG_KEY)  
AND 
(AL1.ACADEMIC_YEAR_FALL='Fall 2000' 
 AND AL1.INSTITUTION_NAME='Cal-Berkeley' 
 AND AL1.ENTERING_YEAR='1999' 
 AND AL3.RETENTION_TYPE IN ('Continued', 'Graduated', 'Returned')
)