Table: astaire_performances
Columns: title
date
theatre
role
dance_partner
director
lyrics
music

Question: Which title did richard kolner play?
SQL: SELECT "title" FROM astaire_performances WHERE "role" = 'richard kolner'

Question: Which Title has a Dance Partner of adele astaire, and Lyrics of ira gershwin, and a Director of felix edwardes?
SQL: SELECT "title" FROM astaire_performances WHERE "dance_partner" = 'adele astaire' AND "lyrics" = 'ira gershwin' AND "director" = 'felix edwardes'

Question: Which Role has a Theatre of globe, and a Music of jerome kern?
SQL: SELECT "role" FROM astaire_performances WHERE "theatre" = 'globe' AND "music" = 'jerome kern'