This video series explains how to write SQL queries that are commonly used to query Insights data. This article covers:

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.

Related topics

Insights overview

Insights permissions overview

Managing Insights dashboards and queries

Running Insights queries

Visualizing your Insights data

Did this answer your question?