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