subquery ::=
SELECT [ LIMIT n m ] [ DISTINCT | ALL ] select_list
FROM join_source
[ where_clause ]
[
group_by_clause ]
[
compound_operator subquery ]
[
order_by_clause ]
subquery