exam.sql

drop table if exists supermarket; create table supermarket(Item varchar(1000), Price_at_WinCo float8, Price_at_WalMart float8);
insert into supermarket values ('Bananas (lb)', 0.42, 0.56);
insert into supermarket values ('Red Onions (lb)', 0.58, 0.98);
insert into supermarket values ('Mini Peeled Carrots (1 lb bag)', 0.98, 1.48);
insert into supermarket values ('Roma Tomatoes (lb)', 0.98, 2.67);
insert into supermarket values ('Deli Tater Wedges (lb)', 1.18, 1.78);
insert into supermarket values ('Beef Cube Steak (lb)', 3.83, 4.118);
insert into supermarket values ('Beef Top Round London Broil (lb) ', 3.48, 4.12);
insert into supermarket values ('Pillsbury Devils Food Cake Mix (18.25 oz) ', 0.88, 0.88);
insert into supermarket values ('Lipton Rice and Sauce Mix (5.6 oz) ', 0.88, 1.06);
insert into supermarket values ('Sierra Nevada Pale Ale (12 12 oz bottles) ', 12.68, 12.84);
insert into supermarket values ('GM Cheerios Oat Clusters (11.3 oz) ', 1.98, 2.74);
insert into supermarket values ('Charmin Bathroom Tissue (12 roll)', 5.98, 7.48);
insert into supermarket values ('Bumble Bee Pink Salmon (14.75 oz) ', 1.58, 1.98);
insert into supermarket values ('Pace Thick & Chunky Salsa, Mild (24 oz) ', 2.28, 2.78);
insert into supermarket values ('Nalley Chili, Regular w/Beans (15 oz) ', 0.78, 0.78);
insert into supermarket values ('Challenge Butter (lb quarters)', 2.18, 2.58);
insert into supermarket values ('Kraft American Singles (12 oz)', 2.27, 2.27);
insert into supermarket values ('Yuban Coffee FAC (36 oz)', 5.98, 7.56);
insert into supermarket values ('TotinoÕs Pizza Rolls, Pepperoni (19.8 oz) ', 2.38, 2.42);
insert into supermarket values ('Rosarita Refried Beans, Original (16 oz) ', 0.68, 0.73);
insert into supermarket values ('Barilla Spaghetti (16 oz)', 0.78, 1.23);
insert into supermarket values ('Sun-Maid Mini Raisins (14 .5 oz)', 1.18, 1.36);
insert into supermarket values ('Jif Peanut Butter, Creamy (28 oz)', 2.54, 2.72);
insert into supermarket values ('Dole Fruit Bowl, Mixed Fruit (4 4 oz) ', 1.68, 1.98);
insert into supermarket values ('Progresso Chicken Noodle Soup (19 oz) ', 1.28, 1.38);
insert into supermarket values ('Precious Mozzarella Ball, Part Skim (16 oz) ', 3.28, 4.23);
insert into supermarket values ('Mrs. Cubbison Seasoned Croutons (6 oz) ', 0.88, 1.12);
insert into supermarket values ('Kelloggs Raisin Bran (20 oz)', 1.98, 2.50);
insert into supermarket values ('Campbells Soup at Hand, Cream of Tomato', 1.18, 1.26);

drop table if exists tobacco_alcoohol_consumption; create table tobacco_alcoohol_consumption(Region varchar(1000), Alcohol_Percentage float8, Tobacco_Percentage float8);
insert into tobacco_alcoohol_consumption values ('North', 6.47, 4.03);
insert into tobacco_alcoohol_consumption values ('Yorkshire', 6.13, 3.76);
insert into tobacco_alcoohol_consumption values ('Northeast', 6.19, 3.77);
insert into tobacco_alcoohol_consumption values ('East Midlands', 4.89, 3.34);
insert into tobacco_alcoohol_consumption values ('West Midlands', 5.63, 3.47);
insert into tobacco_alcoohol_consumption values ('East Anglia', 4.52, 2.92);
insert into tobacco_alcoohol_consumption values ('Southeast', 5.89, 3.2);
insert into tobacco_alcoohol_consumption values ('Southwest', 4.79, 2.71);
insert into tobacco_alcoohol_consumption values ('Wales', 5.27, 3.53);
insert into tobacco_alcoohol_consumption values ('Scotland', 6.08, 4.51);
insert into tobacco_alcoohol_consumption values ('Northern Ireland', 4.02, 4.56);

