Table: queen_magic_tour_data
Columns: venue
city
tickets_sold_available
gross_revenue_1986
gross_revenue_2011

Question: How many tickets were there sold/available in Barcelona?
SQL: SELECT "tickets_sold_available" FROM queen_magic_tour_data WHERE "city" = 'barcelona'

Question: How many tickets were sold/available when the gross revenue (2011) was $366,916?
SQL: SELECT "tickets_sold_available" FROM queen_magic_tour_data WHERE "gross_revenue_2011" = '$366,916'

Question: How many tickets were sold/available when the gross revenue (2011) was $5,948,390?
SQL: SELECT "tickets_sold_available" FROM queen_magic_tour_data WHERE "gross_revenue_2011" = '$5,948,390'

Question: What was the gross revenue (1986) when there were tickets sold/available of 24,000 / 24,000 (100%)?
SQL: SELECT "gross_revenue_1986" FROM queen_magic_tour_data WHERE "tickets_sold_available" = '24,000 / 24,000 (100%)'