Subquery in FROM

sql

SELECT q.department_id, q.avg_salary
FROM (
  SELECT department_id, AVG(salary) AS avg_salary
  FROM employees
  GROUP BY department_id
) q;

Explanation

Derived tables let you treat nested query results as temporary relations.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Same sheet · prioritizing Subqueries

Filter rows based on results from another query.

Open In sheetsqlsame section

Return a single value from a nested query.

Open In sheetsqlsame section

Reference outer query columns inside the subquery.

Open In sheetsqlsame section

Return rows when a related row exists.

Open In sheetsql1 tag match

Return rows with no related matches.

Open In sheetsql1 tag match

Pre-aggregate a table and join the result.

Open In sheetsql1 tag match