You can use SQL derived tables to form part of a larger integrated query using assorted SQL clauses and operators.
