Slide 32 of 41
Notes:
Here is the unnested query. Since we promoted the operators of the inner queries to the outer query, we have some new opportunities for optimization, such switching Courses with Transcripts, which makes the query more efficient.
