Subquery & CTE

Analytics SQL

Stephanie

Lead Data Scientist @JULO | Ex. GOJEK, UNILEVER.

Course Overview

Learn SQL fundamentals for analytics and query large datasets with Google BigQuery.

This lesson

Break complex SQL into manageable parts with subqueries and common table expressions (CTE).

Window Functions