For example, you can use a subquery to find the average salary of employees in a department, ... (MySQL/MariaDB, PostgreSQL, Microsoft SQL Server, etcetcetc), your SQL, ...

Using a Pass-Through Query in a Subquery The next example shows how to use a subquery that contains a Pass-Through query. A subquery is a nested query and is usually part of a WHERE or HAVING clause.