text: insert into item (name, rating, price, quantity, color, description) values ('Napkin Colour', 3.6, 408, 58, 'Blue', 'Aliquam quis turpis eget elit sodales scelerisque. Mauris sit amet eros. Suspendisse accumsan tortor quis turpis. Sed ante. Vivamus tortor.');
  insert into item (name, rating, price, quantity, color, description) values ('Wine - Chateau Bonnet', 2.9, 361, 28, 'Yellow', 'Vivamus vel nulla eget eros elementum pellentesque. Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus. Phasellus in felis.');
  insert into item (name, rating, price, quantity, color, description) values ('Maintenance Removal Charge', 3.0, 414, 11, 'Crimson', 'Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam.');
  insert into item (name, rating, price, quantity, color, description) values ('Potatoes - Idaho 80 Count', 1.1, 69, 65, 'Fuscia', 'Vestibulum rutrum rutrum neque. Aenean auctor gravida sem. Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo.');
  insert into item (name, rating, price, quantity, color, description) values ('Lettuce - Frisee', 4.6, 276, 2, 'Orange', 'Etiam justo. Etiam pretium iaculis justo. In hac habitasse platea dictumst. Etiam faucibus cursus urna.');
  insert into item (name, rating, price, quantity, color, description) values ('Wine - Red, Antinori Santa', 4.9, 491, 26, 'Yellow', 'Pellentesque ultrices mattis odio. Donec vitae nisi.');
  insert into item (name, rating, price, quantity, color, description) values ('Halibut - Steaks', 1.6, 455, 41, 'Green', 'Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla.');
  insert into item (name, rating, price, quantity, color, description) values ('Icecream - Dibs', 4.3, 142, 93, 'Mauv', 'Duis ac nibh.');
  insert into item (name, rating, price, quantity, color, description) values ('Yogurt - Banana, 175 Gr', 2.9, 366, 32, 'Red', 'Nunc purus. Phasellus in felis. Donec semper sapien a libero. Nam dui. Proin leo odio, porttitor id, consequat in, consequat ut, nulla. Sed accumsan felis. Ut at dolor quis odio consequat varius. Integer ac leo.');
  insert into item (name, rating, price, quantity, color, description) values ('Pepper - Cayenne', 3.1, 483, 58, 'Violet', 'Sed sagittis. Nam congue, risus semper porta volutpat, quam pede lobortis ligula, sit amet eleifend pede libero quis orci. Nullam molestie nibh in lectus. Pellentesque at nulla. Suspendisse potenti. Cras in purus eu magna vulputate luctus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam vel augue.');
  insert into item (name, rating, price, quantity, color, description) values ('Pepper - Paprika, Hungarian', 2.2, 295, 26, 'Fuscia', 'Cras pellentesque volutpat dui. Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam. Suspendisse potenti.');
  insert into item (name, rating, price, quantity, color, description) values ('Wiberg Cure', 4.2, 114, 81, 'Aquamarine', 'Nam tristique tortor eu pede.');
  insert into item (name, rating, price, quantity, color, description) values ('Fish - Scallops, Cold Smoked', 1.1, 261, 87, 'Puce', 'In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque.');
  insert into item (name, rating, price, quantity, color, description) values ('Cookies - Fortune', 3.3, 287, 99, 'Teal', 'Vivamus vestibulum sagittis sapien. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Etiam vel augue. Vestibulum rutrum rutrum neque. Aenean auctor gravida sem.');
  insert into item (name, rating, price, quantity, color, description) values ('Yukon Jack', 2.0, 487, 25, 'Maroon', 'Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac diam.');
  insert into item (name, rating, price, quantity, color, description) values ('Pie Shells 10', 2.6, 443, 17, 'Pink', 'Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh. In quis justo.');
  insert into item (name, rating, price, quantity, color, description) values ('Pork - Bacon,back Peameal', 5.0, 304, 37, 'Orange', 'Vestibulum rutrum rutrum neque. Aenean auctor gravida sem.');
  insert into item (name, rating, price, quantity, color, description) values ('Noodles - Steamed Chow Mein', 1.8, 178, 14, 'Orange', 'Morbi a ipsum. Integer a nibh. In quis justo. Maecenas rhoncus aliquam lacus.');
  insert into item (name, rating, price, quantity, color, description) values ('Salt - Seasoned', 4.5, 406, 77, 'Khaki', 'Donec ut dolor. Morbi vel lectus in quam fringilla rhoncus. Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis. Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi eu orci. Mauris lacinia sapien quis libero.');
  insert into item (name, rating, price, quantity, color, description) values ('Stock - Beef, White', 1.8, 497, 74, 'Teal', 'Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi eu orci. Mauris lacinia sapien quis libero.');
  insert into item (name, rating, price, quantity, color, description) values ('Pasta - Lasagne, Fresh', 4.4, 433, 15, 'Goldenrod', 'Integer ac neque. Duis bibendum. Morbi non quam nec dui luctus rutrum.');
  insert into item (name, rating, price, quantity, color, description) values ('Flavouring - Orange', 4.2, 285, 75, 'Puce', 'Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl. Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum. Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo.');
  insert into item (name, rating, price, quantity, color, description) values ('Cake - Mini Potato Pancake', 2.7, 349, 28, 'Green', 'Ut tellus. Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi. Cras non velit nec nisi vulputate nonummy. Maecenas tincidunt lacus at velit. Vivamus vel nulla eget eros elementum pellentesque. Quisque porta volutpat erat. Quisque erat eros, viverra eget, congue eget, semper rutrum, nulla. Nunc purus.');
  insert into item (name, rating, price, quantity, color, description) values ('Roe - White Fish', 2.1, 73, 53, 'Puce', 'Suspendisse potenti. In eleifend quam a odio. In hac habitasse platea dictumst. Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat. Curabitur gravida nisi at nibh. In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem. Integer tincidunt ante vel ipsum.');
  insert into item (name, rating, price, quantity, color, description) values ('Energy Drink Red Bull', 3.1, 86, 16, 'Goldenrod', 'Nam congue, risus semper porta volutpat, quam pede lobortis ligula, sit amet eleifend pede libero quis orci. Nullam molestie nibh in lectus. Pellentesque at nulla. Suspendisse potenti.');
  insert into item (name, rating, price, quantity, color, description) values ('Syrup - Monin - Granny Smith', 2.6, 64, 59, 'Mauv', 'Donec quis orci eget orci vehicula condimentum. Curabitur in libero ut massa volutpat convallis.');
  insert into item (name, rating, price, quantity, color, description) values ('Oil - Food, Lacquer Spray', 5.0, 476, 80, 'Fuscia', 'In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem. Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat. Praesent blandit. Nam nulla.');
  insert into item (name, rating, price, quantity, color, description) values ('Plastic Wrap', 2.1, 79, 81, 'Khaki', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl. Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum.');
  insert into item (name, rating, price, quantity, color, description) values ('Beef - Montreal Smoked Brisket', 2.8, 62, 26, 'Indigo', 'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi. Integer ac neque. Duis bibendum. Morbi non quam nec dui luctus rutrum. Nulla tellus. In sagittis dui vel nisl. Duis ac nibh.');
  insert into item (name, rating, price, quantity, color, description) values ('Goat - Whole Cut', 2.6, 393, 5, 'Crimson', 'Nulla neque libero, convallis eget, eleifend luctus, ultricies eu, nibh. Quisque id justo sit amet sapien dignissim vestibulum. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Nulla dapibus dolor vel est. Donec odio justo, sollicitudin ut, suscipit a, feugiat et, eros. Vestibulum ac est lacinia nisi venenatis tristique. Fusce congue, diam id ornare imperdiet, sapien urna pretium nisl, ut volutpat sapien arcu sed augue. Aliquam erat volutpat.');
  insert into item (name, rating, price, quantity, color, description) values ('Napkin - Dinner, White', 2.4, 90, 30, 'Khaki', 'Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh.');
  insert into item (name, rating, price, quantity, color, description) values ('Sprite, Diet - 355ml', 2.8, 176, 15, 'Goldenrod', 'Maecenas leo odio, condimentum id, luctus nec, molestie sed, justo. Pellentesque viverra pede ac diam. Cras pellentesque volutpat dui. Maecenas tristique, est et tempus semper, est quam pharetra magna, ac consequat metus sapien ut nunc. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Mauris viverra diam vitae quam. Suspendisse potenti. Nullam porttitor lacus at turpis.');
  insert into item (name, rating, price, quantity, color, description) values ('Shrimp - 16/20, Peeled Deviened', 3.7, 185, 86, 'Orange', 'Nulla tempus. Vivamus in felis eu sapien cursus vestibulum.');
  insert into item (name, rating, price, quantity, color, description) values ('Fish - Artic Char, Cold Smoked', 1.3, 402, 93, 'Mauv', 'Donec posuere metus vitae ipsum. Aliquam non mauris. Morbi non lectus.');
  insert into item (name, rating, price, quantity, color, description) values ('Monkfish Fresh - Skin Off', 2.9, 342, 66, 'Puce', 'Ut at dolor quis odio consequat varius.');
  insert into item (name, rating, price, quantity, color, description) values ('Tea - Herbal Sweet Dreams', 1.4, 77, 76, 'Red', 'Suspendisse potenti. Nullam porttitor lacus at turpis. Donec posuere metus vitae ipsum. Aliquam non mauris. Morbi non lectus. Aliquam sit amet diam in magna bibendum imperdiet. Nullam orci pede, venenatis non, sodales sed, tincidunt eu, felis. Fusce posuere felis sed lacus. Morbi sem mauris, laoreet ut, rhoncus aliquet, pulvinar sed, nisl. Nunc rhoncus dui vel sem.');
  insert into item (name, rating, price, quantity, color, description) values ('Mackerel Whole Fresh', 1.5, 447, 19, 'Turquoise', 'Nunc rhoncus dui vel sem. Sed sagittis. Nam congue, risus semper porta volutpat, quam pede lobortis ligula, sit amet eleifend pede libero quis orci. Nullam molestie nibh in lectus. Pellentesque at nulla. Suspendisse potenti. Cras in purus eu magna vulputate luctus. Cum sociis natoque penatibus et magnis dis parturient montes, nascetur ridiculus mus. Vivamus vestibulum sagittis sapien.');
  insert into item (name, rating, price, quantity, color, description) values ('Ice Cream - Fudge Bars', 4.9, 267, 65, 'Purple', 'Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi.');
  insert into item (name, rating, price, quantity, color, description) values ('Thermometer Digital', 2.7, 326, 71, 'Yellow', 'Vivamus in felis eu sapien cursus vestibulum. Proin eu mi. Nulla ac enim. In tempor, turpis nec euismod scelerisque, quam turpis adipiscing lorem, vitae mattis nibh ligula nec sem. Duis aliquam convallis nunc. Proin at turpis a pede posuere nonummy. Integer non velit. Donec diam neque, vestibulum eget, vulputate ut, ultrices vel, augue. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec pharetra, magna vestibulum aliquet ultrices, erat tortor sollicitudin mi, sit amet lobortis sapien sapien non mi.');
  insert into item (name, rating, price, quantity, color, description) values ('Pork - Ground', 3.9, 316, 95, 'Turquoise', 'Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin interdum mauris non ligula pellentesque ultrices. Phasellus id sapien in sapien iaculis congue. Vivamus metus arcu, adipiscing molestie, hendrerit at, vulputate vitae, nisl. Aenean lectus. Pellentesque eget nunc. Donec quis orci eget orci vehicula condimentum. Curabitur in libero ut massa volutpat convallis. Morbi odio odio, elementum eu, interdum eu, tincidunt in, leo. Maecenas pulvinar lobortis est.');
  insert into item (name, rating, price, quantity, color, description) values ('Jameson - Irish Whiskey', 3.4, 498, 49, 'Pink', 'Etiam pretium iaculis justo. In hac habitasse platea dictumst. Etiam faucibus cursus urna. Ut tellus. Nulla ut erat id mauris vulputate elementum. Nullam varius. Nulla facilisi. Cras non velit nec nisi vulputate nonummy.');
  insert into item (name, rating, price, quantity, color, description) values ('Longos - Lasagna Veg', 4.1, 374, 1, 'Khaki', 'Morbi non lectus. Aliquam sit amet diam in magna bibendum imperdiet. Nullam orci pede, venenatis non, sodales sed, tincidunt eu, felis.');
  insert into item (name, rating, price, quantity, color, description) values ('Wine - Red, Cooking', 2.1, 97, 79, 'Mauv', 'Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat. Curabitur gravida nisi at nibh. In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem. Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat.');
  insert into item (name, rating, price, quantity, color, description) values ('Octopus - Baby, Cleaned', 3.8, 229, 41, 'Khaki', 'Suspendisse ornare consequat lectus.');
  insert into item (name, rating, price, quantity, color, description) values ('Arctic Char - Fillets', 2.6, 468, 82, 'Mauv', 'Aliquam erat volutpat. In congue. Etiam justo. Etiam pretium iaculis justo. In hac habitasse platea dictumst. Etiam faucibus cursus urna. Ut tellus.');
  insert into item (name, rating, price, quantity, color, description) values ('Wine - Niagara,vqa Reisling', 1.5, 489, 98, 'Maroon', 'Nunc purus. Phasellus in felis. Donec semper sapien a libero. Nam dui. Proin leo odio, porttitor id, consequat in, consequat ut, nulla. Sed accumsan felis. Ut at dolor quis odio consequat varius. Integer ac leo. Pellentesque ultrices mattis odio.');
  insert into item (name, rating, price, quantity, color, description) values ('Mints - Striped Red', 1.5, 354, 63, 'Pink', 'Maecenas ut massa quis augue luctus tincidunt. Nulla mollis molestie lorem. Quisque ut erat. Curabitur gravida nisi at nibh. In hac habitasse platea dictumst. Aliquam augue quam, sollicitudin vitae, consectetuer eget, rutrum at, lorem. Integer tincidunt ante vel ipsum. Praesent blandit lacinia erat. Vestibulum sed magna at nunc commodo placerat. Praesent blandit.');
  insert into item (name, rating, price, quantity, color, description) values ('Beer - Mcauslan Apricot', 2.8, 95, 96, 'Pink', 'Vestibulum sed magna at nunc commodo placerat. Praesent blandit.');
  insert into item (name, rating, price, quantity, color, description) values ('Basil - Pesto Sauce', 2.4, 151, 99, 'Crimson', 'Morbi vel lectus in quam fringilla rhoncus. Mauris enim leo, rhoncus sed, vestibulum sit amet, cursus id, turpis. Integer aliquet, massa id lobortis convallis, tortor risus dapibus augue, vel accumsan tellus nisi eu orci. Mauris lacinia sapien quis libero. Nullam sit amet turpis elementum ligula vehicula consequat. Morbi a ipsum. Integer a nibh. In quis justo.');
  insert into item (name, rating, price, quantity, color, description) values ('Flower - Carnations', 4.8, 231, 80, 'Fuscia', 'Vestibulum rutrum rutrum neque. Aenean auctor gravida sem. Praesent id massa id nisl venenatis lacinia. Aenean sit amet justo. Morbi ut odio. Cras mi pede, malesuada in, imperdiet et, commodo vulputate, justo. In blandit ultrices enim. Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Proin interdum mauris non ligula pellentesque ultrices.');
  
  insert into orders (id, purchase_amt, customer_id, location) values (1, 217.43, 5008, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (2, 50.79, 5016, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (3, 82.74, 5009, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (4, 474.84, 5019, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (5, 111.79, 5025, 'Iceland');
  insert into orders (id, purchase_amt, customer_id, location) values (6, 54.96, 5009, 'Luxembourg');
  insert into orders (id, purchase_amt, customer_id, location) values (7, 159.69, 5010, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (8, 168.94, 5017, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (9, 275.77, 5002, 'Luxembourg');
  insert into orders (id, purchase_amt, customer_id, location) values (10, 499.25, 5007, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (11, 317.29, 5006, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (12, 136.25, 5008, 'Luxembourg');
  insert into orders (id, purchase_amt, customer_id, location) values (13, 411.01, 5022, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (14, 176.53, 5014, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (15, 211.17, 5008, 'Australia');
  insert into orders (id, purchase_amt, customer_id, location) values (16, 175.79, 5018, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (17, 287.8, 5024, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (18, 252.21, 5006, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (19, 254.69, 5017, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (20, 208.04, 5013, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (21, 458.88, 5022, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (22, 99.27, 5023, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (23, 138.14, 5016, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (24, 284.61, 5018, 'Germany');
  insert into orders (id, purchase_amt, customer_id, location) values (25, 496.02, 5024, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (26, 471.35, 5012, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (27, 119.36, 5012, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (28, 103.62, 5010, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (29, 385.97, 5005, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (30, 359.58, 5001, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (31, 406.1, 5012, 'Australia');
  insert into orders (id, purchase_amt, customer_id, location) values (32, 373.62, 5002, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (33, 152.94, 5021, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (34, 390.88, 5001, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (35, 466.24, 5016, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (36, 116.43, 5007, 'Switzerland');
  insert into orders (id, purchase_amt, customer_id, location) values (37, 121.01, 5018, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (38, 395.29, 5007, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (39, 87.64, 5019, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (40, 499.02, 5012, 'Iceland');
  insert into orders (id, purchase_amt, customer_id, location) values (41, 486.86, 5025, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (42, 177.49, 5001, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (43, 326.84, 5005, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (44, 55.37, 5002, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (45, 499.34, 5002, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (46, 442.48, 5024, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (47, 64.04, 5013, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (48, 484.2, 5001, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (49, 359.5, 5005, 'France');
  insert into orders (id, purchase_amt, customer_id, location) values (50, 115.56, 5010, 'France');
  