SELECT 	AL5.ACADEMIC_YEAR, 
       	AL1.INST_NAME, 
       	AL2.GENDER, 
	AL2.ETHNICITY, 
	AL4.ATTENDANCE_STATUS_CODE, 
	AL4.ATTENDANCE_STATUS, 
	AL4.LEVEL_OF_STUDY_CODE, 
	AL4.LEVEL_OF_STUDY, 
	AL4.TYPE_OF_STUDENT_CODE, 	
	AL4.TYPE_OF_STUDENT, 
	AL4.TYPE_OF_STUDENT_DESC, 
	AL3.NUMBER_OF_STUDENTS 
FROM WAREUSER.INSTITUTION AL1, 
     WAREUSER.IPEDS_DEMOGRAPHIC AL2, 
     WAREUSER.IPEDS_ENROLMENT_TOTAL_DETAIL AL3, 
     WAREUSER.IPEDS_ENRL_TOTAL_STATUS AL4, 
     WAREUSER.ACADEMIC_YEAR AL5 
WHERE (AL1.INSTITUTION_KEY=AL3.INSTITUTION_KEY AND 
       AL3.IPEDS_DEMOGRAPHIC_KEY=AL2.IPEDS_DEMOGRAPHIC_KEY AND 
       AL4.IPEDS_ENRL_TOTAL_STATUS_KEY=AL3.IPEDS_ENRL_TOTAL_STATUS_KEY AND 
       AL5.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY)  
AND (AL5.ACADEMIC_YEAR='2000-2001')