Derived table

Also written: derived tables

A subquery in FROM, used as a temporary table. It lets you aggregate twice, for example totaling each order first and then averaging those totals.