Users sometimes submit the same restaurant review several times in quick succession. For the same user and restaurant, a review posted within 10 minutes (600 seconds, inclusive) of that pair's PREVIOUS review belongs to the same burst (bursts chain: 0, 8 and 16 minutes is one burst). Keep only the latest review of every burst (latest `created_at`; if tied, the higher `review_id`). Return the kept `review_id`, `user_id`, `restaurant_id`, `rating`. Order by `review_id`.
| Column | Type |
|---|---|
| review_id | INTEGER |
| user_id | INTEGER |
| restaurant_id | INTEGER |
| rating | INTEGER |
| created_at | TIMESTAMP |
| review_id | user_id | restaurant_id | rating | created_at |
|---|---|---|---|---|
| 1 | 1 | 10 | 4 | 2026-09-01 18:00:00 |
| 2 | 1 | 10 | 5 | 2026-09-01 18:05:00 |
| 3 | 1 | 10 | 3 | 2026-09-01 20:00:00 |
| 4 | 2 | 10 | 2 | 2026-09-01 18:01:00 |
| 5 | 2 | 11 | 4 | 2026-09-01 18:02:00 |
| 6 | 2 | 11 | 4 | 2026-09-01 18:12:00 |
| 7 | 3 | 11 | 5 | 2026-09-01 19:00:00 |
| review_id | user_id | restaurant_id | rating |
|---|---|---|---|
| 2 | 1 | 10 | 5 |
| 3 | 1 | 10 | 3 |
| 4 | 2 | 10 | 2 |
| 6 | 2 | 11 | 4 |
| 7 | 3 | 11 | 5 |
Solve it in the live editor on this page — run on sample data, then submit against hidden tests.
‹ Delivery SLA by Meal Band · Rolling 7-Day Orders with Missing Days ›
{{ 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.
Company tags show where this type of question is commonly reported in interviews. Questions, data and solutions are written by TechTown.
{{ cur.statement }}
No submissions yet. Press Evaluate to submit your query.
{{ solutionSql }}
{{ out.error }}
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.