# Task 1
> delimiter $
> source ./get_max_quantity.sql
> delimiter ;
> call GetMaxQuantity();
+--------------------+
| MaxQuantityInOrder |
+--------------------+
| 15                 |
+--------------------+

# Task 2
> source ./get_order_detail.sql
> set @customerID = 1
> execute GetOrderDetail using @customerID
+---------+----------+-------+
| OrderID | Quantity | Cost  |
+---------+----------+-------+
| 4       | 3        | 29.00 |
+---------+----------+-------+

# Task 3
> delimiter $
> source ./cancel_order.sql
> delimiter ;
> call CancelOrder(2)
+----------------------+
| Confirmation         |
+----------------------+
| Order 2 is cancelled |
+----------------------+
> select * from `Orders`
+---------+---------------------+---------------------+------------+-----------+
| OrderID | Started             | Finished            | BillAmount | BookingID |
+---------+---------------------+---------------------+------------+-----------+
| 1       | 2024-11-14 18:05:00 | 2023-10-01 19:25:00 | 82.50      | 1         |
| 3       | 2024-11-14 19:10:00 | 2023-10-03 20:30:00 | 31.00      | 3         |
| 4       | 2024-11-14 19:35:00 | 2023-10-04 20:50:00 | 29.00      | 4         |
| 5       | 2024-11-14 19:40:00 | 2023-10-05 20:55:00 | 20.00      | 5         |
| 6       | 2024-11-14 19:40:00 | 2023-10-06 20:45:00 | 150.50     | 6         |
+---------+---------------------+---------------------+------------+-----------+
> call CancelOrder(2)
+-----------------------+
| Confirmation          |
+-----------------------+
| Order 2 doesn't exist |
+-----------------------+
