How many games have a Result of l, and a Record of 2-6?
CREATE TABLE table_name_17 (game VARCHAR, result VARCHAR, record VARCHAR)
SELECT COUNT(game) FROM table_name_17 WHERE result = "l" AND record = "2-6"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_17 (game VARCHAR, result VARCHAR, record VARCHAR) Question: How many games have a Result of l, and a Record of 2-6? [/INST] SELECT COUNT(game) FROM table_name_17 WHERE result = "l" AND record = "2-6" </s>