Message on Whatsapp 8879355057 for DSA(OA + Interview) + Fullstack Dev Training + 1-1 Personalized Mentoring to get 10+LPA Job
1 like 0 dislike
798 views
in Interview-Experiences by Expert (35,210 points)
edited by | 798 views

1 Answer

0 like 0 dislike
Kitchen View

 

A restaurant ordering system accepts food orders one item at a time. Each item entered is for a specific person sitting at a particular table.
The kitchen is not concerned with which person ordered which item. They just need to know what menu items have been ordered for each table.
Write a program that will read a list of individual orders and "pivot" that set into a display of food items for each table in the diner. The total number of each item per table will be displayed on a column for that food item.
For example, the orders:
Sarah,7,Green Salad
Sarah,7,Cappuccino
Michael,2,Club Sandwich
Marcus,5,Sparkling Water

 

Would be displayed for the kitchen as:
Table,Cappuccino,Club Sandwich,Green Salad,Sparkling Water
2,0,1,0,0
5,0,0,0,1
7,1,0,1,0

 

Note that the menu items are listed in alphabetical order across the overall list.
Input:
A comma-delimited list of names, table numbers, and menu items.
Output:
A comma-delimited list of table numbers and item counts with a header row as the first line. The first column name is "Table".
by Expert (35,210 points)