5 items
Subqueries in SELECT
Subqueries in WHERE
Subqueries in FROM
IN subqueries
Correlated subqueries