what is the total number of ties played where total w–l is 38–24
CREATE TABLE table_10294071_1 (ties_played VARCHAR, total_w_l VARCHAR)
SELECT COUNT(ties_played) FROM table_10294071_1 WHERE total_w_l = "38–24"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_10294071_1 (ties_played VARCHAR, total_w_l VARCHAR) Question: what is the total number of ties played where total w–l is 38–24 [/INST] SELECT COUNT(ties_played) FROM table_10294071_1 WHERE total_w_l = "38–24" </s>