Treat an Intermediate Result as a Table
A subquery in FROM produces a derived table. Give it a name, then reference its columns from the outer SELECT or WHERE.
GOAL
Explain how a derived table is created and referenced.
What must a FROM subquery result be given?