What is the total in the case where theere are 6 lecturers and fewer than 48 professors?
CREATE TABLE table_name_96 (total INTEGER, lecturers VARCHAR, professors VARCHAR)
SELECT AVG(total) FROM table_name_96 WHERE lecturers = 6 AND professors < 48
<s>[INST] Write mssql query to answer the following question given the database schema. 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? [/INST] SELECT AVG(total) FROM table_name_96 WHERE lecturers = 6 AND professors < 48 </s>