CREATE TABLE teaches (ID VARCHAR2)
CREATE TABLE instructor (ID VARCHAR2)

Find the names of all instructors who have taught some course and the course_id.
SELECT name, course_id FROM instructor AS T1 JOIN teaches AS T2 ON T1.ID = T2.ID
SELECT "name", "course_id" FROM "instructor" "T1" JOIN "teaches" "T2" ON "T1"."ID" = "T2"."ID"