How many members have professor edward acton as vice-chancellor?
CREATE TABLE table_142950_1 (total_number_of_students VARCHAR, vice_chancellor VARCHAR)
SELECT COUNT(total_number_of_students) FROM table_142950_1 WHERE vice_chancellor = "Professor Edward Acton"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_142950_1 (total_number_of_students VARCHAR, vice_chancellor VARCHAR) Question: How many members have professor edward acton as vice-chancellor? [/INST] SELECT COUNT(total_number_of_students) FROM table_142950_1 WHERE vice_chancellor = "Professor Edward Acton" </s>