Restaurants With No Orders
Find all restaurants that have not received any completed orders. Return restaurant_id and restaurant_name, sorted by restaurant_id in ascending order.
Tables: restaurants, orders
SQL practice / DoorDash
Free SQL interview practice
DoorDash SQL interview questions. All free.
3 SQL practice questions in our DoorDash collection, part of our 188-question bank across 23 companies. Write SQL against practice datasets and get checked in your browser. Free, no card or trial.
No account needed to start. Draft SQL stays in this browser; create an account to sync solved history.
1 Easy · 1 Medium · 1 Hard
Independent practice resource. Not affiliated with or endorsed by DoorDash.
Inside the DoorDash set
SQL topics you can practice.
These topics come from the questions in this set. Pick one to open the matching problems.
Aggregation 2 questionsCTEs 2 questionsJoins 2 questionsWindow functions 2 questionsNULL handling 1 question
Weekly Consumer Retention by Cohort
Calculate weekly cohort retention by analyzing customer activity. For each signup week, count the total cohort size, customers active in week 1 (first 7 days after signup), customers active in week 2 (days 8-14 after signup), and the retention rate (week 2 active / week 1 active). Only include completed orders. Return signup_week, cohort_size, week1_active, week2_active, and retention_rate, ordered by signup_week.
Tables: customers, orders
Rolling 30-Day Average Order Value by Merchant
Calculate daily statistics and rolling 30-day average order value for each restaurant. For each restaurant and day, compute the number of completed orders and the average order value. Then calculate a 30-day rolling average of the daily average values. Return restaurant_id, order_date, daily_order_count, daily_avg_value, and rolling_30d_avg_value, ordered by restaurant_id and order_date.
Tables: orders
The bank
DoorDash SQL questions. Start typing SQL.
3 DoorDash problems, each with its own dataset. Click one and you’re in the workspace, free, right in your browser.
How it works
Solve in the browser. Checked instantly.
- 1Pick a problemPractice questions for data science and analytics interviews, each with its own tables, difficulty, and time target.
- 2Write and run SQLA full database engine loads in the tab. No setup, nothing to install — query the practice dataset immediately.
- 3Submit for a verdictPass and move to the next problem. Miss and you unlock the expected output and a reference solution.
Your dataset
restaurants
restaurant_id (INTEGER) · restaurant_name (VARCHAR) · cuisine_type (VARCHAR) · city (VARCHAR)
orders
order_id (INTEGER) · customer_id (INTEGER) · restaurant_id (INTEGER) · order_date (DATE) · order_total (DECIMAL) · status (VARCHAR)
3
DoorDash questions
188
questions in the full bank
$0
free access
Solve one now. Build your solved history.
Start free, no account needed. When you create one, everything you’ve solved comes with you — solved marks, streaks, and concept ratings on your dashboard.
Practice DoorDash SQL freeExplore SQL questions by company.
188 SQL practice questions. 23 companies. Free access to every problem.