How many different scientists are assigned to any project?
CREATE TABLE assignedto (scientist VARCHAR)
SELECT COUNT(DISTINCT scientist) FROM assignedto
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE assignedto (scientist VARCHAR) Question: How many different scientists are assigned to any project? [/INST] SELECT COUNT(DISTINCT scientist) FROM assignedto </s>