A subquery is a query that is nested inside another query and provides data to the outer query. A subquery can be used to filter, aggregate or transform data.
Example of a query with a subquery:
SELECT *
FROM Customers
WHERE Country IN (SELECT Country FROM Suppliers);