I want to know the tie for drawn of 47
CREATE TABLE table_name_46 (tied VARCHAR, drawn VARCHAR)
SELECT tied FROM table_name_46 WHERE drawn = "47"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_46 (tied VARCHAR, drawn VARCHAR) Question: I want to know the tie for drawn of 47 [/INST] SELECT tied FROM table_name_46 WHERE drawn = "47" </s>