Tell me the lost with tie of 0 and drawn of 47
CREATE TABLE table_name_20 (lost VARCHAR, tied VARCHAR, drawn VARCHAR)
SELECT lost FROM table_name_20 WHERE tied = "0" AND drawn = "47"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_20 (lost VARCHAR, tied VARCHAR, drawn VARCHAR) Question: Tell me the lost with tie of 0 and drawn of 47 [/INST] SELECT lost FROM table_name_20 WHERE tied = "0" AND drawn = "47" </s>