use [booksdb]
insert into orderdetails(orderid,bookid,quantity,unitprice) values (1,102,1,62.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (2,123,1,95.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (2,2,1,44.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (3,96,1,27.5,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (4,121,1,26.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (4,59,1,108.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (5,221,2,51.75,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (5,64,1,23.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (5,110,3,33.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (6,36,1,80.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (6,198,1,21.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (6,189,2,70.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (7,155,1,38.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (7,192,3,83.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (7,193,1,100.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (8,218,1,116.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (8,156,1,75.99,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (8,169,1,85.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (9,35,1,119.75,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (9,203,1,95.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (10,171,1,117.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (10,159,2,38.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (11,117,1,69.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (11,218,1,116.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (12,44,1,69.25,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (12,182,2,97.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (13,55,1,35.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (14,170,1,84.5,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (15,95,1,91.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (15,134,1,50.5,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (16,206,1,48.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (16,202,1,82.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (17,72,2,68.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (17,140,1,66.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (18,210,1,97.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (19,231,3,60.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (19,100,1,48.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (19,150,1,83.75,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (19,34,2,76.99,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (19,134,1,50.5,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (19,157,1,111.99,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (19,35,1,119.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (20,6,1,49.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (20,173,2,25.75,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (21,39,3,104.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (21,100,2,48.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (21,77,1,117.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (22,100,1,48.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (22,110,1,33.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (22,27,1,90.5); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (23,80,1,39.75); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (23,80,2,39.75,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (24,131,1,77.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (24,53,1,70.25,10); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (25,78,1,45.99); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (26,69,1,88.25); 
insert into orderdetails(orderid,bookid,quantity,unitprice,discount) values (27,6,1,49.25,15); 
insert into orderdetails(orderid,bookid,quantity,unitprice) values (27,221,3,51.75);