drop table if exists rent_price; create table rent_price(City varchar(1000), Cost_of_Living float8, Rent float8);
insert into rent_price values ('Hamilton, Bermuda', 145.43, 110.87);
insert into rent_price values ('Zurich, Switzerland', 141.25, 66.14);
insert into rent_price values ('Geneva, Switzerland', 134.83, 71.7);
insert into rent_price values ('Basel, Switzerland', 130.68, 49.68);
insert into rent_price values ('Bern, Switzerland', 128.03, 43.57);
insert into rent_price values ('Lausanne, Switzerland', 127.5, 52.32);
insert into rent_price values ('Reykjavik, Iceland', 123.78, 57.25);
insert into rent_price values ('Stavanger, Norway', 118.61, 39.83);
insert into rent_price values ('Lugano, Switzerland', 118.24, 52.91);
insert into rent_price values ('Oslo, Norway', 117.23, 49.28);
insert into rent_price values ('Trondheim, Norway', 114.22, 42.39);
insert into rent_price values ('Bergen, Norway', 112.31, 40.3);
insert into rent_price values ('Kyoto, Japan', 100.33, 24.58);
insert into rent_price values ('New York, NY, United States', 100, 100);
insert into rent_price values ('Nassau, Bahamas', 99.73, 40.45);
insert into rent_price values ('San Francisco, CA, United States', 97.84, 115.36);
insert into rent_price values ('Copenhagen, Denmark', 97.62, 50.66);
insert into rent_price values ('Luxembourg, Luxembourg', 95.37, 61.59);
insert into rent_price values ('Anchorage, AK, United States', 94.99, 40.12);
insert into rent_price values ('Honolulu, HI, United States', 94.15, 62.82);
insert into rent_price values ('Tokyo, Japan', 93.81, 37.07);
insert into rent_price values ('Brooklyn, NY, United States', 93.79, 76.24);
insert into rent_price values ('Paris, France', 92.87, 50.3);
insert into rent_price values ('Limerick, Ireland', 92.73, 27.71);
insert into rent_price values ('Rockville, MD, United States', 92.66, 64);
insert into rent_price values ('Bloomington, IN, United States', 92.14, 33.64);
insert into rent_price values ('Washington, DC, United States', 91.94, 73.3);
insert into rent_price values ('Arhus, Denmark', 91.9, 34.82);
insert into rent_price values ('Singapore, Singapore', 91.4, 71.89);

drop table if exists restaurant_price; create table restaurant_price(City varchar(1000), Living_Cost float8, Restaurant_Prices float8);
insert into restaurant_price values ('Hamilton, Bermuda', 145.43, 158.75);
insert into restaurant_price values ('Zurich, Switzerland', 141.25, 135.76);
insert into restaurant_price values ('Geneva, Switzerland', 134.83, 129.74);
insert into restaurant_price values ('Basel, Switzerland', 130.68, 127.22);
insert into restaurant_price values ('Bern, Switzerland', 128.03, 119.48);
insert into restaurant_price values ('Lausanne, Switzerland', 127.5, 132.12);
insert into restaurant_price values ('Reykjavik, Iceland', 123.78, 133.19);
insert into restaurant_price values ('Stavanger, Norway', 118.61, 143.54);
insert into restaurant_price values ('Lugano, Switzerland', 118.24, 122.3);
insert into restaurant_price values ('Oslo, Norway', 117.23, 124.09);
insert into restaurant_price values ('Trondheim, Norway', 114.22, 134.76);
insert into restaurant_price values ('Bergen, Norway', 112.31, 119.61);
insert into restaurant_price values ('Kyoto, Japan', 100.33, 54.59);
insert into restaurant_price values ('New York, NY, United States', 100, 100);
insert into restaurant_price values ('Nassau, Bahamas', 99.73, 104.17);
insert into restaurant_price values ('San Francisco, CA, United States', 97.84, 91.06);
insert into restaurant_price values ('Copenhagen, Denmark', 97.62, 121.23);
insert into restaurant_price values ('Luxembourg, Luxembourg', 95.37, 109.61);
insert into restaurant_price values ('Anchorage, AK, United States', 94.99, 84.55);
insert into restaurant_price values ('Honolulu, HI, United States', 94.15, 82.86);
insert into restaurant_price values ('Tokyo, Japan', 93.81, 58.93);
insert into restaurant_price values ('Brooklyn, NY, United States', 93.79, 100.58);
insert into restaurant_price values ('Paris, France', 92.87, 91.77);
insert into restaurant_price values ('Limerick, Ireland', 92.73, 82.93);
insert into restaurant_price values ('Rockville, MD, United States', 92.66, 74.74);
insert into restaurant_price values ('Bloomington, IN, United States', 92.14, 75.43);
insert into restaurant_price values ('Washington, DC, United States', 91.94, 85);
insert into restaurant_price values ('Arhus, Denmark', 91.9, 102.82);
insert into restaurant_price values ('Singapore, Singapore', 91.4, 64.4);

