SQL FOUNDATIONS:Joins and Aggregations

Connect tables and compute summaries with JOIN and GROUP BY.

Joins and Aggregations Theory

Understand the idea first, then validate it using the data explorer and SQL editor.

Use schema relationships and table preview to build confidence before writing final queries.

Diagram:
Concept map for Joins and Aggregations

Joins and Aggregations Example

Practice starts with exploring data and validating assumptions.

SQL
SELECT * FROM table_name LIMIT 5;

Joins and Aggregations Missions

Solve exercises in sequence to unlock the next mission.

1

Recent releases with directors

Show movies after 2020 with director names.

Solve Mission
2

Count movies per director

Count movies per director, highest first.

Locked
3

Total spend by city

Sum total order value by customer city.

Locked