rentalTableData.sql

insert into rental(rental_id, rental_date, inventory_id, customer_id, return_date, staff_id)
values 
(1,'2024-05-24',3,1,'2024-09-26',1),
(2,'2024-05-24',5,2,'2024-12-28',1),
(3,'2024-05-24',1,40,'2024-08-01',1),
(4,'2024-05-24',2,3,'2024-07-03',2),
(5,'2024-05-24',9,22,'2024-06-30',1),
(6,'2024-05-24',2,14,'2024-11-27',1),
(7,'2024-05-24',28,4,'2025-01-29',2),
(8,'2024-05-24',6,5,'2025-01-01',2),
(9,'2024-05-25',10,6,'2024-09-02',1),
(10,'2024-05-25',8,7,'2024-07-11',2),
(11,'2024-05-25',4,10,'2024-09-12',2),
(12,'2024-05-25',7,20,'2024-10-20',2),
(13,'2024-05-21',11,24,'2024-06-27',1),
(14,'2024-05-21',12,25,'2024-07-23',1),
(15,'2024-04-22',13,26,'2024-09-13',1),
(16,'2024-04-24',14,27,'2024-08-16',2),
(17,'2024-03-20',15,28,'2024-08-17',1),
(18,'2024-02-29',30,29,'2024-08-11',2),
(19,'2024-04-27',29,21,'2024-07-30',1),
(20,'2024-04-28',16,11,'2024-09-27',2),
(21,'2024-04-27',25,12,'2024-11-16',2),
(22,'2024-04-23',17,8,'2024-09-16',2),
(23,'2024-05-24',18,13,'2024-08-25',1),
(24,'2024-05-23',19,15,'2024-07-27',1),
(25,'2024-05-22',20,16,'2025-02-27',2),
(26,'2024-05-21',40,9,'2025-01-02',1),
(27,'2024-03-17',32,17,'2024-09-03',2),
(28,'2024-03-18',33,18,'2024-08-16',2),
(29,'2024-05-10',35,19,'2024-12-20',2),
(30,'2024-05-19',37,23,'2024-12-30',1),
(31,'2024-05-18',36,30,'2024-11-30',1),
(32,'2024-05-17',38,31,'2024-10-25',1),
(33,'2024-05-17',34,32,'2024-12-27',1),
(34,'2024-05-16',31,33,'2024-11-29',2),
(35,'2024-05-15',39,34,'2024-09-27',2),
(36,'2024-05-15',21,35,'2024-07-29',1),
(37,'2024-05-14',22,36,'2024-05-29',1),
(38,'2024-05-13',23,37,'2024-11-01',1),
(39,'2024-05-12',24,38,'2024-09-21',2),
(40,'2024-05-11',26,39,'2024-08-27',1);