SQL Queries

Write correct, performant SQL across all dialects. Optimized analytical queries with CTEs.

sql analytics performance data-warehouse

When to use

Use when writing queries, optimizing slow SQL, translating between dialects, or building complex analytical queries with CTEs, window functions, or aggregations. Covers Snowflake, BigQuery, Databricks, PostgreSQL, MySQL, and other major warehouses.

Examples

Customer LTV query

Calculate lifetime value per customer cohort

Write a Snowflake query to calculate 12-month LTV by acquisition cohort using our orders and customers tables.

Funnel conversion query

Track conversion rates through a multi-step funnel

Write a BigQuery query to calculate conversion rates at each step of our signup funnel: visit → signup → activation → paid.

Rolling average

Compute a 7-day and 30-day rolling average

Add 7-day and 30-day rolling averages to this daily revenue query using window functions.