Pro90 ProblemsSQL + Python
Food Delivery SQL & Python Interview Questions
Food delivery platforms optimize restaurant performance, courier routing, and order fulfillment at scale. These SQL and Python challenges are modeled after work at DoorDash, Uber Eats, Grubhub, Instacart, Deliveroo, Gopuff, Swiggy, Zomato, Just Eat, HelloFresh, and more. Master preparation time analysis, delivery SLA metrics, customer retention, restaurant ranking, and courier efficiency KPIs.
Companies working in Food Delivery
These practice problems are modeled after the kind of data and analytics challenges teams in this industry typically face.
Company names and logos are trademarks of their respective owners, used here only to describe the kind of data these companies work with. Let's Data Science is not affiliated with, endorsed by, or sponsored by any company shown. Practice problems are original works and are not real interview questions from these companies. Rights & takedowns.
Difficulty Distribution
Easy
16
18% of problems
Medium
31
34% of problems
Hard
39
43% of problems
Expert
4
4% of problems
What You'll Practice
Delivery time analysis
Restaurant performance metrics
Courier efficiency
Order funnel optimization
Customer retention analysis
Cohort analytics
Pricing strategy metrics
Market density analysis
Topics Covered
SQL· 9
aggregationbasic queries filteringcleaning transformdate timejoinsscenario sqlset operationssubqueries cteswindow functions
Python· 12
eda statisticsfeature engineeringpandas aggregationpandas applypandas basicspandas cleaningpandas datetimepandas filteringpandas mergingpandas reshapingpandas scenariopandas window
All Problems90 total
01
Open High-Rated RestaurantsPro
SQLEasy02Vegan Main DishesPro
SQLEasy03Active Car CouriersPro
SQLEasy04Canceled Delivery OrdersPro
SQLEasy05Prime Members With Card PaymentPro
SQLMedium06Orders With Restaurant DetailsPro
SQLEasy07Deliveries With Courier InfoPro
SQLMedium08Order Items With Menu DetailsPro
SQLMedium09Restaurant Reviews With Order ContextPro
SQLMedium10Restaurants Without ReviewsPro
SQLMedium11Delivered Orders With Full ContextPro
SQLHard12Order Volume by Cuisine TypePro
SQLEasy13Total Revenue per RestaurantPro
SQLMedium14Average Delivery Distance by Vehicle TypePro
SQLMedium15Average Review Rating by Cuisine TypePro
SQLMedium16Top 5 Couriers by Delivery CountPro
SQLHard17Restaurants With High Cancellation RatePro
SQLHard18Rank Restaurants by Order VolumePro
SQLMedium19Customer Order Sequence NumberPro
SQLMedium20Daily Revenue Running TotalPro
SQLHard21Highest Rated Delivery per CourierPro
SQLHard22Customer Tip Moving AveragePro
SQLHard23Order Total Change From Prior OrderPro
SQLHard24Delivery Distance Quartile AnalysisPro
SQLHard25Restaurants Above Average RatingPro
SQLMedium26Customers Who Ordered From 3+ Cuisine TypesPro
SQLHard27Latest Order per CustomerPro
SQLHard28Cuisine Revenue With RankPro
SQLHard29Promo Codes With Above-Average Order ValuePro
SQLHard30December 2024 OrdersPro
SQLEasy31Monthly Order Volume TrendPro
SQLMedium32Average Delivery Time by Cuisine TypePro
SQLMedium33Late Deliveries by Hour of DayPro
SQLHard34Orders With Size CategoryPro
SQLEasy35Menu Items With Dietary LabelPro
SQLMedium36Customer Order Activity SummaryPro
SQLHard37Cities With Customers or RestaurantsPro
SQLMedium38Available Items Never OrderedPro
SQLMedium39Restaurant Performance ScorecardPro
SQLHard40Courier Performance ReportPro
SQLHard41Customer Lifetime Value SummaryPro
SQLHard42Promo Code Effectiveness ReportPro
SQLHard43Delivery Cancellation Root Cause AnalysisPro
SQLHard44Payment Processor Performance DashboardPro
SQLHard45Prime vs Regular Customer AnalysisPro
SQLHard46Open Restaurant ProfilesPro
PYTHONEasy47Order Status CountsPro
PYTHONEasy48Cuisine Type DistributionPro
PYTHONEasy49Menu Category Price SummaryPro
PYTHONMedium50Delivered Delivery OrdersPro
PYTHONEasy51Vegan Menu Items Above Price ThresholdPro
PYTHONMedium52High-Tip Canceled OrdersPro
PYTHONMedium53Prime Customer High-Value DeliveriesPro
PYTHONHard54Orders Per RestaurantPro
PYTHONEasy55Total Revenue by Cuisine TypePro
PYTHONMedium56Average Delivery Rating by Vehicle TypePro
PYTHONMedium57Restaurant Order MetricsPro
PYTHONHard58Payment Method Revenue SummaryPro
PYTHONHard59Orders With Customer DetailsPro
PYTHONEasy60Deliveries With Courier InfoPro
PYTHONMedium61Menu Items Without OrdersPro
PYTHONMedium62Order Details With Restaurant and CustomerPro
PYTHONHard63Full Order Item DetailPro
PYTHONHard64Rank Restaurants by Total RevenuePro
PYTHONMedium65Running Total Revenue Per CustomerPro
PYTHONMedium667-Day Moving Average Order ValuePro
PYTHONHard67Daily Revenue ChangePro
PYTHONHard68Order Hour and Day of WeekPro
PYTHONEasy69Delivery Duration MinutesPro
PYTHONMedium70Monthly Order Volume by Fulfillment TypePro
PYTHONHard71Fill Missing Customer Phone NumbersPro
PYTHONEasy72Normalize Order FeesPro
PYTHONMedium73Standardize Payment MethodsPro
PYTHONHard74Pivot Order Counts by Cuisine and Fulfillment TypePro
PYTHONMedium75Pivot Revenue by City and Payment MethodPro
PYTHONHard76Classify Orders by Value TierPro
PYTHONMedium77Delivery Speed ScorePro
PYTHONHard78Tip Percentage and Fee RatioPro
PYTHONMedium79Restaurant Revenue Quartile BucketingPro
PYTHONHard80Time-Based Order FeaturesPro
PYTHONHard81Restaurant Feature MatrixPro
PYTHONExpert82Courier Efficiency FeaturesPro
PYTHONHard83Order Value Descriptive Statistics by Fulfillment TypePro
PYTHONMedium84Tip vs Subtotal Correlation by CuisinePro
PYTHONHard85Anomalous Order Total DetectionPro
PYTHONHard86Restaurant Performance ScorecardPro
PYTHONHard87Customer Lifetime Value ReportPro
PYTHONHard88Courier Delivery DashboardPro
PYTHONExpert89Cuisine Profitability AnalysisPro
PYTHONExpert90End-to-End Order Fulfillment ReportPro
PYTHONExpertReady to practice Food Delivery?
90 SQL and Python challenges built from real food delivery data. Graded instantly in your browser — no setup required.