drop table if exists grocery_price; create table grocery_price(City varchar(1000), Cost_Of_Living float8, Grocery_Prices float8);
insert into grocery_price values ('Hamilton, Bermuda', 145.43, 143.47);
insert into grocery_price values ('Zurich, Switzerland', 141.25, 149.86);
insert into grocery_price values ('Geneva, Switzerland', 134.83, 138.98);
insert into grocery_price values ('Basel, Switzerland', 130.68, 127.54);
insert into grocery_price values ('Bern, Switzerland', 128.03, 132.7);
insert into grocery_price values ('Lausanne, Switzerland', 127.5, 126.59);
insert into grocery_price values ('Reykjavik, Iceland', 123.78, 118.15);
insert into grocery_price values ('Stavanger, Norway', 118.61, 106.09);
insert into grocery_price values ('Lugano, Switzerland', 118.24, 117.74);
insert into grocery_price values ('Oslo, Norway', 117.23, 112.42);
insert into grocery_price values ('Trondheim, Norway', 114.22, 103.5);
insert into grocery_price values ('Bergen, Norway', 112.31, 101.79);
insert into grocery_price values ('Kyoto, Japan', 100.33, 118.44);
insert into grocery_price values ('New York, NY, United States', 100, 100);
insert into grocery_price values ('Nassau, Bahamas', 99.73, 85.34);
insert into grocery_price values ('San Francisco, CA, United States', 97.84, 107.52);
insert into grocery_price values ('Copenhagen, Denmark', 97.62, 77.53);
insert into grocery_price values ('Luxembourg, Luxembourg', 95.37, 82.71);
insert into grocery_price values ('Anchorage, AK, United States', 94.99, 101.18);
insert into grocery_price values ('Honolulu, HI, United States', 94.15, 104.69);
insert into grocery_price values ('Tokyo, Japan', 93.81, 99.67);
insert into grocery_price values ('Brooklyn, NY, United States', 93.79, 92.73);
insert into grocery_price values ('Paris, France', 92.87, 87.29);
insert into grocery_price values ('Limerick, Ireland', 92.73, 87.15);
insert into grocery_price values ('Rockville, MD, United States', 92.66, 87.76);
insert into grocery_price values ('Bloomington, IN, United States', 92.14, 112.83);
insert into grocery_price values ('Washington, DC, United States', 91.94, 92.74);
insert into grocery_price values ('Arhus, Denmark', 91.9, 71.5);
insert into grocery_price values ('Singapore, Singapore', 91.4, 83.64);

drop table if exists house_price; create table house_price(Date varchar(1000), LosAngeles_Prices float8, SanDiego_Prices float8);
insert into house_price values ('January 1987', 59.43, 54.79);
insert into house_price values ('February 1987', 59.89, 55.22);
insert into house_price values ('March 1987', 60.4, 55.49);
insert into house_price values ('April 1987', 61.32, 56.05);
insert into house_price values ('May 1987', 62.03, 56.46);
insert into house_price values ('June 1987', 62.78, 56.79);
insert into house_price values ('July 1987', 63.46, 57.08);
insert into house_price values ('August 1987', 64.13, 57.38);
insert into house_price values ('September 1987', 64.89, 57.84);
insert into house_price values ('October 1987', 65.77, 58.3);
insert into house_price values ('November 1987', 66.71, 58.9);
insert into house_price values ('December 1987', 67.78, 59.4);
insert into house_price values ('January 1988', 68.78, 60.02);
insert into house_price values ('February 1988', 69.71, 60.49);
insert into house_price values ('March 1988', 70.7, 61.28);
insert into house_price values ('April 1988', 71.48, 61.44);
insert into house_price values ('May 1988', 72.48, 61.85);
insert into house_price values ('June 1988', 74.39, 61.44);
insert into house_price values ('July 1988', 76.92, 64.59);
insert into house_price values ('August 1988', 78.67, 65.29);
insert into house_price values ('September 1988', 80.61, 66.08);
insert into house_price values ('October 1988', 82.38, 67.18);
insert into house_price values ('November 1988', 84.41, 68.43);
insert into house_price values ('December 1988', 85.82, 69.83);
insert into house_price values ('January 1989', 87.47, 71.17);
insert into house_price values ('February 1989', 88.77, 72.76);
insert into house_price values ('March 1989', 91.15, 74.48);
insert into house_price values ('April 1989', 93.01, 75.81);
insert into house_price values ('May 1989', 94.57, 77.05);

