Task 6 – Subqueries and Nested Queries

This project demonstrates use of scalar, correlated, and nested subqueries in SQL with Customers and Orders tables.

Includes

• Database + table creation (schema.sql)
• Sample data insert
• Subqueries in:
  • SELECT
  • WHERE
  • EXISTS
  • FROM (derived table)

Key Concepts

Subqueries, nested queries, filtering, advanced query logic