Show the names of conductors and the orchestras they have conducted.
create table conductor (name varchar, conductor_id varchar, PRIMARY KEY (name)); create table orchestra (orchestra varchar, conductor_id varchar, PRIMARY KEY (orchestra))
select t1.name, t2.orchestra from conductor as t1 join orchestra as t2 on t1.conductor_id = t2.conductor_id