Back to Data Analytics
Data Analytics

Data Analytics

26 of 84 Completed

Introduction to Data Analytics
Data Analytics Fundamentals: Causal Inference
Diagnosing and Investigating Metrics
Easy SQL Questions
Medium SQL Questions
Measuring Success
A/B Testing & Experiment Design
Business Health Metrics

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!

30%

Completed

You have 58 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.