drop table if exists chocolate_bars; create table chocolate_bars(BarName varchar(1000), Calories float8, Sugar float8);
insert into chocolate_bars values ('AlmondJoy', 4.7959184, 0.48979592);
insert into chocolate_bars values ('5thAvenue', 4.8214286, 0.46428571);
insert into chocolate_bars values ('CadburysCaramello', 4.6285714, 0.57142857);
insert into chocolate_bars values ('HersheysMilkChocolatewithAlmond', 5.5128205, 0.43589744);
insert into chocolate_bars values ('HersheyKitKat,BigKitKatBar', 5.2000000, 0.54545455);
insert into chocolate_bars values ('HersheyReesticks', 5.2142857, 0.40476190);
insert into chocolate_bars values ('M&MMars,3MusketeersBar', 4.1739130, 0.65217391);
insert into chocolate_bars values ('M&MMars,MilkyWay', 4.2173913, 0.60869565);
insert into chocolate_bars values ('M&MMars,MilkyWayDarkBar', 4.4800000, 0.60000000);
insert into chocolate_bars values ('M&MMars,Snickers', 4.6666667, 0.49122807);
insert into chocolate_bars values ('M&MMars,Twix', 4.9824561, 0.47368421);
insert into chocolate_bars values ('M&MMars,MARSAlmondBar', 4.6600000, 0.52000000);
insert into chocolate_bars values ('Nestle,100Grand', 4.4651163, 0.53488372);
insert into chocolate_bars values ('Nestle,BabyRuth', 4.6190476, 0.47619048);
insert into chocolate_bars values ('Nestle,Butterfinger', 4.7555556, 0.53333333);
insert into chocolate_bars values ('Nestle,Crunch', 5.2250000, 0.55000000);
insert into chocolate_bars values ('ReesesPeanutButterCups', 5.1555556, 0.46666667);
insert into chocolate_bars values ('RolosCaramels', 4.7500000, 0.64583333);
insert into chocolate_bars values ('YorkPeppermintPatty ', 3.8372093, 0.62790698);
insert into chocolate_bars values ('Krackle', 5.1219512, 0.53658537);
insert into chocolate_bars values ('AeroChocolateBar', 5.1777778, 0.57777778);
insert into chocolate_bars values ('Toblerone', 5.2000000, 0.54000000);

drop table if exists broadway_shows; create table broadway_shows(Season varchar(1000), Revenue float8, Ticket_Price float8);
insert into broadway_shows values ('1984', 209, 28.787879);
insert into broadway_shows values ('1985', 190, 29.051988);
insert into broadway_shows values ('1986', 208, 29.545455);
insert into broadway_shows values ('1987', 253, 31.081081);
insert into broadway_shows values ('1988', 262, 32.914573);
insert into broadway_shows values ('1989', 282, 35.074627);
insert into broadway_shows values ('1990', 267, 36.475410);
insert into broadway_shows values ('1991', 293, 39.701897);
insert into broadway_shows values ('1992', 328, 41.730280);
insert into broadway_shows values ('1993', 356, 43.896424);
insert into broadway_shows values ('1994', 406, 44.911504);
insert into broadway_shows values ('1995', 436, 46.040127);
insert into broadway_shows values ('1996', 499, 47.209082);
insert into broadway_shows values ('1997', 558, 48.606272);
insert into broadway_shows values ('1998', 588, 50.385604);
insert into broadway_shows values ('1999', 603, 52.941176);
insert into broadway_shows values ('2000', 666, 55.966387);
insert into broadway_shows values ('2001', 643, 58.721461);
insert into broadway_shows values ('2002', 721, 63.134851);
insert into broadway_shows values ('2003', 771, 66.408269);
insert into broadway_shows values ('2004', 769, 66.695577);
insert into broadway_shows values ('2005', 862, 71.833333);
insert into broadway_shows values ('2006', 939, 76.279448);
insert into broadway_shows values ('2007', 938, 76.446618);
insert into broadway_shows values ('2008', 943, 77.613169);
insert into broadway_shows values ('2009', 1020, 85.786375);
insert into broadway_shows values ('2010', 1081, 86.272945);
insert into broadway_shows values ('2011', 1139, 92.376318);
insert into broadway_shows values ('2012', 1139, 98.444252);
insert into broadway_shows values ('2013', 1269, 103.93120);
insert into broadway_shows values ('2014', 1365, 104.19847);
insert into broadway_shows values ('2015', 1373, 103.07808);
insert into broadway_shows values ('2016', 1449, 109.19367);

