Data Interview Questions
Practice real interview questions for Data & AI roles, and build the skills that get you hired.
Showing 209 of 209 questions
VisaCross-border share by card tierSQLConditional logichard
MetaAverage reactions per post typeSQLJoinsmedium
SpotifyTop track per listenerSQLRankingmedium
UberCompleted trips by hour of daySQLDateseasy
InstacartLatest order statusPandasDeduplicationmedium
MicrosoftSalary against department totalSQLWindow functionseasy
StripeLongest streak of successful paymentsPythonArrayseasy- VisaMonthly approved spendPandasDatesmedium
NetflixWatch time by genrePandasJoinseasy
WalmartTotal completed revenueSQLAggregationseasy
ShopifyRevenue by plan and monthPandasReshapingmedium
PhonePeFailures in a rowSQLPremiumWindow functionshard
PinterestTop pin categoriesPythonHashingmedium
GooglePaid above the department averageSQLSubquerieshard- UberAverage rating by vehicle typePandasJoinsmedium
DatadogQuiet time between incidentsSQLWindow functionsmedium
AmazonProducts with no brandSQLNULL handlingeasy
AtlassianSlowest ticket per projectSQLRankingmedium
LyftLowest and highest farePythonTupleseasy
Best BuyPro productsSQLFilteringeasy
ZillowTwo homes that match a budgetPythonHashingmedium
Capital OneMissed minimum paymentsSQLPremiumAggregationsmedium- AmazonLargest order per customerPandasRankinghard
ZerodhaPosition after each tradeSQLRunning totalsmedium
EtsyTrusted shop reviewsPandasFilteringeasy
AirbnbLongest trip without repeat citiesPythonPremiumTwo pointershard
FanDuelPlace within the contestPandasRankingmedium- WalmartMissing order numberPythonMatheasy
- AmazonTop spending customersSQLJoinshard
- StripeMonthly completed revenueSQLAggregationshard
TargetProducts launched in 2024SQLDateseasy
SwiggyDelivery time by cityPandasNULL handlingeasy- MetaHighest paid in each departmentSQLSubquerieshard
- TargetMerge sales by regionPythonDictionarieseasy
CoinbaseDrawdown from the peakSQLRunning totalshard
DoorDashDelivery time by cuisineSQLDatesmedium
SalesforceWin rate by sales repSQLPremiumConditional logicmedium- MicrosoftFizzBuzzPythonMatheasy
RobinhoodOpen positions by userSQLConditional logicmedium- NetflixMerge viewing sessionsPythonArraysmedium
- AmazonCustomers without ordersSQLJoinsmedium
- StripeRunning account balancePandasPremiumRunning totalsmedium
- Best BuyBig orders or a loyal customerSQLLogical operatorsmedium
- TargetShow missing discounts as zeroSQLNULL handlingeasy
- MetaPosting on consecutive daysSQLPremiumWindow functionshard
- WalmartRotate a shift schedulePythonListseasy
NykaaSpend to dateSQLPremiumRunning totalsmedium
LinkedInReverse the wordsPythonStringseasy- AmazonOrders from enterprise customersSQLSubqueriesmedium
- SalesforceDepartment headcount and paySQLAggregationsmedium
- WalmartOrder sequence per customerSQLWindow functionsmedium
MastercardMerchants with high fraud ratesSQLAggregationsmedium- RobinhoodBest single tradePythonArraysmedium
BlinkitLongest stockout runSQLWindow functionshard- AmazonStage times per packageSQLReshapingmedium
- StripeNet balance by accountSQLConditional logicmedium
- LyftBusiest hour per cityPandasPremiumDateshard
DraftKingsEveryone in the top threeSQLRankingmedium- ZerodhaPrice moved since last tradeSQLPremiumWindow functionsmedium
- AirbnbCancellation rate by room typeSQLConditional logicmedium
- Best BuyFind a price in a sorted listPythonBinary searcheasy
- ZillowListings missing a pricePandasNULL handlingeasy
- DoorDashTop restaurant in each citySQLPremiumWindow functionshard
- NykaaCost per order gridPandasPremiumReshapinghard
- CoinbaseThree day averageSQLWindow functionsmedium
- MastercardRead a nested settingPythonDictionariesmedium
- DatadogSeverity mix per serviceSQLReshapingmedium
- EtsyMost common review wordPythonStringsmedium
MyntraDeepest cut per productSQLRankingmedium- AmazonThe busiest customerSQLSubqueriesmedium
- SpotifyListening time so farSQLRunning totalsmedium
- TargetBest week of salesPythonSliding windoweasy
WorkdaySort employee recordsPythonTuplesmedium
FlipkartReturns by reasonSQLPremiumReshapingmedium- AmazonAverages that skip NULLsSQLNULL handlinghard
- StripeRevenue by countrySQLJoinsmedium
- NetflixMost-watched title in each countrySQLPremiumWindow functionshard
- UberFare per kilometer by citySQLCalculationsmedium
- WalmartPrice after discountSQLNULL handlingmedium
- InstacartMinutes from order to doorstepSQLPremiumDateshard
- DoorDashMerge sorted delivery timesPythonTwo pointerseasy
- SwiggyRevenue against targetSQLPremiumRunning totalsmedium
- MetaFirst and last position of a userPythonBinary searchmedium
- TargetUnfinished orders over 50SQLLogical operatorseasy
- AmazonLarge orders with customer namesSQLJoinseasy
- StripeCompleted versus other ordersSQLConditional logicmedium
- PhonePeMoney moved by payment typeSQLReshapingmedium
PandoraListening minutes per listenerPandasAggregationseasy- PinterestEach user's top categorySQLPremiumWindow functionshard
- ShopifyRevenue to date per merchantSQLRunning totalsmedium
- AirbnbLongest palindrome in a namePythonStringshard
- FlipkartTop reason per categorySQLPremiumRankingmedium
PagerDutyHours lost by dayPandasReshapinghard- Best BuyCompare with the previous orderSQLWindow functionshard
- SalesforceTop earner per departmentPandasRankingmedium
- WalmartProducts under 50SQLFilteringeasy
- NetflixCompletion rate by content typeSQLConditional logicmedium
- AtlassianResolution time by priorityPandasPremiumNULL handlingmedium
- UberDrivers without ridesPandasJoinsmedium
- ZillowPrice changes month to monthPythonArrayseasy
- AmazonRevenue by categoryPandasAggregationseasy
- RobinhoodBest and worst day per assetPandasWindow functionshard
- DoorDashMost visited locationPythonTuplesmedium
- PhonePeRetries before it workedSQLPremiumWindow functionshard
- TargetCustomers who came backPythonHashingmedium
- WalmartOrders per calendar monthSQLDatesmedium
WayfairWhich products repeat?PythonHashingmedium- PinterestPins by categoryPandasReshapingmedium
- VisaAny duplicate transaction ids?PythonHashingeasy
- MyntraLongest price holdSQLPremiumWindow functionshard
- InstacartFirst item bought twicePythonHashingeasy
- AmazonPrice bandsSQLConditional logiceasy
- AirbnbBooked revenue by cityPandasDatesmedium
- FanDuelLineups above their contest averagePandasWindow functionsmedium
- Best BuyElectronics and accessoriesSQLFilteringeasy
- SwiggyTop partners per citySQLPremiumRankingmedium
- StripeOrder amount with taxSQLCalculationseasy
- EtsyShops per tagPandasStringsmedium
- CoinbaseDaily returnSQLWindow functionsmedium
- TargetOrders per customerSQLAggregationseasy
- BlinkitHow often it ran outSQLWindow functionsmedium
- StripeSplit requests into batchesPythonListseasy
- AmazonFirst unique characterPythonStringseasy
- Best BuyEven-numbered ordersSQLCalculationseasy
- ShopifyPlan changesSQLWindow functionsmedium
- NykaaSpend by channelSQLPremiumReshapingmedium
- SpotifyBack to back repeatsSQLWindow functionsmedium
- DraftKingsPrize ranks with tiesSQLRankingmedium
- Capital OneHigh credit utilizationSQLCalculationsmedium
- GoogleEmployee senioritySQLConditional logicmedium
- ZerodhaBusiest stock per clientSQLRankingmedium
- UberCompleted trips by cityPandasAggregationseasy
- WalmartCounting what is recordedSQLNULL handlingmedium
- UberCompress a status logPythonStringsmedium
- LyftBusiest request hourPythonArrayseasy
- LinkedInHires per yearSQLDateseasy
- AmazonRevenue by statePandasJoinsmedium
- SalesforceAverage sales cycleSQLDatesmedium
- WorkdayEmployees and their managersSQLJoinsmedium
- RobinhoodBest stretch of daysPythonArraysmedium
- ZerodhaThe day the position closedSQLPremiumRunning totalshard
- Best BuyMove zero-sale days to the endPythonListseasy
- AmazonPackages still movingSQLRankingmedium
- RobinhoodMonthly traded valuePandasDatesmedium
- WalmartCustomers outside the US and MexicoSQLFilteringeasy
- NetflixRemove duplicates, keep the orderPythonListseasy
- InstacartItems and aisles per orderPandasAggregationseasy
- PandoraShare of plays cut shortPandasConditional logicmedium
- FlipkartRefunds so farSQLPremiumRunning totalsmedium
- StripeRunning revenue over timeSQLWindow functionshard
- PinterestNormalize hashtagsPythonStringseasy
- AtlassianSubtasks that outlived the parentSQLPremiumJoinsmedium
- TargetCustomers with repeat ordersSQLAggregationsmedium
- AmazonStock statusSQLConditional logiceasy
- DatadogIncidents that overlappedSQLJoinshard
- SwiggyDay over day swingSQLPremiumWindow functionsmedium
PelotonLongest run of consecutive daysPythonHashingmedium- NetflixTwo episodes before landingPythonTwo pointershard
- ShopifyUnbroken runs of monthsSQLWindow functionshard
- EtsyAnagram checkPythonStringseasy
- CoinbaseLongest rising streakSQLWindow functionshard
- UberLow-rated driversSQLAggregationsmedium
- ZillowPrice per square foot by citySQLNULL handlingmedium
- DraftKingsPoints above the contest averageSQLWindow functionsmedium
- AirbnbMirror promo codesPythonStringseasy
- ZillowWhere a new price fitsPythonBinary searchmedium
- TargetClearance candidatesSQLLogical operatorseasy
- WalmartOrders above the averageSQLSubquerieseasy
- SalesforceBalanced bracketsPythonStringsmedium
- AmazonHours between scansSQLWindow functionsmedium
- DoorDashStretches that hit a targetPythonPremiumHashinghard
- StripeThree transactions that cancel outPythonTwo pointershard
- BlinkitEvery stockout windowSQLPremiumWindow functionshard
- AmazonOrders per customer segmentSQLJoinsmedium
- PagerDutyLongest incident per servicePandasRankingmedium
- Best BuyOrders placed in March 2024SQLDateseasy
- SpotifyListening sessionsSQLPremiumWindow functionshard
- ZerodhaNet position gridPandasPremiumReshapinghard
- GoogleFactorialPythonMatheasy
- MetaReactions by post typePandasReshapingmedium
- StripeOrders in a price rangeSQLFilteringeasy
- WalmartInventory valueSQLCalculationseasy
- PhonePeMoney moved so farSQLPremiumRunning totalsmedium
- AtlassianPriority mix per projectSQLReshapingmedium
- AmazonFlatten a category treePythonListsmedium
- TargetActive productsSQLFilteringeasy
- InstacartKth largest orderPythonSortingmedium
- MyntraPrice dropsSQLPremiumWindow functionsmedium
- AmazonPrime vs. standard order valueSQLJoinsmedium
- DatadogMerged outage windowsSQLWindow functionshard
- PinterestGroup anagramsPythonStringsmedium
- WalmartWeekend ordersSQLDatesmedium
- UberSearch a rotated schedulePythonPremiumBinary searchhard
- SwiggyCancellation split by restaurantSQLReshapingmedium
- Best BuyIn-stock electronicsSQLLogical operatorseasy
- StripeDays from signup to first orderSQLDatesmedium
- NetflixSalary rank within departmentSQLWindow functionsmedium
- MastercardCard-testing patternsSQLPremiumAggregationshard
- RobinhoodHoldings in long formatPandasPremiumReshapinghard
- Capital OneInvert team assignmentsPythonDictionariesmedium
- NykaaCheapest channel per campaignSQLRankingmedium
- VisaMonth-over-month spend changeSQLPremiumWindow functionshard
- EtsyVerified rating by shopSQLJoinsmedium
- LyftSurge share by citySQLConditional logiceasy
- AirbnbNights booked per citySQLDatesmedium
- FlipkartDamage share of refundsSQLReshapingmedium
- AmazonSlowest package per facilitySQLRankinghard
- TargetOrders by statusSQLAggregationseasy
- DoorDashSlow deliveries by cuisinePandasDatesmedium