Parts: br 01. What is a Subquery. br 02. Subquery Syntax. br 03. Types of Subqueries. br 04. Where Can Subqueries Be Used. br 05. Comparison Conditions pt. 1. br 06. Comparison Conditions pt. 2. br 07. Regular vs. Correlated Subqueries. br 08. Using the WITH Clause. br 09. Nested Semi Joins.