Table: tour_dates
Columns: date_s
venue
city_state
ticket_price_s
ticket_sold_available
ticket_grossing

Question: What venue is in Wantagh, New York?
SQL: SELECT "venue" FROM tour_dates WHERE "city_state" = 'Wantagh, New York'

Question: How much do the tickets cost for August 7, 1987?
SQL: SELECT "ticket_price_s" FROM tour_dates WHERE "date_s" = 'August 7, 1987'

Question: How many tickets are sold for the Carver-Hawkeye Arena? 
SQL: SELECT "ticket_sold_available" FROM tour_dates WHERE "venue" = 'Carver-Hawkeye Arena'