BR Academy
0%
SQL Foundations for On-Chain Data·Lesson 7 of 23·12 min

GROUP BY, COUNT, SUM, and window functions

This lesson is for enrolled learners

Raw event rows (one per transfer, one per swap) answer "what happened." Dashboards and research answer "how much, how often, trending which way" — and that transformation happens through GROUP BY aggregation and window functions. These two tools are the dividing line between a beginner who can filter rows and an analyst who can produce a metric someone will actually……

Enroll to continue Already enrolled? Sign in