Imagine you needed to scale the sample restaurants database to accommodate a larger chain. Here are some of the features this new chain will need:
- Constant access to a list of active orders, and the ingredients in them.
- Live inventory reporting.
- Monthly reporting on most frequently used ingredients.
After reviewing the current schema of the sample database, think of at least 3 types of queries that would need to be added or changed to add the features mentioned above. In a 1-2-page paper, explain how these new queries would display the data needed by the larger chain and provide examples of each query.