1. Understanding Nested Select Statements with Examples
   Nested Select StatementsIn SQL Server, a nested select statement is a select statement that is embedded within another select statement