drop table if exists burger_king; create table burger_king(Item varchar(1000), Weight float8, Meat_Weight float8);
insert into burger_king values ('Hamburger', 109, 28);
insert into burger_king values ('Cheeseburger', 121, 28);
insert into burger_king values ('Double_Hamburger', 146, 28);
insert into burger_king values ('Double_Cheeseburger', 171, 29);
insert into burger_king values ('Buck_Double', 158, 28);
insert into burger_king values ('Rodeo_Cheeseburger', 128, 37);
insert into burger_king values ('Bacon_Cheeseburger', 126, 28);
insert into burger_king values ('Double-Bacon_Cheeseburger', 181, 29);
insert into burger_king values ('BK _Double_Stacker', 173, 29);
insert into burger_king values ('BK _Triple_Stacker', 227, 30);
insert into burger_king values ('BK _Quad_Stacker', 282, 31);
insert into burger_king values ('A1 _Steakhouse_XT', 316, 42);
insert into burger_king values ('Steakhouse_XT', 284, 40);
insert into burger_king values ('TENDERGRILL ChickenSandwich_on_ciabata', 250, 40);
insert into burger_king values ('TENDERGRILL ChickenSandwich w/o_Mayo', 236, 40);
insert into burger_king values ('TENDERCRISP _Chicken_Sandwich', 284, 68);
insert into burger_king values ('TENDERCRISP _Chicken_Sandwichw/oMayo', 256, 68);
insert into burger_king values ('Original_Chicken_Sandwich', 218, 46);
insert into burger_king values ('Original_Chicken_Sandwichw/oMayo', 190, 46);
insert into burger_king values ('AmericanOriginalChicken_Sandwich', 271, 49);
insert into burger_king values ('OriginalChickenClubSandwich', 256, 48);
insert into burger_king values ('ItalianOriginalChickenSandiwch', 246, 50);
insert into burger_king values ('SpicyCHICKNCRISP Sandwich', 136, 34);
insert into burger_king values ('SpicyCHICKNCRISP Sandwichw/oMayo', 114, 35);
insert into burger_king values ('CHICKENTENDERS (4pc)', 62, 13);
insert into burger_king values ('CHICKENTENDERS (5pc)', 78, 16);
insert into burger_king values ('CHICKENTENDERS (6pc)', 93, 19);
insert into burger_king values ('CHICKENTENDERS (8pc)', 123, 25);
insert into burger_king values ('CHICKENTENDERS Sandwich', 142, 35);
insert into burger_king values ('KRAFT MacaroniandCheese', 113, 0);
insert into burger_king values ('Tacos(2)', 174, 18);
insert into burger_king values ('SpicyChickenBKWrapper', 135, 32);
insert into burger_king values ('BK CHICKENFRIES(6pc)', 85, 16);
insert into burger_king values ('BK CHICKENFRIES(9pc)', 127, 24);
insert into burger_king values ('BK CHICKENFRIES(12pc)', 170, 32);
insert into burger_king values ('CountryPorkSandwich', 298, 78);
insert into burger_king values ('TENDERGRILLChickenGardenSalad', 286, 9);
insert into burger_king values ('TENDERCRISP ChickenGardenSalad', 284, 27);
insert into burger_king values ('GardenSalad(nochicken)', 162, 0);

drop table if exists cereals; create table cereals(Cereal varchar(1000), Sodium float8, Fiber float8);
insert into cereals values ('100%_Bran', 130, 10);
insert into cereals values ('100%_Natural_Bran', 15, 2);
insert into cereals values ('All-Bran', 260, 9);
insert into cereals values ('All-Bran_with_Extra_Fiber', 140, 14);
insert into cereals values ('Almond_Delight', 200, 1);
insert into cereals values ('Apple_Cinnamon_Cheerios', 180, 1.5);
insert into cereals values ('Apple_Jacks', 125, 1);
insert into cereals values ('Basic_4', 210, 2);
insert into cereals values ('Bran_Chex', 200, 4);
insert into cereals values ('Bran_Flakes', 210, 5);
insert into cereals values ('CapnCrunch', 220, 0);
insert into cereals values ('Cheerios', 290, 2);
insert into cereals values ('Cinnamon_Toast_Crunch', 210, 0);
insert into cereals values ('Clusters', 140, 2);
insert into cereals values ('Cocoa_Puffs', 180, 0);
insert into cereals values ('Corn_Chex', 280, 0);
insert into cereals values ('Corn_Flakes', 290, 1);
insert into cereals values ('Corn_Pops', 90, 1);
insert into cereals values ('Count_Chocula', 180, 0);
insert into cereals values ('Cracklin_Oat_Bran', 140, 4);
insert into cereals values ('Cream_of_Wheat_(Quick)', 80, 1);
insert into cereals values ('Crispix', 220, 1);
insert into cereals values ('Crispy_Wheat_&_Raisins', 140, 2);
insert into cereals values ('Double_Chex', 190, 1);
insert into cereals values ('Froot_Loops', 125, 1);
insert into cereals values ('Frosted_Flakes', 200, 1);
insert into cereals values ('Frosted_Mini-Wheats', 0, 3);
insert into cereals values ('Fruit_&_Fibre_Dates,_Walnuts,_and_Oats', 160, 5);
insert into cereals values ('Fruitful_Bran', 240, 5);
insert into cereals values ('Fruity_Pebbles', 135, 0);
insert into cereals values ('Golden_Crisp', 45, 0);
insert into cereals values ('Golden_Grahams', 280, 0);
insert into cereals values ('Grape_Nuts_Flakes', 140, 3);
insert into cereals values ('Grape-Nuts', 170, 3);
insert into cereals values ('Great_Grains_Pecan', 75, 3);
insert into cereals values ('Honey_Graham_Ohs', 220, 1);
insert into cereals values ('Honey_Nut_Cheerios', 250, 1.5);
insert into cereals values ('Honey-comb', 180, 0);
insert into cereals values ('Just_Right_Crunchy__Nuggets', 170, 1);
insert into cereals values ('Just_Right_Fruit_&_Nut', 170, 2);
insert into cereals values ('Kix', 260, 0);
insert into cereals values ('Life', 150, 2);
insert into cereals values ('Lucky_Charms', 180, 0);
insert into cereals values ('Maypo', 0, 0);
insert into cereals values ('Muesli_Raisins,_Dates,_&_Almonds', 95, 3);
insert into cereals values ('Muesli_Raisins,_Peaches,_&_Pecans', 150, 3);
insert into cereals values ('Mueslix_Crispy_Blend', 150, 3);
insert into cereals values ('Multi-Grain_Cheerios', 220, 2);
insert into cereals values ('Nut&Honey_Crunch', 190, 0);
insert into cereals values ('Nutri-Grain_Almond-Raisin', 220, 3);
insert into cereals values ('Nutri-grain_Wheat', 170, 3);
insert into cereals values ('Oatmeal_Raisin_Crisp', 170, 1.5);
insert into cereals values ('Post_Nat._Raisin_Bran', 200, 6);
insert into cereals values ('Product_19', 320, 1);
insert into cereals values ('Puffed_Rice', 0, 0);
insert into cereals values ('Puffed_Wheat', 0, 1);
insert into cereals values ('Quaker_Oat_Squares', 135, 2);
insert into cereals values ('Quaker_Oatmeal', 0, 2.7);
insert into cereals values ('Raisin_Bran', 210, 5);
insert into cereals values ('Raisin_Nut_Bran', 140, 2.5);
insert into cereals values ('Raisin_Squares', 0, 2);
insert into cereals values ('Rice_Chex', 240, 0);
insert into cereals values ('Rice_Krispies', 290, 0);
insert into cereals values ('Shredded_Wheat', 0, 3);
insert into cereals values ('Shredded_Wheat_n_Bran', 0, 4);
insert into cereals values ('Shredded_Wheat_spoon_size', 0, 3);
insert into cereals values ('Smacks', 70, 1);
insert into cereals values ('Special_K', 230, 1);
insert into cereals values ('Strawberry_Fruit_Wheats', 15, 3);
insert into cereals values ('Total_Corn_Flakes', 200, 0);
insert into cereals values ('Total_Raisin_Bran', 190, 4);
insert into cereals values ('Total_Whole_Grain', 200, 3);
insert into cereals values ('Triples', 250, 0);
insert into cereals values ('Trix', 140, 0);
insert into cereals values ('Wheat_Chex', 230, 3);
insert into cereals values ('Wheaties', 200, 3);
insert into cereals values ('Wheaties_Honey_Gold', 200, 1);

