Restaurant Order Analysis

Restaurant Orders

SQL Practice

Explore the items table

To better understand the items table by finding the number of rows in the table, the least and most expensive items, and the item prices within each category.

Explore the orders table

To better understand the orders table by finding the date range, the number of items within each order, and the orders with the highest number of items.

Analyze customer behavior

Finaly combine the items and orders tables, find the least and most ordered categories, and dive into the details of the highest spend orders.