SELECT 
AL1.ENTERING_YEAR, 
AL1.INSTITUTION_NAME, 
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_TOTAL AL1, 
     WAREUSER.RETENTION_TOTAL_DETAIL AL2, 
     WAREUSER.RETENTION_TYPE AL3 
WHERE 
(AL1.RETENTION_CLASS_TOTAL_KEY=AL2.RETENTION_CLASS_TOTAL_KEY 
 AND AL2.RETENTION_TYPE_KEY=AL3.RETENTION_TYPE_KEY)  
 AND 
(AL1.ACADEMIC_YEAR_FALL='Fall 2000' 
 AND AL1.INSTITUTION_NAME='Arizona' 
 AND AL1.ENTERING_YEAR='1999'
) 
ORDER BY  2