Sample products and wishlist

create table product (
    id INT,
    product_name VARCHAR(50),
    price_per_unit DECIMAL(5,2)
);
insert into product (id, product_name, price_per_unit) values (1, 'Tofu - Soft', 28.34);
insert into product (id, product_name, price_per_unit) values (2, 'Monkfish - Fresh', 56.83);
insert into product (id, product_name, price_per_unit) values (3, 'Irish Cream - Baileys', 95.24);
insert into product (id, product_name, price_per_unit) values (4, 'Mussels - Frozen', 49.32);
insert into product (id, product_name, price_per_unit) values (5, 'Shrimp - 16/20, Iqf, Shell On', 31.16);
insert into product (id, product_name, price_per_unit) values (6, 'Chicken - Breast, 5 - 7 Oz', 65.55);
insert into product (id, product_name, price_per_unit) values (7, 'Potatoes - Yukon Gold, 80 Ct', 23.18);
insert into product (id, product_name, price_per_unit) values (8, 'Juice - Orange, Concentrate', 17.26);
insert into product (id, product_name, price_per_unit) values (9, 'Wine - Prosecco Valdobienne', 12.49);
insert into product (id, product_name, price_per_unit) values (10, 'Lemon Balm - Fresh', 33.51);
insert into product (id, product_name, price_per_unit) values (11, 'Dr. Pepper - 355ml', 28.01);
insert into product (id, product_name, price_per_unit) values (12, 'Sole - Fillet', 49.85);
insert into product (id, product_name, price_per_unit) values (13, 'Chevere Logs', 61.47);
insert into product (id, product_name, price_per_unit) values (14, 'Carbonated Water - Orange', 42.93);
insert into product (id, product_name, price_per_unit) values (15, 'Bread - Sticks, Thin, Plain', 20.57);
insert into product (id, product_name, price_per_unit) values (16, 'Straw - Regular', 65.74);
insert into product (id, product_name, price_per_unit) values (17, 'Jameson Irish Whiskey', 64.74);
insert into product (id, product_name, price_per_unit) values (18, 'Chef Hat 25cm', 8.58);
insert into product (id, product_name, price_per_unit) values (19, 'Pastry - Choclate Baked', 85.45);
insert into product (id, product_name, price_per_unit) values (20, 'Vinegar - White', 61.2);
insert into product (id, product_name, price_per_unit) values (21, 'Crush - Orange, 355ml', 2.13);
insert into product (id, product_name, price_per_unit) values (22, 'Soup - Campbells Beef Stew', 15.54);
insert into product (id, product_name, price_per_unit) values (23, 'Smoked Tongue', 37.86);
insert into product (id, product_name, price_per_unit) values (24, 'Aspic - Amber', 33.91);
insert into product (id, product_name, price_per_unit) values (25, 'Huck White Towels', 23.29);
insert into product (id, product_name, price_per_unit) values (26, 'Tea - Black Currant', 85.92);
insert into product (id, product_name, price_per_unit) values (27, 'Milk Powder', 62.24);
insert into product (id, product_name, price_per_unit) values (28, 'Stock - Veal, Brown', 37.36);
insert into product (id, product_name, price_per_unit) values (29, 'Cranberries - Dry', 17.05);
insert into product (id, product_name, price_per_unit) values (30, 'Rice Wine - Aji Mirin', 19.04);
insert into product (id, product_name, price_per_unit) values (31, 'Tuna - Fresh', 93.49);
insert into product (id, product_name, price_per_unit) values (32, 'Juice - Ocean Spray Kiwi', 81.42);
insert into product (id, product_name, price_per_unit) values (33, 'Wine - Zonnebloem Pinotage', 42.68);
insert into product (id, product_name, price_per_unit) values (34, 'Carroway Seed', 66.87);
insert into product (id, product_name, price_per_unit) values (35, 'Bagel - Everything Presliced', 65.31);
insert into product (id, product_name, price_per_unit) values (36, 'Ice Cream - Strawberry', 73.52);
insert into product (id, product_name, price_per_unit) values (37, 'Soup V8 Roasted Red Pepper', 70.58);
insert into product (id, product_name, price_per_unit) values (38, 'Ecolab - Hobart Washarm End Cap', 58.59);
insert into product (id, product_name, price_per_unit) values (39, 'Gatorade - Cool Blue Raspberry', 19.36);
insert into product (id, product_name, price_per_unit) values (40, 'Sprouts - Peppercress', 69.19);
insert into product (id, product_name, price_per_unit) values (41, 'Wine - Domaine Boyar Royal', 81.42);
insert into product (id, product_name, price_per_unit) values (42, 'Shrimp - Baby, Cold Water', 86.15);
insert into product (id, product_name, price_per_unit) values (43, 'Island Oasis - Cappucino Mix', 47.62);
insert into product (id, product_name, price_per_unit) values (44, 'Compound - Raspberry', 44.45);
insert into product (id, product_name, price_per_unit) values (45, 'Shark - Loin', 73.39);
insert into product (id, product_name, price_per_unit) values (46, 'Food Colouring - Pink', 14.15);
insert into product (id, product_name, price_per_unit) values (47, 'Clam - Cherrystone', 73.37);
insert into product (id, product_name, price_per_unit) values (48, 'Schnappes - Peach, Walkers', 74.49);
insert into product (id, product_name, price_per_unit) values (49, 'Nantucket Apple Juice', 39.15);
insert into product (id, product_name, price_per_unit) values (50, 'Pastry - Baked Scones - Mini', 13.41);
insert into product (id, product_name, price_per_unit) values (51, 'Carbonated Water - Lemon Lime', 41.48);
insert into product (id, product_name, price_per_unit) values (52, 'Wine - Cotes Du Rhone Parallele', 12.64);
insert into product (id, product_name, price_per_unit) values (53, 'Lettuce - Mini Greens, Whole', 72.55);
insert into product (id, product_name, price_per_unit) values (54, 'Artichoke - Bottom, Canned', 12.19);
insert into product (id, product_name, price_per_unit) values (55, 'Muffin Mix - Blueberry', 30.65);
insert into product (id, product_name, price_per_unit) values (56, 'Oysters - Smoked', 38.92);
insert into product (id, product_name, price_per_unit) values (57, 'Mahi Mahi', 1.59);
insert into product (id, product_name, price_per_unit) values (58, 'Temperature Recording Station', 5.69);
insert into product (id, product_name, price_per_unit) values (59, 'Soup Campbells Split Pea And Ham', 31.02);
insert into product (id, product_name, price_per_unit) values (60, 'Ecolab - Medallion', 89.54);
insert into product (id, product_name, price_per_unit) values (61, 'Red Currants', 85.66);
insert into product (id, product_name, price_per_unit) values (62, 'Cheese - Brie, Cups 125g', 6.41);
insert into product (id, product_name, price_per_unit) values (63, 'Devonshire Cream', 57.31);
insert into product (id, product_name, price_per_unit) values (64, 'Scallop - St. Jaques', 85.71);
insert into product (id, product_name, price_per_unit) values (65, 'Bar Energy Chocchip', 90.22);
insert into product (id, product_name, price_per_unit) values (66, 'Turnip - White, Organic', 21.94);
insert into product (id, product_name, price_per_unit) values (67, 'Wine - White, Gewurtzraminer', 98.87);
insert into product (id, product_name, price_per_unit) values (68, 'Tray - Foam, Square 4 - S', 34.25);
insert into product (id, product_name, price_per_unit) values (69, 'Fennel', 34.99);
insert into product (id, product_name, price_per_unit) values (70, 'Yogurt - French Vanilla', 86.18);
insert into product (id, product_name, price_per_unit) values (71, 'Artichoke - Fresh', 72.33);
insert into product (id, product_name, price_per_unit) values (72, 'Beer - Sleemans Honey Brown', 30.82);
insert into product (id, product_name, price_per_unit) values (73, 'Muffin - Mix - Creme Brule 15l', 74.82);
insert into product (id, product_name, price_per_unit) values (74, 'Scrubbie - Scotchbrite Hand Pad', 52.73);
insert into product (id, product_name, price_per_unit) values (75, 'Wine - Red Oakridge Merlot', 66.06);
insert into product (id, product_name, price_per_unit) values (76, 'Pastry - Key Limepoppy Seed Tea', 81.45);
insert into product (id, product_name, price_per_unit) values (77, 'Marsala - Sperone, Fine, D.o.c.', 56.48);
insert into product (id, product_name, price_per_unit) values (78, 'Bread - Dark Rye, Loaf', 11.17);
insert into product (id, product_name, price_per_unit) values (79, 'Cheese - Victor Et Berthold', 81.79);
insert into product (id, product_name, price_per_unit) values (80, 'Pea - Snow', 20.96);
insert into product (id, product_name, price_per_unit) values (81, 'Veal - Insides, Grains', 30.51);
insert into product (id, product_name, price_per_unit) values (82, 'Clam Nectar', 7.73);
insert into product (id, product_name, price_per_unit) values (83, 'Creme De Menthe Green', 20.88);
insert into product (id, product_name, price_per_unit) values (84, 'Propel Sport Drink', 78.59);
insert into product (id, product_name, price_per_unit) values (85, 'Muffin - Mix - Bran And Maple 15l', 38.34);
insert into product (id, product_name, price_per_unit) values (86, 'Sobe - Berry Energy', 3.81);
insert into product (id, product_name, price_per_unit) values (87, 'Raspberries - Fresh', 49.1);
insert into product (id, product_name, price_per_unit) values (88, 'Chips - Potato Jalapeno', 27.89);
insert into product (id, product_name, price_per_unit) values (89, 'Nut - Almond, Blanched, Sliced', 1.96);
insert into product (id, product_name, price_per_unit) values (90, 'Cranberries - Dry', 9.04);
insert into product (id, product_name, price_per_unit) values (91, 'Artichokes - Jerusalem', 58.71);
insert into product (id, product_name, price_per_unit) values (92, 'Raspberries - Fresh', 67.0);
insert into product (id, product_name, price_per_unit) values (93, 'Beef - Baby, Liver', 69.04);
insert into product (id, product_name, price_per_unit) values (94, 'Lotus Rootlets - Canned', 84.4);
insert into product (id, product_name, price_per_unit) values (95, 'Maple Syrup', 55.65);
insert into product (id, product_name, price_per_unit) values (96, 'Pears - Bosc', 32.34);
insert into product (id, product_name, price_per_unit) values (97, 'Amarula Cream', 56.09);
insert into product (id, product_name, price_per_unit) values (98, 'Sage Ground Wiberg', 63.83);
insert into product (id, product_name, price_per_unit) values (99, 'Wine - Prosecco Valdobiaddene', 67.68);
insert into product (id, product_name, price_per_unit) values (100, 'Wine - White, Gewurtzraminer', 55.29);


create table wishlist (
    wish_list_id INT PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    email VARCHAR(50),
    price_range INT
);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (1, 'Riannon', 'Nuzzetti', '[email protected]', 82);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (2, 'Caresse', 'Onyon', '[email protected]', 75);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (3, 'Lexi', 'Fyndon', '[email protected]', 95);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (4, 'Cybil', 'Rycraft', '[email protected]', 21);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (5, 'Cherry', 'Greir', '[email protected]', 46);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (6, 'Stephannie', 'Ringer', '[email protected]', 26);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (7, 'Trixi', 'Tatlow', '[email protected]', 25);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (8, 'Matilda', 'MacTrustey', '[email protected]', 53);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (9, 'Evaleen', 'Squire', '[email protected]', 20);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (10, 'Noell', 'Purselowe', '[email protected]', 72);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (11, 'Jesse', 'Courteney', '[email protected]', 16);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (12, 'Linn', 'Danzig', '[email protected]', 28);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (13, 'Joyce', 'Gerhardt', '[email protected]', 62);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (14, 'Simonne', 'Maddrah', '[email protected]', 53);
insert into wishlist (wish_list_id, first_name, last_name, email, price_range) values (15, 'Andonis', 'Addams', '[email protected]', 95);