Retail and e-commerce · retail analytics
Retail and e-commerce Data Analyst Interview Questions
Retail and e-commerce, also written retail analytics, means Amazon, Walmart, Target, Best Buy, Etsy, Flipkart, Instacart, Nykaa, Shopify, Blinkit, Myntra and Wayfair. These 75+ data analyst 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 unique characterPython
Amazoneasy - In-stock electronicsSQLBest Buyeasy
- Inventory valueSQLWalmarteasy
- Items and aisles per orderPandas
Instacarteasy - 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 by statusSQLTargeteasy
- 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
- Total completed revenueSQLWalmarteasy
- Trusted shop reviewsPandasEtsyeasy
- Unfinished orders over 50SQLTargeteasy
- Big orders or a loyal customerSQLBest Buymedium
- Cheapest channel per campaignSQL
Nykaamedium - Counting what is recordedSQLWalmartmedium
- Customers with repeat ordersSQLTargetmedium
- Customers without ordersSQLAmazonmedium
- 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
- Order sequence per customerSQLWalmartmedium
- Orders from enterprise customersSQLAmazonmedium
- Orders per calendar monthSQLWalmartmedium
- Orders per customer segmentSQLAmazonmedium
- Packages still movingSQLAmazonmedium
- Plan changesSQL
Shopifymedium - Price after discountSQLWalmartmedium
- Price dropsSQLPremiumMyntramedium
- Prime vs. standard order valueSQLAmazonmedium
- 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
- Verified rating by shopSQLEtsymedium
- Weekend ordersSQLWalmartmedium
- Which products repeat?Python
Wayfairmedium - Averages that skip NULLsSQLAmazonhard
- Cost per order gridPandasPremiumNykaahard
- Every stockout windowSQLPremiumBlinkithard
- Largest order per customerPandasAmazonhard
- Longest price holdSQLPremiumMyntrahard
- Longest stockout runSQLBlinkithard
- Minutes from order to doorstepSQLPremiumInstacarthard
- Slowest package per facilitySQLAmazonhard
- Top spending customersSQLAmazonhard
- Unbroken runs of monthsSQLShopifyhard
Questions last reviewed 19 October 2026.