drop table if exists offres_emploi; create table offres_emploi(Mois varchar(1000), CDI float8, Autres_Contrats float8);
insert into offres_emploi values ('2015-1', 164840, 185860);
insert into offres_emploi values ('2015-2', 163270, 204960);
insert into offres_emploi values ('2015-3', 187730, 248020);
insert into offres_emploi values ('2015-4', 163020, 241460);
insert into offres_emploi values ('2015-5', 149130, 214270);
insert into offres_emploi values ('2015-6', 165390, 266710);
insert into offres_emploi values ('2015-7', 302610, 329080);
insert into offres_emploi values ('2015-8', 245170, 282470);
insert into offres_emploi values ('2015-9', 269130, 303760);
insert into offres_emploi values ('2015-10', 235370, 289860);
insert into offres_emploi values ('2015-11', 269760, 274240);
insert into offres_emploi values ('2015-12', 293690, 250570);
insert into offres_emploi values ('2016-1', 326060, 286890);
insert into offres_emploi values ('2016-2', 282740, 247160);
insert into offres_emploi values ('2016-3', 301260, 317310);
insert into offres_emploi values ('2016-4', 280470, 305570);
insert into offres_emploi values ('2016-5', 287120, 328860);
insert into offres_emploi values ('2016-6', 353980, 390720);
insert into offres_emploi values ('2016-7', 355240, 388140);
insert into offres_emploi values ('2016-8', 256080, 259980);
insert into offres_emploi values ('2016-9', 376460, 372450);
insert into offres_emploi values ('2016-10', 353090, 349520);
insert into offres_emploi values ('2016-11', 289020, 288210);
insert into offres_emploi values ('2016-12', 277580, 268050);
insert into offres_emploi values ('2017-1', 316190, 290600);
insert into offres_emploi values ('2017-2', 315090, 285140);
insert into offres_emploi values ('2017-3', 421290, 429910);
insert into offres_emploi values ('2017-4', 337700, 341770);
insert into offres_emploi values ('2017-5', 339140, 321650);
insert into offres_emploi values ('2017-6', 340840, 292650);
insert into offres_emploi values ('2017-7', 283590, 235620);
insert into offres_emploi values ('2017-8', 241210, 204900);
insert into offres_emploi values ('2017-9', 297130, 246330);
insert into offres_emploi values ('2017-10', 306120, 229680);
insert into offres_emploi values ('2017-11', 361420, 229440);
insert into offres_emploi values ('2017-12', 286420, 186340);
insert into offres_emploi values ('2018-1', 319750, 216000);
insert into offres_emploi values ('2018-2', 343650, 224400);
insert into offres_emploi values ('2018-3', 477980, 294490);
insert into offres_emploi values ('2018-4', 347970, 256830);
insert into offres_emploi values ('2018-5', 351340, 251370);
insert into offres_emploi values ('2018-6', 263700, 226760);
insert into offres_emploi values ('2018-7', 484130, 309150);
insert into offres_emploi values ('2018-8', 337660, 264440);
insert into offres_emploi values ('2018-9', 369860, 290240);
insert into offres_emploi values ('2018-10', 393130, 266790);
insert into offres_emploi values ('2018-11', 337890, 249400);
insert into offres_emploi values ('2018-12', 320390, 204260);
insert into offres_emploi values ('2019-1', 319570, 244640);
insert into offres_emploi values ('2019-2', 283960, 230980);
insert into offres_emploi values ('2019-3', 308310, 246260);
insert into offres_emploi values ('2019-4', 326200, 296440);
insert into offres_emploi values ('2019-5', 303850, 294130);
insert into offres_emploi values ('2019-6', 447150, 274890);
insert into offres_emploi values ('2019-7', 460090, 331390);
insert into offres_emploi values ('2019-8', 388710, 223340);
insert into offres_emploi values ('2019-9', 490540, 286600);
insert into offres_emploi values ('2019-10', 518620, 259830);
insert into offres_emploi values ('2019-11', 481840, 238340);
insert into offres_emploi values ('2019-12', 428290, 213320);
insert into offres_emploi values ('2020-1', 524170, 264040);
insert into offres_emploi values ('2020-2', 494120, 264750);
insert into offres_emploi values ('2020-3', 348920, 180710);
insert into offres_emploi values ('2020-4', 226340, 101920);
insert into offres_emploi values ('2020-5', 329020, 139030);
insert into offres_emploi values ('2020-6', 402130, 246630);
insert into offres_emploi values ('2020-7', 430720, 258400);
insert into offres_emploi values ('2020-8', 353920, 206920);
insert into offres_emploi values ('2020-9', 459390, 261390);
insert into offres_emploi values ('2020-10', 445213, 249814);
insert into offres_emploi values ('2020-11', 339196, 205578);
insert into offres_emploi values ('2020-12', 399334, 217477);
insert into offres_emploi values ('2021-1', 431291, 244810);
insert into offres_emploi values ('2021-2', 422272, 249942);
insert into offres_emploi values ('2021-3', 447580, 345449);
insert into offres_emploi values ('2021-4', 465460, 327004);
insert into offres_emploi values ('2021-5', 455127, 354230);
insert into offres_emploi values ('2021-6', 551393, 438757);
insert into offres_emploi values ('2021-7', 558365, 417618);
insert into offres_emploi values ('2021-8', 277701, 215480);
insert into offres_emploi values ('2021-9', 631913, 501555);

