Table: crazy_tour_venues
Columns: venue
city
tickets_sold_available
gross_revenue_1979
gross_revenue_2012

Question: Which venue has Tickets Sold/ Available with a Gross Revenue (1979) of $665,232?
SQL: SELECT "tickets_sold_available" FROM crazy_tour_venues WHERE "gross_revenue_1979" = '$665,232'

Question: What is the Gross Revenue (1979) of the Venue, lyceum theatre?
SQL: SELECT "gross_revenue_1979" FROM crazy_tour_venues WHERE "venue" = 'lyceum theatre'

Question: What is the amount of Tickets Sold/ Available at the Venue of hippodrome?
SQL: SELECT "tickets_sold_available" FROM crazy_tour_venues WHERE "venue" = 'hippodrome'

Question: Which Venue has a Gross Revenue (2012) of $179,712?
SQL: SELECT "venue" FROM crazy_tour_venues WHERE "gross_revenue_2012" = '$179,712'

Question: Which Venue has an amount of Tickets Sold/ Available of 4,700 / 4,700 (100%)?
SQL: SELECT "venue" FROM crazy_tour_venues WHERE "tickets_sold_available" = '4,700 / 4,700 (100%)'