Learn SQL Lesson

Order Items Feel Better

In a normalized schema, each ordered product gets its own row in `order_items`. That means products are queryable with normal joins and filters.

Instead of asking, "Does this big text blob contain Keyboard?", you can say, "Which `order_items` rows point to the Keyboard product?" That is much cleaner and much more reliable.

Load the normalized tables and try the same business question again.

Practice challenge

List the orders that contain the Keyboard product. Return order_id and product_name, ordered by order_id.

Open interactive editor