Back to SQL


24 of 56 Completed

Introduction to SQL
Beginner SQL Questions
Easy SQL Questions
SQL Interview Tips
Medium SQL Questions
Hard SQL Questions

Subqueries and CTEs

As we have seen, SQL queries usually return tables that are different from the ones we have stored in the database.

In our database, tables are normalized and very large, which makes them hard to use. Meanwhile, the tables we get by joining, filtering, and selecting the data we need tend to be much friendlier.

Subqueries let us perform complex queries in

Good job, keep it up!



You have 32 sections remaining on this learning path.

There's so much more to Interview Query! Sign up to access hundreds of interview questions, expert coaching and a flourishing data science community.