drop table if exists population_departement; create table population_departement(Departement varchar(1000), Hommes float8, Femmes float8);
insert into population_departement values ('Ain', 326233, 336011);
insert into population_departement values ('Aisne', 256150, 269353);
insert into population_departement values ('Allier', 158840, 172905);
insert into population_departement values ('Alpes-de-Haute-Provence', 80474, 85228);
insert into population_departement values ('Hautes-Alpes', 68264, 71758);
insert into population_departement values ('Alpes-Maritimes', 514217, 575053);
insert into population_departement values ('Ardèche', 160053, 167722);
insert into population_departement values ('Ardennes', 129304, 135795);
insert into population_departement values ('Ariège', 74867, 78248);
insert into population_departement values ('Aube', 150638, 159509);
insert into population_departement values ('Aude', 181601, 196118);
insert into population_departement values ('Aveyron', 138076, 141134);
insert into population_departement values ('Bouches-du-Rhône', 976762, 1071633);
insert into population_departement values ('Calvados', 332441, 360398);
insert into population_departement values ('Cantal', 70339, 72941);
insert into population_departement values ('Charente', 168882, 180115);
insert into population_departement values ('Charente-Maritime', 311254, 341220);
insert into population_departement values ('Cher', 143628, 153166);
insert into population_departement values ('Corrèze', 115852, 123219);
insert into population_departement values ('Corse-du-Sud', 78250, 84503);
insert into population_departement values ('Haute-Corse', 91226, 95290);
insert into population_departement values ('Côte-dOr', 256003, 276023);
insert into population_departement values ('Côtes-dArmor', 288884, 310234);
insert into population_departement values ('Creuse', 55420, 59085);
insert into population_departement values ('Dordogne', 197718, 213012);
insert into population_departement values ('Doubs', 265658, 277563);
insert into population_departement values ('Drôme', 252819, 270303);
insert into population_departement values ('Eure', 289266, 305771);
insert into population_departement values ('Eure-et-Loir', 208909, 219269);
insert into population_departement values ('Finistère', 444026, 470275);
insert into population_departement values ('Gard', 361695, 388988);
insert into population_departement values ('Haute-Garonne', 693073, 731842);
insert into population_departement values ('Gers', 93327, 98060);
insert into population_departement values ('Gironde', 792258, 862187);
insert into population_departement values ('Hérault', 570956, 625677);
insert into population_departement values ('Ille-et-Vilaine', 534218, 560418);
insert into population_departement values ('Indre', 104612, 112086);
insert into population_departement values ('Indre-et-Loire', 292983, 316425);
insert into population_departement values ('Isère', 620596, 650482);
insert into population_departement values ('Jura', 125689, 132237);
insert into population_departement values ('Landes', 201788, 215037);
insert into population_departement values ('Loir-et-Cher', 158325, 168050);
insert into population_departement values ('Loire', 370203, 395080);
insert into population_departement values ('Haute-Loire', 111725, 115821);
insert into population_departement values ('Loire-Atlantique', 708374, 750394);
insert into population_departement values ('Loiret', 332802, 351196);
insert into population_departement values ('Lot', 84584, 89624);
insert into population_departement values ('Lot-et-Garonne', 157788, 172086);
insert into population_departement values ('Lozère', 38270, 38260);
insert into population_departement values ('Maine-et-Loire', 398432, 421096);
insert into population_departement values ('Manche', 239508, 251857);
insert into population_departement values ('Marne', 271292, 290413);
insert into population_departement values ('Haute-Marne', 82198, 86033);
insert into population_departement values ('Mayenne', 150376, 155048);
insert into population_departement values ('Meurthe-et-Moselle', 354530, 375207);
insert into population_departement values ('Meuse', 88809, 90210);
insert into population_departement values ('Morbihan', 369473, 393630);
insert into population_departement values ('Moselle', 507479, 530961);
insert into population_departement values ('Nièvre', 95993, 103525);
insert into population_departement values ('Nord', 1252390, 1345909);
insert into population_departement values ('Oise', 404560, 425135);
insert into population_departement values ('Orne', 133895, 141236);
insert into population_departement values ('Pas-de-Calais', 707249, 747769);
insert into population_departement values ('Puy-de-Dôme', 324013, 345464);
insert into population_departement values ('Pyrénées-Atlantiques', 329064, 359525);
insert into population_departement values ('Hautes-Pyrénées', 110382, 118808);
insert into population_departement values ('Pyrénées-Orientales', 228231, 252202);
insert into population_departement values ('Bas-Rhin', 556547, 590927);
insert into population_departement values ('Haut-Rhin', 374168, 389633);
insert into population_departement values ('Rhône', 909844, 982909);
insert into population_departement values ('Haute-Saône', 114373, 119018);
insert into population_departement values ('Saône-et-Loire', 265599, 281582);
insert into population_departement values ('Sarthe', 273421, 288756);
insert into population_departement values ('Savoie', 213926, 223733);
insert into population_departement values ('Haute-Savoie', 412617, 425863);
insert into population_departement values ('Paris', 1006682, 1135684);
insert into population_departement values ('Seine-Maritime', 601720, 649126);
insert into population_departement values ('Seine-et-Marne', 695619, 736856);
insert into population_departement values ('Yvelines', 706328, 746582);
insert into population_departement values ('Deux-Sèvres', 182892, 191458);
insert into population_departement values ('Somme', 274529, 292713);
insert into population_departement values ('Tarn', 187694, 201726);
insert into population_departement values ('Tarn-et-Garonne', 128421, 133833);
insert into population_departement values ('Var', 520941, 563949);
insert into population_departement values ('Vaucluse', 268798, 291921);
insert into population_departement values ('Vendée', 336993, 354276);
insert into population_departement values ('Vienne', 211797, 227072);
insert into population_departement values ('Haute-Vienne', 175741, 194622);
insert into population_departement values ('Vosges', 174561, 184262);
insert into population_departement values ('Yonne', 162078, 170928);
insert into population_departement values ('Territoire de Belfort', 68758, 69831);
insert into population_departement values ('Essonne', 643844, 671612);
insert into population_departement values ('Hauts-de-Seine', 775616, 857484);
insert into population_departement values ('Seine-Saint-Denis', 820007, 849333);
insert into population_departement values ('Val-de-Marne', 681903, 736669);
insert into population_departement values ('Val-d-Oise', 610781, 649261);
insert into population_departement values ('Guadeloupe ', 170406, 205287);
insert into population_departement values ('Martinique ', 161529, 193295);
insert into population_departement values ('Guyane', 141251, 152895);
insert into population_departement values ('La Réunion', 405978, 451831);
insert into population_departement values ('Mayotte', 137744, 151182);