Table: gypsy_table
Columns: productions
rose
louise
dainty_june
herbie
director

Question: Who was Louise when Tracy Venner was Dainty June?
SQL: SELECT "louise" FROM gypsy_table WHERE "dainty_june" = 'tracy venner'

Question: Who was Dainty June when Tammy Blanchard was Louise?
SQL: SELECT "dainty_june" FROM gypsy_table WHERE "louise" = 'tammy blanchard'

Question: Who was Dainty June when Boyd Gaines was Herbie?
SQL: SELECT "dainty_june" FROM gypsy_table WHERE "herbie" = 'boyd gaines'

Question: What production had Angela Lansbury as Rose and Barrie Ingham as Herbie?
SQL: SELECT "productions" FROM gypsy_table WHERE "rose" = 'angela lansbury' AND "herbie" = 'barrie ingham'

Question: Who was rose in the 1975 Broadway Revival?
SQL: SELECT "rose" FROM gypsy_table WHERE "productions" = '1975 broadway revival'

Question: Which production had Rex Robbins as Herbie?
SQL: SELECT "productions" FROM gypsy_table WHERE "herbie" = 'rex robbins'