Practise · Preview, then delete

Opening your saved work…

The reading

Preview, then delete

SELECT COUNT(*) AS orders_left, MIN(order_date) AS earliest
FROM orders;

The question to ask after the delete: how many are left, and where does the data now start? Open in the playground

DELETE FROM orders WHERE order_date < '2026-01-20' removes whole rows, 71 of them. The same two rules apply: preview with the same WHERE first, and read what remains. 204 orders minus 71 is 133, and SELECT COUNT(*), MIN(order_date) FROM orders afterwards should say 133 and 2026-01-20. If it says 122, your boundary ate the 20th.

DELETE with no WHERE empties the table, row by row, with no undo in the browser and no undo on the desktop either, unless you were inside a transaction. The disposable copy means you can try it once to see what 'no rows' looks like.

Rule of thumb. Preview the rows, delete them, then count and inspect what remains.

Going deeper (optional, not on the exam)

With foreign keys on, a parent row with children refuses to go: DELETE FROM employees WHERE id = 24 fails with FOREIGN KEY constraint failed, because seven orders point at that employee. The database is protecting the orders. What to do about them is a design decision, which chapter 6 and Lab 10 cover.

Preview, then delete · DELETE ... WHERE, and what remains · level 3 of 6

How many orders remain?

Level 3: Predict the result · Exercise 1 of 1

There are 204 orders, from 13 January to 31 January. DELETE FROM orders WHERE order_date < '2026-01-20' removes 71 of them. Before you check, how many remain?

SELECT COUNT(*) AS orders_left
FROM orders
WHERE order_date >= '2026-01-20';

The query. Predict before you run it.

Data: Northshore Coffee.

I would like help with this exercise

Opens once your prediction is right, or after the worked answer.

Query results

The real result appears here after you run it.

Practice here is evidence for you and your instructor, never a grade. Grades live in Canvas.