Subquery Unnesting and Flattening

You will rewrite subqueries to allow the planner to flatten them into joins for efficiency.