Which Unit test has a MSDN integration of full, and a Projects templates of yes?
CREATE TABLE table_name_76 (unit_test VARCHAR, msdn_integration VARCHAR, projects_templates VARCHAR)
SELECT unit_test FROM table_name_76 WHERE msdn_integration = "full" AND projects_templates = "yes"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_76 (unit_test VARCHAR, msdn_integration VARCHAR, projects_templates VARCHAR) Question: Which Unit test has a MSDN integration of full, and a Projects templates of yes? [/INST] SELECT unit_test FROM table_name_76 WHERE msdn_integration = "full" AND projects_templates = "yes" </s>