48 lines
1.6 KiB
Plaintext
48 lines
1.6 KiB
Plaintext
# 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 |
|
|
+-----------------------+
|