SQL Fundamentals with DuckDB | Demo Academy

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 WHERE clause to the starter query.
Keep only rows where amount is greater than 200.
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),
  (2, 'DE', 'shipped', 80.5),
  (3, 'FR', 'pending', 250.0),
  (4, 'NL', 'shipped', 310.75),
  (5, 'DE', 'shipped', 145.0),
  (6, 'FR', 'shipped', 99.99),
  (7, 'NL', 'cancelled', 180.0),
  (8, 'DE', 'shipped', 220.1),
  (9, 'FR', 'shipped', 175.25),
  (10, 'NL', 'shipped', 65.0),
  (11, 'DE', 'pending', 400.0),
  (12, 'FR', 'shipped', 130.4);

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

SQL Fundamentals with DuckDB

What you'll learn

Who this is for

Before you start

About this course

Try a lab from this course

Lab: Filter orders with WHERE