Slide 25 of 41
Notes:
But there are queries that cannot be unnesting by normalization alone. Here is a comprehension that contains another comprehension in its head. This query cannot be unnested by normalization.