Table: concert_events
Columns: date
city
country
venue
attendance

Question: When is  Cadott Rock Fest taken place?
SQL: SELECT "date" FROM concert_events WHERE "venue" = 'cadott rock fest'

Question: Which City has mandalay bay resort
SQL: SELECT "city" FROM concert_events WHERE "venue" = 'mandalay bay resort'

Question: Which City has a Date on october 26, 2007
SQL: SELECT "city" FROM concert_events WHERE "date" = 'october 26, 2007'

Question: Which Attendance has Mandalay Bay Resort
SQL: SELECT "attendance" FROM concert_events WHERE "venue" = 'mandalay bay resort'

Question: When is Country of united states, and a Venue of mandalay bay resort in?
SQL: SELECT "date" FROM concert_events WHERE "country" = 'united states' AND "venue" = 'mandalay bay resort'

Question: When has a City of san jacinto, california?
SQL: SELECT "date" FROM concert_events WHERE "city" = 'san jacinto, california'