SELECT 
AL5.INST_NAME, 
AL2.EMPLOYEE_TYPE, 
AL2.CONTRACT_TYPE, 
AL2.EMPLOYEE_STATUS, 
AL4.GENDER, 
AL1.NUMBER_OF_EMPLOYEES, 
AL1.PERCENTAGE_OF_EMPLOYEES 
FROM WAREUSER.IPEDS_STAFF_BY_EMPTYPE_DETAIL AL1, 
     WAREUSER.IPEDS_STAFF_EMPLOYEE_TYPE AL2, 
     WAREUSER.ACADEMIC_YEAR AL3, 
     WAREUSER.IPEDS_GENDER AL4, 
     WAREUSER.INSTITUTION AL5 
WHERE 
(AL2.IPEDS_STAFF_EMPTYPE_KEY=AL1.IPEDS_STAFF_EMPTYPE_KEY 
 AND AL4.IPEDS_GENDER_KEY=AL1.IPEDS_GENDER_KEY 
 AND AL1.INSTITUTION_KEY=AL5.INSTITUTION_KEY 
 AND AL1.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY)  
AND 
(AL3.ACADEMIC_YEAR='2001-2002' 
 AND AL5.INST_NAME IN ('Cal Tech', 'Cal-Berkeley', 'Cal-Davis', 
                      'Cal-Irvine', 'Cal-Los Angeles', 
                      'Cal-San Diego', 'Cal-Santa Barbara') 
 AND AL2.EMPLOYEE_TYPE IN ('Clerical and Secreterial', 
                          'Exec/Admin/Managerial', 'Faculty', 
                          'Instruction/Research Assistant', 
                          'Other Administrative', 'Other Professional', 
                          'Service and Maintenance', 'Skilled Crafts', 
                          'Technical and Professional') 
 AND AL2.EMPLOYEE_STATUS IN ('Full Time', 'Part Time')
)