-- -- -- Session A -- -- --
USE cosc_61;
-- what's our connection number
SELECT CONNECTION_ID();
-- get next order number
SELECT @ordernum:=MAX(orderNumber)+1 FROM orders;
-- add another order
INSERT INTO orders (orderNumber, orderDate, customerNumber)
  VALUES(@ordernum, '2022-11-03', 292);
SELECT COUNT(*) FROM orders;

