Pizza Place Sales

### A year's worth of sales from a fictitious pizza place, including the date and time of each order and the pizzas served, with additional details on the type, size, quantity, price, and ingredients.

| Table| Field |Description
| orders| order_id |Unique identifier for each order placed by a table
| | |
| orders | date |Date the order was placed (entered into the system prior to cooking & serving)
| orders | time |Time the order was placed (entered into the system prior to cooking & serving)
| order_details| order_details_id |Unique identifier for each pizza placed within each order (pizzas of the same type and size are kept in the same row, and the quantity increases)
| order_details| order_id |Foreign key that ties the details in each order to the order itself
| order_details| pizza_id |Foreign key that ties the pizza ordered to its details, like size and price
| order_details|quantity |Quantity ordered for each pizza of the same type and size
| pizzas| pizza_id |Unique identifier for each pizza (constituted by its type and size)
| pizzas| pizza_type_id |Foreign key that ties each pizza to its broader pizza type
| pizzas| size |Size of the pizza (Small, Medium, Large, X Large, or XX Large)
| pizzas| price |Price of the pizza in USD
| pizza_types| pizza_type_id |Unique identifier for each pizza type
| pizza_types|name |Name of the pizza as shown in the menu
| pizza_types| category |Category that the pizza fall under in the menu (Classic, Chicken, Supreme, or Veggie)
| pizza_types|ingredients |Comma-delimited ingredients used in the pizza as shown in the menu (they all include Mozzarella Cheese, even if not specified; and they all include Tomato Sauce, unless another sauce is specified)

### 一年内虚构披萨店的销售数据，包括每笔订单的日期和时间以及所提供的披萨，并附带类型、尺寸、数量、价格和成分的详细信息。

| 表格 | 字段 | 描述
|------|------------|------------
| orders | order_id | 每张桌子下单的每笔订单的唯一标识符
| orders | date | 下单日期（在烹饪及服务之前输入系统）
| orders | time | 下单时间（在烹饪及服务之前输入系统）
| order_details | order_details_id | 每张订单内每款披萨的唯一标识符（同类型和尺寸的披萨保持在同一行，数量增加）
| order_details | order_id | 外键，将每笔订单的详细信息与订单本身关联
| order_details | pizza_id | 外键，将订购的披萨与其详细信息（如尺寸和价格）关联
| order_details | quantity | 每款同类型和尺寸披萨的订购数量
| pizzas | pizza_id | 每款披萨的唯一标识符（由其类型和尺寸构成）
| pizzas | pizza_type_id | 外键，将每款披萨与其更广泛的披萨类型关联
| pizzas | size | 披萨尺寸（小型、中型、大型、超大型或XX大型）
| pizzas | price | 披萨的价格，单位为美元
| pizza_types | pizza_type_id | 每款披萨类型的唯一标识符
| pizza_types | name | 在菜单上显示的披萨名称
| pizza_types | category | 披萨所属的菜单类别（经典、鸡肉、至尊或素食）
| pizza_types | ingredients | 菜单上显示的披萨所用成分（它们都包含马苏里拉奶酪，即使未指定；并且它们都包含番茄酱，除非指定了其他酱料）