111 lines
3.3 KiB
SQL
111 lines
3.3 KiB
SQL
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(4,33,'2014-06-25',8),
|
|
(72,42,'2011-01-04',10),
|
|
(73,11,'2015-07-03',3),
|
|
(8,21,'2019-06-06',16),
|
|
(15,1,'2014-03-28',20),
|
|
(15,31,'2019-02-13',18),
|
|
(71,38,'2012-04-26',17),
|
|
(42,2,'2019-01-22',5),
|
|
(56,32,'2017-12-09',12),
|
|
(19,35,'2013-03-18',13);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(17,18,'2016-11-06',7),
|
|
(4,18,'2018-08-22',1),
|
|
(59,48,'2012-08-06',12),
|
|
(71,28,'2011-02-27',19),
|
|
(8,40,'2016-01-09',17),
|
|
(9,41,'2018-01-14',14),
|
|
(1,9,'2010-07-20',16),
|
|
(43,6,'2012-11-24',7),
|
|
(47,44,'2017-12-15',16),
|
|
(60,23,'2015-06-24',10);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(11,29,'2018-03-05',19),
|
|
(4,33,'2016-12-16',12),
|
|
(95,31,'2019-03-10',6),
|
|
(89,33,'2017-10-25',8),
|
|
(19,13,'2013-06-16',20),
|
|
(78,8,'2016-05-05',8),
|
|
(77,3,'2018-05-01',1),
|
|
(1,34,'2011-03-17',20),
|
|
(84,49,'2010-05-08',13),
|
|
(84,37,'2014-01-16',3);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(89,9,'2010-09-13',5),
|
|
(28,17,'2017-06-15',11),
|
|
(26,37,'2011-01-06',4),
|
|
(8,12,'2013-01-28',12),
|
|
(19,20,'2014-09-13',8),
|
|
(47,14,'2010-11-04',10),
|
|
(36,16,'2017-12-19',16),
|
|
(11,37,'2013-06-26',9),
|
|
(8,45,'2012-10-15',10),
|
|
(94,47,'2015-09-05',17);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(71,8,'2012-08-26',7),
|
|
(94,44,'2012-06-04',13),
|
|
(77,46,'2012-06-11',12),
|
|
(23,8,'2018-05-23',8),
|
|
(58,16,'2013-08-24',6),
|
|
(9,16,'2011-05-10',11),
|
|
(26,14,'2013-02-03',1),
|
|
(43,41,'2017-06-24',10),
|
|
(83,31,'2010-09-13',11),
|
|
(49,18,'2017-09-10',9);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(36,18,'2016-09-17',13),
|
|
(63,14,'2013-04-18',1),
|
|
(36,17,'2010-08-27',6),
|
|
(73,14,'2017-07-06',14),
|
|
(23,33,'2013-07-10',18),
|
|
(74,29,'2019-12-23',13),
|
|
(65,37,'2019-11-07',17),
|
|
(79,34,'2011-07-20',12),
|
|
(72,20,'2011-02-05',11),
|
|
(1,8,'2016-04-17',4);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(47,6,'2018-02-06',18),
|
|
(44,12,'2012-01-04',3),
|
|
(44,32,'2018-12-07',15),
|
|
(1,8,'2019-02-12',17),
|
|
(82,17,'2010-11-10',1),
|
|
(75,9,'2013-03-23',10),
|
|
(52,43,'2019-09-26',17),
|
|
(8,49,'2013-08-24',19),
|
|
(42,43,'2015-10-18',7),
|
|
(95,5,'2012-12-28',13);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(63,21,'2019-08-09',1),
|
|
(17,41,'2010-03-23',15),
|
|
(11,26,'2010-12-21',5),
|
|
(11,26,'2010-02-21',19),
|
|
(52,29,'2014-03-24',4),
|
|
(24,12,'2018-04-18',20),
|
|
(47,25,'2011-11-12',6),
|
|
(90,19,'2017-12-17',8),
|
|
(9,39,'2018-06-24',4),
|
|
(84,31,'2014-07-10',16);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(67,48,'2019-03-05',19),
|
|
(4,50,'2017-07-20',17),
|
|
(60,15,'2019-01-08',10),
|
|
(24,26,'2017-05-05',20),
|
|
(56,35,'2013-01-12',7),
|
|
(95,3,'2012-10-12',15),
|
|
(61,10,'2014-04-12',13),
|
|
(1,47,'2018-09-11',9),
|
|
(19,47,'2018-01-18',10),
|
|
(24,50,'2015-03-07',19);
|
|
INSERT INTO productsale (agentid,productid,saledate,productcount) VALUES
|
|
(27,9,'2012-10-08',19),
|
|
(83,17,'2014-01-08',5),
|
|
(36,26,'2011-10-27',15),
|
|
(21,43,'2012-08-18',7),
|
|
(100,27,'2011-11-01',1),
|
|
(60,48,'2011-12-16',12),
|
|
(23,39,'2013-04-18',5),
|
|
(73,49,'2010-06-09',19),
|
|
(52,22,'2015-02-12',12),
|
|
(23,24,'2012-08-01',1);
|