When is Country of united states, and a Venue of mandalay bay resort in?
CREATE TABLE table_name_22 (date VARCHAR, country VARCHAR, venue VARCHAR)
SELECT date FROM table_name_22 WHERE country = "united states" AND venue = "mandalay bay resort"
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE table_name_22 (date VARCHAR, country VARCHAR, venue VARCHAR) Question: When is Country of united states, and a Venue of mandalay bay resort in? [/INST] SELECT date FROM table_name_22 WHERE country = "united states" AND venue = "mandalay bay resort" </s>