Table schema:
CREATE TABLE table_name_96 (total INTEGER, lecturers VARCHAR, professors VARCHAR)

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