Subqueries can be used in the list that follows from in exactly the same
manner that tables are used. This is shown in the next example:
Example 5.11.5 To find the pairs of names of students and instructors such
that the student took some course with the instructor we could write: