Routine~14minFree case
The Ghost Order
847 orders in the system reference customer IDs that don't exist in the customers table. They have valid products, real payment amounts, but no matching customer. Who placed them?
Tables you'll query
orderscustomersorder_items
What you'll learn
JOINsSELECT & Filtering