SELECT 	AL3.ACADEMIC_YEAR, 
	AL1.INST_NAME, 
	AL2.GENDER, 
	AL2.ETHNICITY, 
	AL5.DISCIPLINE_GROUP_CODE, 
	AL5.DISCIPLINE_GROUP, 
	AL5.ATTENDANCE_STATUS_CODE, 
	AL5.ATTENDANCE_STATUS, 
	AL5.LEVEL_OF_STUDY_CODE,
	AL5.LEVEL_OF_STUDY, 
	AL5.TYPE_OF_STUDENT_CODE, 
	AL5.TYPE_OF_STUDENT, 
	AL5.TYPE_OF_STUDENT_DESC, 
	AL4.NUMBER_OF_STUDENTS 
FROM WAREUSER.INSTITUTION AL1, 
     WAREUSER.IPEDS_DEMOGRAPHIC AL2, 
     WAREUSER.ACADEMIC_YEAR AL3, 
     WAREUSER.IPEDS_ENROLMENT_DISCP_DETAIL AL4, 
     WAREUSER.IPEDS_ENRL_DISCP_STATUS AL5 
WHERE (AL4.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY AND 
       AL4.INSTITUTION_KEY=AL1.INSTITUTION_KEY AND 
       AL5.IPEDS_ENRL_DISCP_STATUS_KEY=AL4.IPEDS_ENRL_DISCP_STATUS_KEY AND 
       AL4.IPEDS_DEMOGRAPHIC_KEY=AL2.IPEDS_DEMOGRAPHIC_KEY)  
AND AL3.ACADEMIC_YEAR='2000-2001' 
AND AL1.INST_NAME IN ('Cal Tech', 'Carnegie-Mellon', 'MIT') 
AND AL5.DISCIPLINE_GROUP IN ('Biological Sciences/Life Sciences', 'Engineering', 
                             'Mathematics', 'Physical Sciences')