SELECT AL5.INST_NAME, 
       AL3.GENDER, 
       AL4.EMPLOYEE_TYPE, 
       AL4.CONTRACT_TYPE, 
       AL4.EMPLOYEE_STATUS, 
       AL2.SALARY_RANGE_SORT_ORDER, 
       AL2.SALARY_RANGE, 
       AL1.NUMBER_OF_EMPLOYEES, 
       AL1.PERCENTAGE_OF_EMPLOYEES 
FROM WAREUSER.IPEDS_STAFF_SAL_RANGE_DETAIL AL1, 
     WAREUSER.IPEDS_STAFF_SALARY_RANGE AL2, 
     WAREUSER.IPEDS_GENDER AL3, 
     WAREUSER.IPEDS_STAFF_EMPLOYEE_TYPE AL4, 
     WAREUSER.INSTITUTION AL5, 
     WAREUSER.ACADEMIC_YEAR AL6 
WHERE (AL6.ACADEMIC_YEAR_KEY=AL1.ACADEMIC_YEAR_KEY AND 
       AL5.INSTITUTION_KEY=AL1.INSTITUTION_KEY AND 
       AL3.IPEDS_GENDER_KEY=AL1.IPEDS_GENDER_KEY AND 
       AL4.IPEDS_STAFF_EMPTYPE_KEY=AL1.IPEDS_STAFF_EMPTYPE_KEY AND 
       AL2.IPEDS_STAFF_SAL_RANGE_KEY=AL1.IPEDS_STAFF_SAL_RANGE_KEY)  
AND AL6.ACADEMIC_YEAR='2000-2001' 
AND AL5.INST_NAME IN ('Arizona', 'Florida', 'Maryland', 'Michigan State', 'North Carolina', 'Ohio State')