The aim of this task is to demonstrate advanced SQL query skills using different types of subqueries and nested queries in MySQL, including scalar, correlated, IN, EXISTS, and derived tables.

Overview: This SQL script demonstrates the use of subqueries and nested queries in various clauses (SELECT, WHERE, FROM) using an Employees and Departments database.