Explore how to write SQL Server sub queries, simple sub query, multi-level nested sub query, correlated sub query and sub queries with DML statements