SQL Subqueries

It is often impossible to solve a given task with just one query. In such cases, subqueries are used: internal, nested queries.