SQL Analytics Skill

Master analytical SQL patterns for business intelligence, including window functions, CTEs, cohort analysis, and performance optimization.

Quick Start (5 minutes)

-- The 3 essential patterns for BI analysts:

-- 1. Aggregation with GROUP BY
SELECT region, SUM(sales) as total_sales
FROM orders GROUP BY region;

-- 2. Window function for running total
SELECT date, sales,
       SUM(sales) OVER (ORDER BY date) as running_total
FROM daily_sales;