SUBQUERIES:
SYNTAX
SELECT column list
FROM table(s)
WHERE <column_name>
<comparison> |
EXISTS]
(SELECT column list
FROM table(s)
... )
[AND | OR other criteria]
GROUP BY column list
HAVING
...
ORDER BY column list