user: Question: When is Country of United States, and a Venue of Mandalay Bay Resort in?
Columns: ['Date', 'City', 'Country', 'Venue', 'Attendance']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['July 20, 2007', 'Sault Ste. Marie, Michigan', 'United States', 'Kewadin Casino', '10,000']
SQL:

assistant: SELECT "Date" FROM "Table" WHERE "Country" = 'United States' AND "Venue" = 'Mandalay Bay Resort';