Execute the following
script in Query Editor to demonstrate the use of derived table (SELECT FROM SELECT) in a query. Derived tables are frequently used to JOIN back GROUP BY results to base tables:
SELECT DepartmentID, Department=[Name]
WHERE GroupName = 'Sales and Marketing'
) AS DepartmentDerivedTable
ORDER BY Department