Filtering with a Subquery
Filtering with CTE
Filtering with EXISTS
Subqueries as Calculated Fields
Subquery in the JOIN Statement
Updating With a Subquery
Deleting With a Subquery