-- Database schema
| conductor : Conductor_ID [ INT ] primary_key , Name [ TEXT ] , Age [ INT ] , Nationality [ TEXT ] , Year_of_Work [ INT ] | orchestra : Orchestra_ID [ INT ] primary_key , Orchestra [ TEXT ] , Conductor_ID [ INT ] orchestra.Conductor_ID = conductor.Conductor_ID , Record_Company [ TEXT ] , Year_of_Founded [ INT ] , Major_Record_Format [ TEXT ] | performance : Performance_ID [ INT ] primary_key , Orchestra_ID [ INT ] performance.Orchestra_ID = orchestra.Orchestra_ID , Type [ TEXT ] , Date [ TEXT ] , Official_ratings_(millions) [ INT ] , Weekly_rank [ TEXT ] , Share [ TEXT ] | show : Show_ID [ INT ] , Performance_ID [ INT ] show.Performance_ID = performance.Performance_ID , If_first_show [ TEXT ] , Result [ TEXT ] , Attendance [ INT ] |
-- -- Show the names of conductors and the orchestras they have conducted.

SELECT T1.Name ,  T2.Orchestra FROM conductor AS T1 JOIN orchestra AS T2 ON T1.Conductor_ID  =  T2.Conductor_ID;