logo

Back to questions

Swapped Food Delivery Zomato SQL Interview Question

Swapped Food Delivery

Zomato SQL Interview Question

Zomato is a leading online food delivery service that connects users with various restaurants and cuisines, allowing them to browse menus, place orders, and get meals delivered to their doorsteps.

Recently, Zomato encountered an issue with their delivery system. Due to an error in the delivery driver instructions, each item's order was swapped with the item in the subsequent row. As a data analyst, you're asked to correct this swapping error and return the proper pairing of order ID and item.

If the last item has an odd order ID, it should remain as the last item in the corrected data. For example, if the last item is Order ID 7 Tandoori Chicken, then it should remain as Order ID 7 in the corrected data.

In the results, return the correct pairs of order IDs and items.

Schema:

column_nametypedescription
order_idintegerThe ID of each Zomato order.
itemstringThe name of the food item in each order.

Example Input:

Here's a sample of the initial incorrect data:

order_iditem
1Chow Mein
2Pizza
3Pad Thai
4Butter Chicken
5Eggrolls
6Burger
7Tandoori Chicken

Example Output:

The corrected data should look like this:

corrected_order_iditem
1Pizza
2Chow Mein
3Butter Chicken
4Pad Thai
5Burger
6Eggrolls
7Tandoori Chicken

Order ID 1 is now associated with Pizza and Order ID 2 is paired with Chow Mein. This adjustment ensures that each order is correctly aligned with its respective item, addressing the initial swapping error.

Order ID 7 remains unchanged and is still associated with Tandoori Chicken. This preserves the order sequence ensuring that the last odd order ID remains unaltered.

The dataset you are querying against may have different input & output - this is just an example!

Difficulty

Medium

PostgreSQL 14