Table: sports_events_2011
Columns: date
event
location
attendance
ppv_buyrate

Question: Where was the event on June 10?
SQL: SELECT "location" FROM sports_events_2011 WHERE "date" = 'june 10'

Question: What event was in New Orleans, Louisiana, USA?
SQL: SELECT "event" FROM sports_events_2011 WHERE "location" = 'new orleans, louisiana, usa'

Question: On September 10 during Strikeforce: Heavyweight Grand Prix Semifinals, what was the PPV buyrate?
SQL: SELECT "ppv_buyrate" FROM sports_events_2011 WHERE "date" = 'september 10' AND "event" = 'strikeforce: heavyweight grand prix semifinals'