SELECT, WHERE, and filtering

This lesson is for enrolled learners

This is where you write your first real Dune queries. Everything else in this course builds on two clauses: SELECT, which chooses which columns you want back, and WHERE, which filters which rows qualify. Blockchain tables are enormous — erc20_ethereum.evt_Transfer alone has billions of rows — so precise filtering isn't a nicety, it's the difference between a query that returns……

Enroll to continue Already enrolled? Sign in