🧠 Task 6: Subqueries and Nested Queries (SQL)

🎯 Objective

To practice writing subqueries (nested queries) in different parts of a SQL statement — including SELECT, WHERE, and FROM — to build more powerful and flexible data retrieval logic.

---

🛠️ Tools Used

• ✅ MySQL Workbench

---

📂 Deliverables

SQL queries demonstrating:

• Scalar subqueries
• Correlated subqueries
• Subqueries used with:
  • IN
  • EXISTS
  • =

---