All company names, logos, and trademarks are the property of their respective owners. Their use is for identification purposes only and does not imply endorsement.
LDS Amazon-Style SQL 30 — 30 Curated SQL Problems
A round-by-round simulator of Amazon's data interview loop, from the OA Sprint through the Bar Raiser. Schemas mirror what Amazon's teams actually work on day-to-day (retail, marketplace, logistics), and every harder problem carries the kind of probing follow-up an L6 interviewer would press on — scale, cost, ownership. Not affiliated with Amazon; built from publicly reported 2025–2026 loops.
Problems included in LDS Amazon-Style SQL 30
- Confirmed Orders With Captured Charge
- Orders With Customer Details
- Average Billed for Delivered Orders
- Orders Above Average Billed
- Customers from US or Canada
- Delivered Shipments Backed by Captured Charge
- Active Home Products Never Ordered
- Products Ordered But Never Returned
- Rank Sellers by Revenue
- Month-over-Month Order Volume Change
- Top 3 Customers by Spending Per State, With Ties
- Customers With Recent Delivered Orders (60 Days)
- Orders Above Average Within Shipping Tier
- Customers Without Refunds in the Last 90 Days
- Latest Captured Payment per Purchase
- Top Two Recent Delivered Orders per Customer
- Customers Who Re-ordered Within 7 Days
- Top Products by Recent Units Delivered (90 Days)
- Top 3 Line Items per Product — Last 60 Days
- Customer Running Spend — Last 90 Days
- Carrier Shipping Cost 3-Shipment Moving Average
- Month-over-Month Seller Revenue Growth
- Top 3 Sellers per Category, With Ties
- Customers Who Bought Electronics But Never Toys
- Products Frequently Bought Together
- Day-1 Retention Rate
- Top 5 Customers by Weekday Orders in the Last 30 Days
- Orders With Shipment Data Quality Issues
- Daily Revenue Anomaly Flag — 7-Day Rolling Deviation
- Top 3 Products by Month-Over-Month Growth
