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