Table: university_staff
Columns: lecturers
associate_professors
assistant_professors
professors
total

Question: What is the total in the case where theere are 6 lecturers and fewer than 48 professors?
SQL: SELECT AVG("total") FROM university_staff WHERE "lecturers" = 6 AND "professors" < 48

Question: What is the total in the case when there are more than 4 associate professors, 5 lecturers and fewer professors than 40?
SQL: SELECT COUNT("total") FROM university_staff WHERE "associate_professors" > 4 AND "lecturers" = 5 AND "professors" < 40

Question: How may lecturers are there in the case when there are more than 8 assistant professors, fewer than 35 associate professors, more than 14 professors and total of more than 81?
SQL: SELECT COUNT("lecturers") FROM university_staff WHERE "assistant_professors" > 8 AND "professors" > 14 AND "associate_professors" < 35 AND "total" > 81

Question: What is the maximum number of associate professors when there are more than 5 assistant professors and fewer than 14 professors?
SQL: SELECT MAX("associate_professors") FROM university_staff WHERE "assistant_professors" > 5 AND "professors" < 14