Restaurants Inactive in October

SQL practice question · Medium · Joins · Zomato

Find restaurants with NO orders in the 30-day period 2026-10-02 to 2026-10-31 (inclusive). Orders after 2026-10-31 do not make a restaurant active. Return `restaurant_id`, `name`, `last_order_date` = the latest order on or before 2026-10-31 (NULL if none). Order by `restaurant_id`.

Table: restaurants

Schema of restaurants
Column	Type
restaurant_id	INTEGER
name	TEXT
city	TEXT

Schema of restaurants

Column

Type

restaurant_id

INTEGER

name

TEXT

city

TEXT

Sample rows of restaurants
restaurant_id	name	city
1	Spice Route	Jaipur
2	Dosa Hut	Jaipur
3	Momo Point	Delhi
4	Biryani Bay	Delhi
5	Paratha Lane	Jaipur

Sample rows of restaurants

restaurant_id

name

city

Spice Route

Jaipur

Dosa Hut

Jaipur

Momo Point

Delhi

Biryani Bay

Delhi

Paratha Lane

Jaipur

Table: food_orders

Schema of food_orders
Column	Type
order_id	INTEGER
restaurant_id	INTEGER
order_date	DATE

Schema of food_orders

Column

Type

order_id

INTEGER

restaurant_id

INTEGER

order_date

DATE

Sample rows of food_orders
order_id	restaurant_id	order_date
1	1	2026-10-15
2	1	2026-09-10
3	2	2026-09-25
4	3	2026-10-31
5	2	2026-08-01
6	5	2026-10-02

Sample rows of food_orders

order_id

restaurant_id

order_date

2026-10-15

2026-09-10

2026-09-25

2026-10-31

2026-08-01

2026-10-02

Expected output on the sample data
restaurant_id	name	last_order_date
2	Dosa Hut	2026-09-25
4	Biryani Bay	NULL

Expected output on the sample data

restaurant_id

name

last_order_date

Dosa Hut

2026-09-25

Biryani Bay

NULL

Solve it in the live editor on this page — run on sample data, then submit against hidden tests.

Tech Town

Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Question Asked in Interview Blog

SQL Interview Practice

Company-wise SQL questions

{{ totalCount }} questions in the style asked at Amazon, Microsoft, Google, Meta, Flipkart and more — {{ hardPct }}% Hard. Write SQL in a real database engine in your browser, run it on sample data, then evaluate against hidden tests.

🏆 Weekly SQL Contest

Questions

Companies

Solved

Bookmark Question Companies Difficulty Category Status

{{ r.n }} - {{ r.title }}

No questions match these filters.

Showing {{ rangeLabel }} of {{ filteredCount }}

Company tags show where this type of question is commonly reported in interviews. Questions, data and solutions are written by TechTown.

Daily challenge

{{ daily.title }} · {{ daily.difficulty }} Solve now

New question every day at midnight IST.

Your Progress

Reset all SQL practice progress{{ resetScope }}? This can't be undone.

{{ p.label }} ({{ p.pct }}%){{ p.solved }}/{{ p.total }}

Points: {{ myPoints }} · Easy 10 · Medium 20 · Hard 40

🔥 Longest streak: {{ streak.longest }}Current streak: {{ streak.current }}

Leaderboard (rolling 100 days)

Loading…

{{ u.rank }} {{ u.name }}{{ u.points }} pts

← All questions

{{ cur.n }} - {{ cur.title }}

🏆 Contest {{ contestWeek }}

Embed this questionPaste on a blog, course page or LMS. Free to use — educator guide

{{ embedCode }}

Table: {{ tb.name }}

ColumnType

Expected output on the sample data:

No submissions yet. Press Evaluate to submit your query.

The solution unlocks after you solve this question or after 3 evaluations that didn't pass ({{ failCount }}/3 so far). Trying first is the fastest way to learn.

{{ solutionSql }}

SQL dialect ⏱ {{ timerLabel }}

{{ fnHelpTitle }}
{{ fnHelpText }}

Writing {{ dialectName }} · Ctrl/Cmd + Enter runs the query · Tab indents · your code is saved automatically

Output

{{ out.error }}

Expected (sample data)

Your output (sample data)

Run your query to see the result here.

🔒

To Track Your Progress, Log In / Sign Up

You have solved your 3 free questions — nice work! Log in (free) to unlock all 150 questions, keep your streak and appear on the leaderboard.