Table: farmer_tour_data
Columns: date
city
country
venue
tickets_available_since
attendance
comment

Question: How many tickets were available at Halle Tony Garnier on June 15, 2009?
SQL: SELECT "tickets_available_since" FROM farmer_tour_data WHERE "venue" = 'halle tony garnier' AND "date" = 'june 15, 2009'

Question: What city had tickets available since March 28, 2008 and went on sale on September 4, 2009?
SQL: SELECT "city" FROM farmer_tour_data WHERE "tickets_available_since" = 'march 28, 2008' AND "date" = 'september 4, 2009'