List the names of orchestras that have performance.
create table orchestra (orchestra varchar, orchestra_id varchar, PRIMARY KEY (orchestra)); create table performance (orchestra varchar, orchestra_id varchar, PRIMARY KEY (orchestra))
select orchestra from orchestra where orchestra_id in (select orchestra_id from performance)