user: ### NOW ANSWER:
Question: What is the total in the case where theere are 6 lecturers and fewer than 48 professors?
Columns: ['Lecturers', 'Associate professors', 'Assistant professors', 'Professors', 'Total']
Types: ['real', 'real', 'real', 'real', 'real']
Sample row: [5.0, 35.0, 27.0, 40.0, 120.0]
SQL:

assistant: SELECT AVG("Total") FROM "Table" WHERE "Lecturers" = 6.0 AND "Professors" < 48.0;