SQL on CSV · lesson 9 of 10 · runs in your browser
Group by two things.
New table: 60 support tickets. Grouping by two columns gives one row per combination — channel × priority — and each group can carry several aggregates at once.
New table: 60 support tickets. Grouping by two columns gives one row per combination — channel × priority — and each group can carry several aggregates at once.
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.