Swapped Food IDs
ASKED IN INTERVIEWZomato
Problem Statement
A technical glitch at Zomato swapped the IDs of adjacent food orders. Restore the original order by swapping them back.
Rules:
- Output columns: id, item.
- Swap ID 1 with 2, 3 with 4, and so on.
- If the last ID is odd, do not swap it.
- Results must be sorted by id in ascending order.
Tests your understanding of
Window Functions, Case Logic and Mathematical Operations
Input Tables
orders
| id(INTEGER) | item(VARCHAR) |
|---|---|
| 1 | Paneer Tikka |
| 2 | Butter Chicken |
| 3 | Masala Dosa |
| 4 | Garlic Naan |
| 5 | Gulab Jamun |
| 6 | Lassi |
Expected Output
| id(INTEGER) | item(VARCHAR) |
|---|---|
| 1 | Butter Chicken |
| 2 | Paneer Tikka |
| 3 | Garlic Naan |
| 4 | Masala Dosa |
| 5 | Lassi |
| 6 | Gulab Jamun |
Tags
MediumASKED IN INTERVIEWWindow FunctionsCase LogicMathematical Operations
20-25 min
51%