SELECT 
AL4.INSTITUTION_NAME, 
AL4.DIVISION_CODE, 
AL4.DIVISION_NAME, 
AL4.DEPARTMENT, 
AL4.DEPARTMENT_NAME, 
AL4.CIP_PROGRAM_CODE, 
AL3.ACADEMIC_YEAR, 
AL1.INST_NAME, 
AL2.FACULTY_RANK, 
AL2.APPOINTMENT_TYPE, 
AL5.AVERAGE_SALARY, 
AL5.FACULTY_FTE 
FROM WAREUSER.INSTITUTION AL1, 
     WAREUSER.AAUDE_FACSAL_RANK AL2, 
     WAREUSER.ACADEMIC_YEAR AL3, 
     WAREUSER.CIP_CROSS_FACULTY_SALARY AL4, 
     WAREUSER.AAUDE_FACULTY_SALARY_DETAIL AL5 
WHERE 
(AL5.CIP_CROSS_FACSAL_COMPARE_KEY=AL4.CIP_CROSS_FACSAL_COMPARE_KEY 
 AND AL5.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY 
 AND AL5.INSTITUTION_KEY=AL1.INSTITUTION_KEY 
 AND AL5.AAUDE_FACSAL_RANK_KEY=AL2.AAUDE_FACSAL_RANK_KEY)  
AND 
(AL3.ACADEMIC_YEAR='2000-2001' 
 AND AL4.INSTITUTION_NAME='Texas' 
 AND AL4.DIVISION_NAME IN ('ARCHITECTURE', 'BUSINESS ADMINISTRATION', 
                          'COMMUNICATION', 'EDUCATION', 'ENGINEERING', 
                          'FINE ARTS', 'LAW', 'LIBERAL ARTS', 
                          'LIBRARY & INFO SCIENCES', 'NATURAL SCIENCES', 
                          'NURSING', 'PHARMACY', 
                          'PUBLIC AFFAIRS', 'SOCIAL WORK') 
 AND (NOT AL4.DEPARTMENT_NAME='Petroleum Engr') 
 AND AL1.INST_NAME IN ('Cal-Berkeley', 'Cal-Los Angeles', 
                      'Illinois', 'Indiana', 'Michigan', 
                      'Michigan State', 'Minnesota', 
                      'North Carolina', 'Ohio State', 
                      'Texas', 'Washington', 'Wisconsin') 
 AND (NOT AL2.FACULTY_RANK='Lecturer') 
 AND AL2.APPOINTMENT_TYPE IN ('11-12 month', '9-10 month')
)