MISSION 255

Subqueries

Learn how to write complex, nested queries using subqueries.

Objectives

  • Learn how to use subqueries to nest queiries in the SELECT clause.
  • Learn how to use subqueries to nest queries in the WHERE clause.

Mission Outline

1. Writing More Complex Queries
2. Subqueries
3. Subquery In SELECT
4. Returning Multiple Results In Subqueries
5. Building Complex Subqueries
6. Practice Integrating A Subquery With The Outer Query
7. Next Steps
8. Takeaways

sql-fundamentals

Course Info:

SQL Fundamentals

Beginner

The median completion time for this course is 6.3 hours.

This course requires a basic subscription and includes five missions and one guided project.  It is the 11th course in the Data Analyst in Python path and the Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside