Table: tour_dates
Columns: date_s
city_state
ticket_price_s
ticket_sold_available
ticket_grossing

Question: How much were tickets for the show in Hartford, Connecticut?
SQL: SELECT "ticket_price_s" FROM tour_dates WHERE "city_state" = 'hartford, connecticut'

Question: How many tickets were sold and how many were available for the shows that grossed $348,674?
SQL: SELECT "ticket_sold_available" FROM tour_dates WHERE "ticket_grossing" = '$348,674'

Question: How much were tickets for the show in Indianapolis, Indiana?
SQL: SELECT "ticket_price_s" FROM tour_dates WHERE "city_state" = 'indianapolis, indiana'