SQL on CSV · lesson 7 of 10 · runs in your browser
Totals and averages.
The other four aggregates: SUM totals a numeric column, AVG averages it, MIN and MAX find its extremes. Several can ride in one query.
The other four aggregates: SUM totals a numeric column, AVG averages it, MIN and MAX find its extremes. Several can ride in one query.
Every lesson runs a real SQL engine on real data, locally — no setup, no account, nothing uploaded. Your progress saves in your browser.
Each lesson is one concept with runnable examples — click any “try it” to load it into the editor.
Edit and run anything (Ctrl+Enter). The data is a real generated CSV — the same one every learner sees.
Exercises are verified by comparing your result against a reference — any correct query passes, not just one exact answer.
Ten lessons from SELECT to multi-column GROUP BY.
Your first SQL on a real CSV: SELECT * to see everything, LIMIT to take just a few rows.
Select only the columns you need and rename them with AS.
Filter CSV rows with WHERE: equality, greater/less than, text and numbers.
Combine filters with AND/OR and match text patterns with LIKE and % wildcards.