1. Generate a report showing items sold by category for the previous day.

2. What percent of the total revenue is generated by delivery charges?

3. What are the most and least popular items by category? Use number of items sold as a metric.

4. What category generates the most revenue?

5. Select any two or more items from your inventory and suggest two related items for the customer to buy based on the buying patterns of the originally selected items.

Project grading (Dr. Mundur reserves the prerogative to change this if the need arises)

Design                     30%
Implementation      40%
Test Queries           20%
Demo                      10% (all group members must be present and explain
                                           their role/contribution in the project's success/failure)