Table: bergman_performances
Columns: year
play
role
theatre
location

Question: Tell me the role of festival theatre
SQL: SELECT "role" FROM bergman_performances WHERE "theatre" = 'festival theatre'

Question: Tell me the lowest year for shubert theatre
SQL: SELECT MIN("year") FROM bergman_performances WHERE "theatre" = 'shubert theatre'

Question: Tell me the total number of years for lady cecily waynflete and opera house, kennedy center
SQL: SELECT COUNT("year") FROM bergman_performances WHERE "role" = 'lady cecily waynflete' AND "theatre" = 'opera house, kennedy center'

Question: Tell me the role for tea and sympathy
SQL: SELECT "role" FROM bergman_performances WHERE "play" = 'tea and sympathy'