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
WHERE filters rows before SELECT picks columns.
Defined for youSetup that runs before your code
CREATE OR REPLACE TABLE orders (
order_id INTEGER, country VARCHAR, status VARCHAR, amount DOUBLE
);
INSERT INTO orders VALUES
(1, 'FR', 'shipped', 120.0),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , ),
(, , , );
SELECT * FROM orders;
Hint 1
The clause goes after FROM: SELECT … FROM orders WHERE <condition>.
Hint 2 unlocks once you sign in and check your work