SQL Projects

Project 1 - Restaurant Order Analysis

In my SQL project, I analyzed the items table by determining the number of rows, identifying the least and most expensive items, and examining the item prices within each category.

Next, I analyzed the orders table by identifying the date range, counting the number of items in each order, and identifying the orders with the highest number of items.

Finally, I combined the items and orders tables to identify the least and most ordered categories and explored the details of the highest spending orders.

Interested? Let’s get in touch.