Views built on views

• A

  A runs first, then B runs over whatever it produced, then C runs over that, as three distinct stages

• B

  Only C runs, because the deeper views are cached from previous reads

• C

  The definitions are expanded into one query, which the optimiser plans as a whole

• D

  The database refuses, because views cannot be nested more than two deep