What are the names of all instructors who have taught a course, as well as the corresponding course id?
SELECT name ,  course_id FROM instructor AS T1 JOIN teaches AS T2 ON T1.ID  =  T2.ID
names of all instructors who have taught a course refers to SELECT name; corresponding course id refers to course_id; JOIN is used to combine rows from two or more tables based on a related column between them.