SELECT 
AL4.INST_NAME, 
AL1.ACADEMIC_YEAR, 
AL2.FACULTY_RANK, 
AL2.CONTRACT_TYPE, 
AL2.GENDER, 
AL3.SALARY_OUTLAY, 
AL3.FACULTY_COUNT, 
AL3.TENURED_FACULTY_COUNT 
FROM WAREUSER.ACADEMIC_YEAR AL1, 
     WAREUSER.AAUP_FACSAL_RANK AL2, 
     WAREUSER.AAUP_FACULTY_SALARY_DETAIL AL3, 
     WAREUSER.INSTITUTION AL4 
WHERE 
(AL1.ACADEMIC_YEAR_KEY=AL3.ACADEMIC_YEAR_KEY 
 AND AL2.AAUP_FACSAL_RANK_KEY=AL3.AAUP_FACSAL_RANK_KEY 
 AND AL3.INSTITUTION_KEY=AL4.INSTITUTION_KEY)  
AND 
(AL1.ACADEMIC_YEAR='2001-2002' 
 AND AL2.CONTRACT_TYPE='9-10 month' 
 AND AL2.FACULTY_RANK IN ('Assistant Professor', 'Associate Professor', 'Professor')
)