Write a query that shows only the three highest (in order) day/shift combinations, based on the total number of Orders recorded. Display the English day name in the result. Here is a sample of that result set:
|
Day Name
|
Shift
|
Order Count
|
|
Tuesday
|
PM2
|
1848
|
|
Saturday
|
PM2
|
1670
|
|
Monday
|
PM2
|
1660
|