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.
What must a FROM subquery result be given?
A subquery in FROM produces a derived table. Give it a name, then reference its columns from the outer SELECT or WHERE.
What must a FROM subquery result be given?