user: ### NOW ANSWER:
Question: Who was rose in the 1975 Broadway revival?
Columns: ['Productions', 'Rose', 'Louise', 'Dainty June', 'Herbie', 'Director']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['1959 Broadway original', 'Ethel Merman', 'Sandra Church', 'Lane Bradbury', 'Jack Klugman', 'Jerome Robbins']
SQL:

assistant: SELECT "Rose" FROM "Table" WHERE "Productions" = '1975 Broadway revival';