This video series explains how to write SQL queries that are commonly used to query Insights data. This article covers different clauses, column calculations, aggregate functions, JSON processing functions, and window functions.
SQL Introduction and foundational clauses
This video introduces SQL and its foundational concepts, like column calculation and the following clauses:
-
SELECT
-
FROM
-
AS
WHERE and JOIN clauses
This video introduces WHERE and JOIN clauses in SQL and how to use them in Insights.
CTEs, ORDER BY, LIMIT, and OFFSET
This video introduces the concept of CTE and these clauses:
-
LIMIT
-
OFFSET
-
ORDER BY
Aggregate functions and GROUP BY clause
This video introduces aggregate functions and the GROUP BY clause.
Partitions and JSON Manipulation
This video introduces JSON processing functions and the PARTITION BY clause.
Window functions
This video introduces window functions, where you can calculate across a set of table rows that are related to the current row.