queries sub-queries
sub-queries
join HAVING-clause sub-queries SELECT-clause FROM-clause
sub-queries correlated-subquery
sub-queries all-operator
sub-queries any-operator
NULL-values sub-queries any-operator