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