Excellent! Looks like you've mastered all parts of the SQL Basics course. Congratulations!
Before you finish, we have one final task for you. It's a bit more complicated than the previous tasks and you should combine the knowledge from different parts of the course to solve it. Let's take a look into a database at a florist's shop:
customer (id, name, country)
purchase (id, customer_id, year)
purchase_item (id, purchase_id, name, quantity)
Here customers purchase flowers.
Each purchase consists of one or more purchase_item
s. Each purchase_item belongs to one purchase (column purchase_id
).
For example, if John Smith places an order for 2 roses and 1 lily, there will be two purchase_item
s in this specific purchase: one identifying a rose (the column quantity
would contain the value 2 here) and one identifying a lily (column quantity
would contain the value 1 here).
All purchase IDs are stored chronologically, i.e., the last ID placed in the shop has the highest ID.