Retail and e-commerce · retail analytics
Retail and e-commerce Data Science Interview Questions
Retail and e-commerce, also written retail analytics, means Amazon, Best Buy, Target, Walmart, Etsy, Flipkart, Instacart, Nykaa, Shopify, Blinkit, Myntra and Wayfair. These 65+ data science interview questions come from all of them, in SQL, Python and pandas. Start solving and check your level of preparation.
Companies on this page
All the questions
- Active productsSQL
Targeteasy - Anagram checkPython
Etsyeasy - Best week of salesPythonTargeteasy
- Clearance candidatesSQLTargeteasy
- Customers outside the US and MexicoSQL
Walmarteasy - Electronics and accessoriesSQL
Best Buyeasy - Even-numbered ordersSQLBest Buyeasy
- Find a price in a sorted listPythonBest Buyeasy
- First item bought twicePython
Instacarteasy - First unique characterPython
Amazoneasy - In-stock electronicsSQLBest Buyeasy
- Items and aisles per orderPandasInstacarteasy
- Large orders with customer namesSQLAmazoneasy
- Merge sales by regionPythonTargeteasy
- Missing order numberPythonWalmarteasy
- Move zero-sale days to the endPythonBest Buyeasy
- Orders above the averageSQLWalmarteasy
- Orders per customerSQLTargeteasy
- Orders placed in March 2024SQLBest Buyeasy
- Price bandsSQLAmazoneasy
- Pro productsSQLBest Buyeasy
- Products launched in 2024SQLTargeteasy
- Products under 50SQLWalmarteasy
- Products with no brandSQLAmazoneasy
- Revenue by categoryPandasAmazoneasy
- Rotate a shift schedulePythonWalmarteasy
- Show missing discounts as zeroSQLTargeteasy
- Stock statusSQLAmazoneasy
- Trusted shop reviewsPandasEtsyeasy
- Unfinished orders over 50SQLTargeteasy
- Big orders or a loyal customerSQLBest Buymedium
- Cheapest channel per campaignSQL
Nykaamedium - Counting what is recordedSQLWalmartmedium
- Customers who came backPythonTargetmedium
- Damage share of refundsSQL
Flipkartmedium - Deepest cut per productSQL
Myntramedium - Flatten a category treePythonAmazonmedium
- Hours between scansSQLAmazonmedium
- How often it ran outSQL
Blinkitmedium - Kth largest orderPythonInstacartmedium
- Latest order statusPandasInstacartmedium
- Most common review wordPythonEtsymedium
- Order sequence per customerSQLWalmartmedium
- Packages still movingSQLAmazonmedium
- Plan changesSQL
Shopifymedium - Price dropsSQLPremiumMyntramedium
- Refunds so farSQLPremiumFlipkartmedium
- Returns by reasonSQLPremiumFlipkartmedium
- Revenue by plan and monthPandasShopifymedium
- Revenue by statePandasAmazonmedium
- Revenue to date per merchantSQLShopifymedium
- Shops per tagPandasEtsymedium
- Spend by channelSQLPremiumNykaamedium
- Spend to dateSQLPremiumNykaamedium
- Stage times per packageSQLAmazonmedium
- The busiest customerSQLAmazonmedium
- Top reason per categorySQLPremiumFlipkartmedium
- Weekend ordersSQLWalmartmedium
- Which products repeat?Python
Wayfairmedium - Averages that skip NULLsSQLAmazonhard
- Compare with the previous orderSQLBest Buyhard
- Cost per order gridPandasPremiumNykaahard
- Every stockout windowSQLPremiumBlinkithard
- Largest order per customerPandasAmazonhard
- Longest price holdSQLPremiumMyntrahard
- Longest stockout runSQLBlinkithard
- Slowest package per facilitySQLAmazonhard
- Unbroken runs of monthsSQLShopifyhard
Questions last reviewed 19 October 2026.