epochs

Learn · Module 15 · Statistics and experiments · Lesson 5 of 5

SQL for analysis

Most data analysis starts with SQL. Five patterns cover most of what you'll need.

5 minute read

In short
  • JOIN plus GROUP BY answers most 'per something' questions.
  • LEFT JOIN with IS NULL finds missing matches; HAVING filters after grouping.
  • Window functions compute running totals and rankings without collapsing rows.

This lesson is part of Pro

The first two lessons of every module are free. Pro opens every lesson and every project.

See Pro plansFrom ₹119 a month. No auto-renewal.