SQL on CSV · lesson 4 of 10 · runs in your browser
Combine conditions, match patterns.
One condition is rarely enough. AND narrows, OR widens, and LIKE matches shapes of text instead of exact values.
One condition is rarely enough. AND narrows, OR widens, and LIKE matches shapes of text instead of exact values.
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.