Learn SQL Lesson

Products Can Exist Without Orders

A normalized schema fixes both insert and delete anomalies by giving products their own table.

That means a product can exist before the first order is placed, and it can still exist after the last order is deleted. Product facts are no longer tied to the survival of order rows.

In the sample below, Monitor Stand exists in the `products` catalog but has not been ordered yet. See if you can find it.

Practice challenge

Find the products that have not been ordered yet. Return product_name and times_ordered, ordered by product_name.

Open interactive editor