Analysis of a quarter's worth of orders of a fictitious restaurant
The data has a quarter's worth of orders from a fictitious restaurant serving international cuisine, including the date and time of each order, the items ordered, and additional details on the type, name and price of the items. The following analyses have been done using MySQL:
- What were the least and most ordered items? What categories were they in?
- Were there certain times that had more or less orders?
- What is the average dish price within each category?
- Which cuisines should we focus on developing more menu items for based on the data?