chapter9_orderdetails.sql

sql的原代码可以供学习sql的人提供好的学习材料

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (10,7,1,'2006-07-30');

INSERT INTO OrderItems(OrderId,FilmId) Values (10,4);
INSERT INTO OrderItems(OrderId,FilmId) Values (10,8);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (11,4,1,'2006-08-06');

INSERT INTO OrderItems(OrderId,FilmId) Values (11,13);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (12,6,1, '2006-08-18');

INSERT INTO OrderItems(OrderId,FilmId) Values (12,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (12,8);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (13,4,1,'2006-09-29');

INSERT INTO OrderItems(OrderId,FilmId) Values (13,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (13,9);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (14,11,1,'2006-09-30');

INSERT INTO OrderItems(OrderId,FilmId) Values (14,8);



INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (15,15,1, '2006-10-01');

INSERT INTO OrderItems(OrderId,FilmId) Values (15,11);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (16,14,1,'2006-10-01');

INSERT INTO OrderItems(OrderId,FilmId) Values (16,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (16,8);
INSERT INTO OrderItems(OrderId,FilmId) Values (16,15);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (17,9, 1,'2006-11-23');

INSERT INTO OrderItems(OrderId,FilmId) Values (17,4);



INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (18,6,1, '2006-11-27');

INSERT INTO OrderItems(OrderId,FilmId) Values (18,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (18,8);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (19,9,1,'2006-11-29');

INSERT INTO OrderItems(OrderId,FilmId) Values (19,13);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (20,4,1,'2006-12-02');

INSERT INTO OrderItems(OrderId,FilmId) Values (20,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (20,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (20,13);
INSERT INTO OrderItems(OrderId,FilmId) Values (20,15);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (21,9,1, '2006-12-12');

INSERT INTO OrderItems(OrderId,FilmId) Values (21,11);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (22,8,1,'2006-12-19');

INSERT INTO OrderItems(OrderId,FilmId) Values (22,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (22,15);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (23,9,1,'2007-01-01');

INSERT INTO OrderItems(OrderId,FilmId) Values (23,2);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (24,6,1, '2007-01-09');

INSERT INTO OrderItems(OrderId,FilmId) Values (24,15);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (25,7, 1,'2007-01-13');

INSERT INTO OrderItems(OrderId,FilmId) Values (25,8);

--


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (1,7,2,'2006-10-23');

INSERT INTO OrderItems(OrderId,FilmId) Values (1,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (1,15);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (2,4,2,'2006-10-30');

INSERT INTO OrderItems(OrderId,FilmId) Values (2,4);
INSERT INTO OrderItems(OrderId,FilmId) Values (2,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (2,13);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (3,9,2, '2006-10-11');

INSERT INTO OrderItems(OrderId,FilmId) Values (3,8);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (4,7,2,'2006-11-12');

INSERT INTO OrderItems(OrderId,FilmId) Values (4,11);



INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (5,7, 2,'2006-12-02');

INSERT INTO OrderItems(OrderId,FilmId) Values (5,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (5,8);
INSERT INTO OrderItems(OrderId,FilmId) Values (5,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (5,11);
INSERT INTO OrderItems(OrderId,FilmId) Values (5,2);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (6,10,2, '2006-12-11');

INSERT INTO OrderItems(OrderId,FilmId) Values (6,8);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (7,4,2,'2006-10-23');

INSERT INTO OrderItems(OrderId,FilmId) Values (7,6);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (8,4,2,'2006-10-30');

INSERT INTO OrderItems(OrderId,FilmId) Values (8,13);
INSERT INTO OrderItems(OrderId,FilmId) Values (8,6);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (9,10,2, '2006-10-11');

INSERT INTO OrderItems(OrderId,FilmId) Values (9,13);
INSERT INTO OrderItems(OrderId,FilmId) Values (9,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (9,4);


-- 



INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (26,11,3, '2006-11-09');

INSERT INTO OrderItems(OrderId,FilmId) Values (26,6);
INSERT INTO OrderItems(OrderId,FilmId) Values (26,15);
INSERT INTO OrderItems(OrderId,FilmId) Values (26,11);
INSERT INTO OrderItems(OrderId,FilmId) Values (26,4);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (27,13,3,'2006-11-19');

INSERT INTO OrderItems(OrderId,FilmId) Values (27,6);
INSERT INTO OrderItems(OrderId,FilmId) Values (27,15);
INSERT INTO OrderItems(OrderId,FilmId) Values (27,11);
INSERT INTO OrderItems(OrderId,FilmId) Values (27,4);
INSERT INTO OrderItems(OrderId,FilmId) Values (27,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (27,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (27,12);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (28,4,3,'2006-12-12');


INSERT INTO OrderItems(OrderId,FilmId) Values (28,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (28,4);
INSERT INTO OrderItems(OrderId,FilmId) Values (28,15);
INSERT INTO OrderItems(OrderId,FilmId) Values (28,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (28,11);
INSERT INTO OrderItems(OrderId,FilmId) Values (28,13);



INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (29,9,3, '2006-12-20');

INSERT INTO OrderItems(OrderId,FilmId) Values (29,13);
INSERT INTO OrderItems(OrderId,FilmId) Values (29,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (29,11);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (30,12,3,'2006-12-21');


INSERT INTO OrderItems(OrderId,FilmId) Values (30,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,4);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,6);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,8);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,9);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,11);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,12);
INSERT INTO OrderItems(OrderId,FilmId) Values (30,13);


INSERT INTO OrderItems(OrderId,FilmId) Values (30,15);


INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (31,1,3,'2007-01-14');

INSERT INTO OrderItems(OrderId,FilmId) Values (31,2);
INSERT INTO OrderItems(OrderId,FilmId) Values (31,15);
INSERT INTO OrderItems(OrderId,FilmId) Values (31,11);
INSERT INTO OrderItems(OrderId,FilmId) Values (31,4);

INSERT INTO Orders(OrderId, MemberId, SalesPersonId, OrderDate)
VALUES (32,5,3, '2007-01-21');

INSERT INTO OrderItems(OrderId,FilmId) Values (32,6);
INSERT INTO OrderItems(OrderId,FilmId) Values (32,2);