Time to use what you just learned. Your query runs on a real DuckDB database in your browser — press Run to see the rows, then Check my work when the result looks right.
Lab: Filter orders with WHERE
Starting DuckDB…SQLAbout 10 min
Run the starter query first — 12 orders. Now narrow it down to the big ones: orders over €200.
Add a
WHEREclause to the starter query.Keep only rows where
amountis greater than200.WHERE filters rows before SELECT picks columns.
SELECT * FROM orders;
Hint 1
The clause goes after FROM: `SELECT … FROM orders WHERE <condition>`.
Hint 2 unlocks after your next attempt