Routine~12min

The Stale Cart

Customers are calling in about wrong prices — some are being quoted more than the website shows, some less. The cart service stores unit_price at the time of add-to-cart and never refreshes it. 29 active cart items are carrying outdated prices. Seven others have price_locked=TRUE — those are intentional promotional locks, not the problem.

Tables you'll query

productscart_items

What you'll learn

JOINsSELECT & Filtering
Investigate this case →