On what date did a friendly competition, hosted in Dubai, result in a draw?
CREATE TABLE table_name_79 (date VARCHAR, venue VARCHAR, result VARCHAR, competition VARCHAR)
SELECT date FROM table_name_79 WHERE result = "draw" AND competition = "friendly" AND venue = "dubai"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_79 (date VARCHAR, venue VARCHAR, result VARCHAR, competition VARCHAR) Question: On what date did a friendly competition, hosted in Dubai, result in a draw? [/INST] SELECT date FROM table_name_79 WHERE result = "draw" AND competition = "friendly" AND venue = "dubai" </s>