INSERT INTO customer (name,age,birthdate) VALUES ("Odessa Bowman",45,"1959-05-22"),("Harriet Mcintyre",23,"1992-03-08"),("Cynthia Skinner",60,"1981-08-14"),("Aurora Cook",43,"1978-11-02"),("Althea Valencia",60,"1962-10-24"),("Adena Jennings",45,"1992-07-05"),("George Carroll",37,"1967-09-25"),("Kiayada Barlow",55,"1979-03-17"),("August Powell",45,"1966-03-23"),("Xanthus Rasmussen",38,"1958-10-20");
INSERT INTO customer (name,age,birthdate) VALUES ("Hayfa Silva",42,"1983-12-11"),("Jade Barrett",33,"1955-05-17"),("Mercedes Norman",36,"1993-11-16"),("Joan Knight",25,"1975-08-08"),("Leonard Mathis",40,"1976-06-10"),("Burton Burks",46,"1968-01-12"),("Karly Bean",21,"1983-09-07"),("Athena Maldonado",38,"1973-04-16"),("Melvin Walls",55,"1959-01-02"),("Ella Sears",55,"1987-06-14");
INSERT INTO customer (name,age,birthdate) VALUES ("Amy Henderson",49,"1954-06-04"),("Myra Mueller",26,"1958-05-24"),("Thane Rhodes",59,"1982-03-30"),("Jonah Cherry",41,"1955-10-22"),("Abraham Wilkinson",30,"1981-09-15"),("Walter Castillo",59,"1973-07-05"),("Amery Sherman",60,"1964-07-03"),("Zorita Joyce",21,"1972-12-01"),("Silas Graham",25,"1954-05-05"),("Ferdinand Dillon",52,"1987-03-13");
INSERT INTO customer (name,age,birthdate) VALUES ("Sade Blanchard",31,"1969-01-13"),("Keaton Gordon",49,"1959-02-09"),("Kirk Lancaster",32,"1970-02-21"),("Dakota Hensley",43,"1979-09-26"),("Xenos Perry",45,"1973-09-27"),("Tyler Park",28,"1962-10-18"),("Rhoda Reid",49,"1977-10-19"),("Alvin Finley",24,"1964-03-24"),("Sybil Floyd",37,"1982-12-31"),("Buckminster West",48,"1980-12-04");
INSERT INTO customer (name,age,birthdate) VALUES ("Otto Adams",53,"1994-06-18"),("Cedric Barrera",35,"1988-11-15"),("Erica Velazquez",48,"1956-01-02"),("Katelyn Conrad",23,"1991-06-30"),("Baxter Clarke",55,"1980-09-20"),("Oleg Solomon",28,"1978-11-05"),("Fatima Stevenson",57,"1994-08-23"),("Marshall Riddle",57,"1994-08-10"),("Jacob Brewer",52,"1977-05-26"),("Hadassah Knowles",39,"1969-09-17");
INSERT INTO customer (name,age,birthdate) VALUES ("Quentin Callahan",37,"1958-05-12"),("Beatrice Jennings",24,"1968-10-17"),("Myra Pugh",55,"1981-02-26"),("Robin Britt",28,"1967-07-05"),("Bertha Schwartz",32,"1974-03-13"),("Priscilla Jacobs",37,"1964-11-20"),("Alvin Frost",33,"1969-10-03"),("Mallory Wilkerson",55,"1972-09-03"),("Neve Snow",45,"1990-05-23"),("Indira Mack",33,"1988-09-19");
INSERT INTO customer (name,age,birthdate) VALUES ("Lila Deleon",34,"1960-05-08"),("Timon Mullen",58,"1994-05-15"),("Julian Kim",23,"1979-11-01"),("Martha Hart",59,"1974-09-23"),("Illiana Stone",46,"1976-08-23"),("Jonah Perkins",39,"1982-01-13"),("Kennan Dawson",58,"1988-11-11"),("Harding Cabrera",25,"1989-09-30"),("Donna Schneider",48,"1988-07-24"),("Tara Maxwell",21,"1990-01-26");
INSERT INTO customer (name,age,birthdate) VALUES ("Geoffrey Greer",41,"1992-08-27"),("Haley Cardenas",34,"1967-02-21"),("Erin Fischer",37,"1959-09-15"),("Aaron Gibson",35,"1963-07-22"),("Rhea Myers",33,"1989-01-05"),("Quincy Crosby",35,"1965-02-26"),("Zelda Warren",43,"1983-12-15"),("Blaze Shields",20,"1987-06-13"),("Indira Doyle",43,"1980-04-11"),("Logan Cantu",27,"1970-12-14");
INSERT INTO customer (name,age,birthdate) VALUES ("Vanna Young",52,"1962-05-20"),("Cameron Solis",50,"1983-02-01"),("Fulton Kane",20,"1981-05-08"),("Keaton Romero",45,"1977-04-26"),("Jeremy Stafford",45,"1962-03-23"),("Keefe Madden",60,"1960-08-02"),("Mark Pacheco",32,"1987-07-02"),("Molly Walsh",51,"1963-09-02"),("Cathleen Fischer",23,"1986-10-31"),("Laurel Mccarty",22,"1991-05-26");
INSERT INTO customer (name,age,birthdate) VALUES ("Wynter House",49,"1965-10-06"),("Deacon Farmer",34,"1986-10-02"),("Bell Stevenson",20,"1991-06-15"),("Simon Fields",35,"1962-04-13"),("Oliver Cooke",20,"1961-01-11"),("Caldwell Morris",23,"1976-02-04"),("Howard Benson",41,"1966-03-28"),("Jenna Pratt",54,"1986-07-21"),("Marsden Sargent",41,"1967-07-18"),("Kylie Terrell",26,"1977-04-04");



INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-11-12","2020-09-01",496400,51,80,85,4),("1","2000-05-14","2020-11-04",320016,65,9,29,8),("1","2000-10-01","2020-09-16",587874,86,77,95,6),("1","2000-02-29","2020-07-09",513021,18,53,8,6),("1","2000-02-08","2020-11-15",593889,12,47,39,4),("1","2000-08-12","2020-08-14",424365,18,59,35,1),("1","2000-03-05","2020-09-30",264066,26,62,86,1),("1","2000-12-07","2020-05-04",302390,81,42,11,3),("1","2000-01-07","2020-12-10",501246,73,72,37,9),("1","2000-06-28","2020-03-03",452647,54,1,9,3);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-06-12","2020-05-31",310085,48,19,52,3),("1","2000-08-03","2020-03-26",785588,26,28,12,1),("1","2000-09-21","2020-08-07",351870,80,39,31,5),("1","2000-06-02","2020-11-14",200389,44,13,96,8),("1","2000-04-09","2020-05-24",538111,31,45,69,10),("1","2000-04-16","2020-03-20",211573,72,79,47,6),("1","2000-07-19","2020-06-16",725205,49,10,44,3),("1","2000-04-15","2020-12-20",270292,39,81,11,6),("1","2000-03-07","2020-03-08",498112,45,51,66,8),("1","2000-04-03","2020-02-19",761436,63,19,12,8);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-05-04","2020-06-10",533998,79,89,33,8),("1","2000-08-30","2020-11-04",184569,96,88,83,3),("1","2000-09-20","2020-10-26",804185,67,90,87,7),("0","2000-11-18","2020-07-08",438550,94,50,18,4),("0","2000-11-10","2020-08-30",218295,33,72,23,8),("1","2000-12-27","2020-02-21",257569,14,74,57,9),("1","2000-04-28","2020-02-01",801762,72,33,65,7),("1","2000-03-29","2020-12-09",597403,67,92,73,8),("1","2000-12-21","2020-11-19",713216,18,38,2,7),("1","2000-02-11","2020-11-17",742511,24,50,67,7);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-01-15","2020-07-31",217640,86,54,60,4),("1","2000-03-14","2020-07-23",393921,28,19,8,1),("1","2000-03-18","2020-03-04",360856,15,100,13,7),("1","2000-06-24","2020-04-22",467138,87,15,42,8),("1","2000-09-20","2020-05-30",916411,65,18,80,7),("1","2000-11-15","2020-12-27",352780,32,87,32,5),("1","2000-11-28","2020-02-13",140570,40,48,15,4),("1","2000-10-20","2020-09-19",929102,9,22,23,4),("1","2000-12-18","2020-09-23",307790,35,58,95,9),("1","2000-08-13","2020-09-12",356048,67,74,76,10);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-06-12","2020-12-19",890447,94,83,54,3),("1","2000-02-20","2020-08-24",794342,15,26,84,10),("1","2000-10-31","2020-02-18",657910,100,13,69,7),("1","2000-03-30","2020-05-30",786199,94,3,16,1),("1","2000-04-05","2020-03-12",645590,43,8,37,2),("1","2000-12-03","2020-02-07",391062,62,71,2,4),("1","2000-02-09","2020-12-08",651699,67,32,90,7),("1","2000-01-25","2020-04-24",628374,85,63,95,8),("1","2000-09-02","2020-05-05",317319,39,73,79,5),("1","2000-01-26","2020-04-17",216515,14,77,11,1);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-02-09","2020-06-10",683391,44,36,26,3),("1","2000-11-23","2020-05-10",723308,34,18,5,9),("1","2000-04-10","2020-11-19",523965,57,84,74,4),("1","2000-04-02","2020-01-04",705055,39,18,88,4),("1","2000-12-17","2020-01-28",538615,8,84,69,4),("1","2000-12-04","2020-01-25",341942,36,75,26,7),("1","2000-12-27","2020-12-14",120280,55,72,96,10),("1","2000-08-17","2020-06-18",918811,93,76,67,6),("1","2000-03-03","2020-06-27",674871,46,14,15,9),("1","2000-12-11","2020-03-23",294351,43,11,31,5);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-09-13","2020-04-29",704243,12,38,44,5),("1","2000-01-12","2020-03-03",126532,44,100,62,3),("1","2000-10-29","2020-09-10",163320,75,29,64,10),("1","2000-02-06","2020-11-03",587718,41,64,68,10),("1","2000-04-15","2020-07-20",781559,57,97,87,4),("1","2000-08-24","2020-08-09",251143,35,87,96,2),("1","2000-05-09","2020-12-31",316928,11,49,37,7),("1","2000-10-02","2020-12-25",611224,94,86,2,10),("1","2000-01-29","2020-09-29",339249,15,76,77,4),("1","2000-01-23","2020-08-11",833924,46,92,75,8);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-10-13","2020-04-30",225243,1,48,58,6),("1","2000-09-26","2020-10-15",373204,50,9,60,1),("1","2000-08-14","2020-03-27",704722,87,45,98,8),("1","2000-09-13","2020-05-31",201590,52,74,5,5),("1","2000-09-06","2020-06-10",374238,69,89,72,4),("1","2000-05-21","2020-06-24",632636,88,63,50,3),("1","2000-04-21","2020-08-05",226447,50,33,71,1),("1","2000-08-02","2020-12-20",664067,89,69,99,10),("1","2000-09-28","2020-03-22",509738,19,96,94,1),("1","2000-01-09","2020-11-11",260539,11,65,37,4);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-12-28","2020-08-20",311082,60,41,7,5),("1","2000-12-30","2020-03-04",274188,48,35,31,9),("1","2000-11-12","2020-03-29",270436,81,45,17,8),("0","2000-05-12","2020-01-06",923998,50,40,43,4),("1","2000-04-05","2020-02-17",828801,85,7,38,8),("0","2000-08-15","2020-05-31",785047,99,60,44,6),("1","2000-06-14","2020-11-15",352324,62,70,40,3),("1","2000-05-17","2020-02-28",103714,71,16,88,6),("1","2000-10-22","2020-05-11",891374,49,5,30,2),("1","2000-09-13","2020-05-07",702932,64,95,72,8);
INSERT INTO franchise (status,startdate,enddate,annual_fee,OPERATOR_operator_id,VENDOR_vendor_id,LOCATION_location_id,FRANCHISE_TYPE_franchisetype_id) VALUES ("1","2000-03-21","2020-03-05",435924,79,14,95,1),("1","2000-06-04","2020-09-14",739002,24,93,26,2),("1","2000-06-17","2020-05-21",821196,60,41,46,10),("1","2000-04-15","2020-06-25",399227,25,78,32,7),("1","2000-09-16","2020-09-25",568153,64,91,78,1),("1","2000-05-08","2020-04-14",317004,26,17,1,5),("1","2000-03-16","2020-11-30",484039,85,48,65,8),("1","2000-03-30","2020-10-22",779244,39,45,87,1),("1","2000-03-06","2020-01-05",212170,27,42,72,9),("1","2000-06-15","2020-12-24",325193,64,3,55,7);



INSERT INTO location (district,city,province,population) VALUES ("5th","Carcassonne","LA",2269709),("3rd","Donosti","PV",7209502),("5th","Rockhampton","Queensland",6303852),("6th","Pelotas","Rio Grande do Sul",6522856),("4th","Rio de Janeiro","RJ",5836155),("3rd","Dandenong","VI",7928699),("2nd","Waiheke Island","NI",6753391),("3rd","Helena","Montana",8041795),("1st","Hamilton","NI",1319966),("7th","Toruń","KP",1257941);
INSERT INTO location (district,city,province,population) VALUES ("1st","Falmouth","Cornwall",3762476),("5th","Łódź","LD",8451469),("6th","Dorgali","Sardegna",4790254),("9th","Auckland","NI",3882093),("3rd","Águas Lindas de Goiás","Goiás",8938188),("9th","Frederick","MD",7302083),("7th","Maringá","PR",5346330),("9th","Bala","ME",5505402),("5th","Vienna","Wi",4902259),("3rd","Neder-Over-Heembeek","BU",9601813);
INSERT INTO location (district,city,province,population) VALUES ("3rd","Parramatta","NS",5716635),("5th","Shivapuri","Madhya Pradesh",8906132),("2nd","Delhi","Delhi",9309834),("2nd","San Rafael","Alajuela",9032051),("7th","Dole","Franche-Comté",1875044),("2nd","Stonewall","MB",8907988),("9th","Billings","MT",7670893),("9th","Karnal","Haryana",7410744),("3rd","Caplan","Quebec",7853504),("5th","Gijón","Principado de Asturias",7375596);
INSERT INTO location (district,city,province,population) VALUES ("2nd","Rotorua","North Island",4914816),("1st","Carlisle","Cumberland",5903186),("5th","Lexington","KY",3971809),("2nd","Valéncia","CV",8723230),("8th","Lacombe County","AB",7640915),("4th","Ganshoren","Brussels Hoofdstedelijk Gewest",9429031),("2nd","Sete Lagoas","Minas Gerais",3426171),("1st","Bhopal","Madhya Pradesh",8121760),("4th","Pontarlier","Franche-Comté",6525650),("9th","Zierikzee","Zeeland",7075563);
INSERT INTO location (district,city,province,population) VALUES ("4th","Bremen","HB",4144726),("6th","Vitry-sur-Seine","Île-de-France",9140633),("10th","Gboko","BE",1243308),("10th","Polesella","VE",5869943),("9th","Huntly","NI",6232161),("7th","Uppingham. Cottesmore","Rutland",6336841),("7th","Cobourg","Ontario",2218205),("2nd","Heredia","H",3366626),("10th","Olcenengo","Piemonte",6175742),("4th","Parramatta","New South Wales",7076391);
INSERT INTO location (district,city,province,population) VALUES ("4th","Castelmarte","LO",7680045),("9th","Nova Iguaçu","Rio de Janeiro",9992035),("9th","Gianico","LO",1080558),("9th","Rycroft","AB",5204691),("6th","Canberra","AC",8224758),("5th","Olinda","PE",8500108),("5th","Virginia Beach","Virginia",6154537),("4th","Maranguape","CE",5071628),("7th","Donosti","Euskadi",2508818),("6th","Nicoya","G",8406723);
INSERT INTO location (district,city,province,population) VALUES ("3rd","Morrinsville","North Island",9612122),("8th","Warszawa","MA",2517464),("3rd","Vienna","Wi",8756715),("1st","Khandwa","MP",7510610),("2nd","Port Harcourt","RI",1012280),("8th","Wrocław","Dolnośląskie",4472543),("9th","Orlando","Florida",1019739),("4th","Ulloa (Barrial)","Heredia",4888479),("4th","Monmouth","MO",4647279),("9th","Saint-L?onard","New Brunswick",3492853);
INSERT INTO location (district,city,province,population) VALUES ("7th","Bulandshahr","UP",6380499),("10th","New Orleans","LA",9609295),("6th","Caucaia","Ceará",8702016),("2nd","Calestano","ER",1168316),("9th","Guilmi","Abruzzo",1278569),("9th","Frankfort","KY",3344967),("7th","Warspite","Alberta",3995446),("8th","Cairns","QL",6624689),("6th","Hilversum","N.",5587229),("7th","Hamburg","Hamburg",2216960);
INSERT INTO location (district,city,province,population) VALUES ("10th","Porbandar","GJ",6650154),("5th","Liberia","Guanacaste",1367669),("8th","Mores","SA",3109858),("5th","Muzaffarpur","Bihar",8690081),("3rd","Olsztyn","Warmińsko-mazurskie",7529545),("4th","Sneek","Fr",9065669),("10th","Jhansi","Uttar Pradesh",4627164),("5th","Dubbo","New South Wales",9257240),("2nd","Hartford","CT",5293522),("2nd","Hamburg","HH",7010116);
INSERT INTO location (district,city,province,population) VALUES ("4th","Posina","Veneto",2150094),("2nd","Duncan","British Columbia",7207122),("5th","Częstochowa","Sląskie",3526128),("1st","Chełm","Lubelskie",2566291),("6th","Barasat","WB",4093394),("6th","Hattiesburg","Mississippi",4740700),("3rd","Saharanpur","Uttar Pradesh",4952159),("8th","Rea","Lombardia",7298533),("7th","Liverpool","New South Wales",8937561),("2nd","Shreveport","LA",5729132);



INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Francesca Forbes",39,"1994-07-23",57),("Yardley Blankenship",21,"1955-04-29",42),("Bo Mccormick",51,"1991-08-28",35),("Ignacia Anderson",28,"1955-04-16",63),("Callie Bartlett",37,"1966-06-07",93),("Jana Sanford",41,"1993-06-23",20),("Ignatius Watson",54,"1992-11-02",59),("Magee Baxter",30,"1959-04-01",48),("Dillon Ortega",20,"1980-10-28",35),("Salvador Fuentes",30,"1968-09-18",17);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Deborah Maldonado",41,"1975-10-12",94),("Carolyn Reynolds",40,"1979-03-18",4),("Eagan Pacheco",34,"1972-03-01",63),("Reed Sexton",50,"1982-01-13",11),("Cecilia Reeves",47,"1993-07-19",14),("Lyle Justice",37,"1963-06-15",73),("Harlan Santiago",36,"1969-11-01",87),("Elton Phelps",60,"1966-02-19",5),("Lael Dominguez",40,"1985-07-07",58),("Dillon Doyle",36,"1955-08-20",28);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Lavinia Hensley",48,"1954-09-06",100),("Jackson Lucas",52,"1965-12-19",57),("Gary Ramsey",24,"1982-04-25",61),("Hayes Clark",32,"1986-06-24",36),("Hilary Johnston",45,"1971-11-29",53),("Destiny Holmes",57,"1990-02-26",62),("Ivory Cash",24,"1972-11-30",63),("Vivian Woodward",42,"1982-09-27",63),("Urielle Burt",31,"1980-03-13",68),("Hilary Maynard",28,"1976-01-22",80);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Sara Hernandez",28,"1991-01-12",99),("Kyle Boyd",46,"1967-02-18",74),("Dillon Henry",46,"1970-12-29",29),("Timon Bentley",35,"1984-09-27",4),("Clare Sykes",28,"1994-03-31",31),("Cailin Ferguson",46,"1973-04-09",76),("Xanthus Mullins",34,"1966-05-10",8),("Mira Robertson",34,"1980-06-08",13),("Wylie Whitehead",52,"1958-01-07",16),("Shay Mcdowell",48,"1970-01-24",45);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Shelley Gould",26,"1989-05-24",27),("Darryl Charles",36,"1982-06-07",35),("Shaine Good",38,"1974-09-09",74),("Lee Rollins",51,"1973-08-09",49),("Patrick Williams",41,"1988-06-30",55),("Ira Smith",40,"1975-01-17",43),("Vernon Joseph",58,"1977-03-18",7),("Tad Gonzalez",40,"1992-02-02",51),("Allen Miranda",24,"1957-04-18",96),("Stacy Lester",26,"1957-06-18",64);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Casey Rutledge",53,"1974-07-27",43),("Kitra Page",50,"1960-12-04",9),("Kenyon Porter",51,"1987-11-03",41),("Vivien Webster",38,"1980-10-17",11),("Robin Terry",45,"1994-04-23",8),("Omar French",34,"1983-08-06",56),("Pamela Thornton",45,"1955-07-14",23),("Driscoll Castillo",27,"1990-05-07",76),("Rafael Dotson",22,"1989-04-29",19),("Britanney Bean",50,"1969-08-13",15);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Natalie Hester",52,"1962-12-25",46),("Sasha Phelps",52,"1979-06-04",53),("Fuller Osborn",52,"1992-11-27",21),("Willow Wilson",53,"1968-12-23",28),("Keane Herrera",43,"1971-07-24",69),("Tyler Mcmahon",49,"1956-06-14",50),("Byron Woodard",35,"1980-10-24",58),("Sawyer Spence",54,"1967-06-30",40),("Emma Santiago",52,"1967-10-06",11),("Destiny Beach",34,"1975-08-13",89);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Tanya Ramsey",48,"1959-08-28",93),("Anjolie Stanley",45,"1992-11-27",39),("Fuller Pacheco",41,"1993-03-14",78),("Garrison Holt",52,"1975-03-04",21),("Celeste Fernandez",52,"1981-06-07",62),("Yoshi Dennis",59,"1966-10-31",71),("Willa Berry",33,"1987-11-12",17),("Chancellor Osborn",39,"1955-07-25",25),("Leandra Gardner",52,"1985-10-10",96),("Alexis Underwood",40,"1992-10-06",21);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Madaline Barr",53,"1957-09-16",73),("Cassandra Velasquez",42,"1982-06-03",52),("Timothy Lindsay",52,"1990-11-13",12),("Garrison Cannon",47,"1957-06-09",26),("Kaden Flynn",54,"1954-08-02",74),("Grace Ramirez",53,"1973-05-18",58),("Cameron Stanton",52,"1957-01-01",70),("Macaulay Chase",35,"1957-07-04",17),("Signe Petersen",60,"1983-08-24",93),("Evelyn Woodard",41,"1960-04-18",100);
INSERT INTO operator (name,age,birthdate,LOCATION_location_id) VALUES ("Rafael Lindsay",60,"1967-11-08",55),("Ebony Keller",34,"1976-07-08",65),("Kaden Snyder",24,"1957-10-22",33),("Ronan Townsend",38,"1962-02-02",43),("Damian Patel",49,"1978-06-24",20),("Darryl Haney",25,"1970-02-27",43),("Garrison Forbes",27,"1960-11-27",62),("Kelly Mcguire",34,"1982-12-19",13),("Yuli Smith",59,"1978-01-01",3),("Rooney Middleton",43,"1985-02-28",81);



INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2008-05-22",6,38,45),("2007-02-24",2,52,64),("2009-01-26",8,62,70),("2007-07-02",10,97,66),("2005-10-08",3,81,7),("2005-09-16",5,64,67),("2009-09-08",10,8,35),("2007-02-20",10,51,44),("2006-12-05",2,39,5),("2006-03-19",5,83,93);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2008-02-24",10,52,38),("2006-10-17",10,96,95),("2005-04-22",4,74,52),("2005-09-10",3,95,31),("2008-08-19",6,33,21),("2006-08-27",2,14,77),("2006-12-28",9,7,88),("2005-04-21",3,63,80),("2009-11-23",9,75,60),("2006-09-26",10,25,49);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2006-11-10",7,94,48),("2006-05-07",7,75,42),("2007-10-29",1,6,89),("2005-06-03",1,55,30),("2006-06-14",4,60,76),("2009-04-18",8,35,50),("2007-10-10",6,36,24),("2005-09-07",2,95,72),("2008-11-12",1,7,85),("2008-06-17",2,99,59);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2006-05-03",3,23,55),("2008-04-16",1,2,12),("2007-05-31",6,36,24),("2007-12-13",6,53,94),("2009-01-03",9,8,7),("2009-05-22",7,11,38),("2009-11-19",4,37,61),("2009-09-04",3,24,23),("2009-03-09",9,43,84),("2005-10-10",4,92,9);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2006-12-05",7,88,99),("2006-02-22",9,25,62),("2008-08-12",8,39,18),("2006-05-23",7,94,8),("2007-08-19",9,9,85),("2006-01-20",9,47,42),("2006-02-25",8,29,99),("2006-09-20",2,35,26),("2005-04-14",6,11,36),("2006-09-17",10,63,95);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2008-01-14",5,4,48),("2007-10-02",6,97,40),("2006-03-18",4,65,98),("2008-10-02",7,43,83),("2006-09-11",4,24,11),("2008-12-17",5,45,35),("2005-05-14",10,61,98),("2005-01-30",8,46,15),("2006-06-28",4,64,79),("2006-02-27",9,4,21);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2007-05-04",9,1,98),("2009-08-05",7,76,99),("2009-10-05",7,44,27),("2009-11-13",8,14,69),("2006-12-10",7,57,40),("2005-05-27",9,39,23),("2008-05-25",5,66,15),("2006-03-22",3,77,15),("2005-12-15",9,36,7),("2005-09-17",8,6,50);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2007-12-05",8,4,60),("2005-03-28",7,99,40),("2007-11-25",3,66,76),("2005-01-23",3,73,85),("2009-05-06",7,40,32),("2007-02-11",3,48,21),("2005-02-26",7,62,97),("2006-10-21",1,29,80),("2009-07-28",10,38,78),("2007-08-26",1,56,66);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2007-04-03",5,33,22),("2007-11-04",10,56,12),("2006-01-20",4,43,33),("2009-05-29",1,27,83),("2006-10-28",9,80,70),("2006-06-01",8,90,98),("2008-10-11",3,30,63),("2005-08-07",10,64,86),("2005-04-10",1,30,45),("2008-12-17",6,61,6);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2008-04-14",2,21,45),("2006-10-30",8,78,72),("2009-11-10",8,20,3),("2008-01-07",10,3,64),("2007-05-21",9,63,46),("2007-07-11",4,36,38),("2007-10-21",2,11,83),("2006-05-20",6,86,95),("2009-06-08",9,3,69),("2006-08-31",3,53,86);



INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Kalia Knox",59,"1983-03-04",4),("Burton Rose",48,"1986-08-11",4),("Dakota Collins",25,"1993-03-24",3),("Tarik Morrison",21,"1972-05-22",8),("Amity Guthrie",21,"1982-10-31",1),("Pascale Payne",59,"1979-07-23",8),("Gay Freeman",29,"1976-04-21",6),("Nicole Haley",27,"1992-05-22",3),("Sierra Floyd",39,"1970-05-02",2),("Gretchen Fisher",29,"1977-06-13",2);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Constance Soto",22,"1982-06-01",4),("Colt Powell",21,"1975-02-08",7),("Lana Robbins",48,"1955-03-28",6),("India Dodson",29,"1964-08-12",9),("Gannon Morris",45,"1987-07-31",9),("Alika Shepherd",30,"1966-03-20",4),("Blair Greer",23,"1975-05-18",10),("Regan Velazquez",54,"1957-10-15",5),("Dai Harding",48,"1965-02-08",3),("Aimee Shepherd",27,"1958-05-18",4);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Rooney Montoya",54,"1959-10-10",1),("Vivian Trujillo",24,"1960-11-07",1),("Erica Marsh",34,"1974-04-28",5),("Bethany Roman",40,"1988-02-18",2),("Abraham Wagner",30,"1991-08-13",1),("Wylie Peck",41,"1956-01-04",8),("Tarik Slater",47,"1960-05-29",3),("Maryam Russell",51,"1993-02-05",4),("Yetta Hatfield",40,"1974-05-31",5),("Dalton Bentley",46,"1967-04-11",9);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Leandra Cardenas",43,"1962-04-02",2),("Ashely Wall",53,"1968-01-14",8),("Louis Curtis",43,"1982-05-05",2),("Kareem Flores",58,"1961-05-23",1),("Daquan Armstrong",44,"1970-08-03",7),("Justina Sandoval",20,"1968-01-14",7),("Marshall Craft",26,"1961-02-12",7),("Jenette Duran",34,"1976-11-09",6),("Serena Martin",29,"1960-09-28",4),("Hayfa Gamble",44,"1969-11-18",5);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Claire Mcbride",20,"1964-01-17",6),("Beau Valdez",21,"1984-08-02",2),("Emerald Buckley",31,"1960-09-05",8),("Ria Grimes",59,"1972-07-30",7),("Zeph Lawson",24,"1989-02-12",10),("Anne Guerrero",25,"1965-04-21",8),("Nathan Black",23,"1962-06-28",1),("Mohammad Parsons",34,"1977-07-10",7),("Ray Reyes",45,"1962-08-02",10),("Ann Acevedo",60,"1991-09-13",5);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Olivia Mitchell",60,"1969-01-31",7),("Shay Sparks",29,"1959-10-19",2),("Nathan Mckay",33,"1994-07-05",7),("Chaim Dean",44,"1961-10-15",5),("Lacey Aguirre",48,"1957-09-09",8),("Hayden Jarvis",38,"1955-05-29",7),("Raphael Shaffer",43,"1993-10-09",1),("Karina Ryan",55,"1986-06-28",7),("Elijah Silva",39,"1964-06-30",10),("Laith Colon",58,"1959-03-22",5);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Rafael Valencia",45,"1958-06-08",8),("Maia Russo",37,"1993-03-25",6),("Jada Melton",52,"1984-01-05",7),("Clare Buchanan",47,"1982-07-23",5),("Juliet Kemp",54,"1960-03-11",8),("Jameson Lawson",35,"1986-09-16",9),("Omar Wiley",47,"1976-05-04",3),("Heidi Morgan",54,"1990-12-12",10),("Stuart Stein",27,"1981-04-18",8),("September Mendoza",46,"1960-08-17",9);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Valentine Gilbert",23,"1973-10-21",3),("Zephr Lara",21,"1988-08-27",2),("Lewis Franks",45,"1956-01-23",6),("Lee Graves",56,"1979-03-20",7),("Amaya Lowery",27,"1960-06-28",8),("Melvin Pate",24,"1963-09-22",2),("Rose Monroe",58,"1981-12-27",3),("Palmer Moss",38,"1971-05-24",6),("Ashton Potts",49,"1981-10-19",2),("Sierra Foreman",51,"1983-12-17",6);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Laith Coleman",47,"1962-04-29",7),("Wing Phelps",40,"1959-01-21",1),("Dora Quinn",40,"1982-05-18",6),("Tamara Guthrie",22,"1976-07-23",8),("Ingrid Cash",20,"1961-01-01",8),("Chanda Castaneda",31,"1958-09-16",10),("Reed Cochran",44,"1974-06-12",9),("Joshua Malone",41,"1974-09-10",9),("Maxwell Dejesus",59,"1985-09-09",3),("Dante Rosa",40,"1963-03-03",10);
INSERT INTO vendor (name,age,birthdate,VENDOR_TYPE_vendortype_id) VALUES ("Ross Schmidt",21,"1988-06-03",1),("Rafael Henderson",21,"1965-02-10",8),("Hedy Carpenter",40,"1982-03-13",5),("Chester Hunt",42,"1960-07-24",7),("Jesse Vasquez",40,"1960-03-23",9),("Christopher Guthrie",48,"1980-07-16",1),("Holmes Head",36,"1978-04-08",5),("Forrest Lyons",36,"1981-03-27",4),("Blythe Maldonado",42,"1993-07-23",9),("Gisela Mason",54,"1993-12-10",4);










INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-02-20",9,23,90),("2014-05-13",7,64,15),("2014-04-29",4,74,65),("2014-06-22",9,61,59),("2014-02-06",3,23,90),("2014-08-14",1,81,40),("2014-07-22",7,95,45),("2014-04-17",1,43,54),("2014-06-02",1,97,58),("2014-01-22",9,59,41);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-07-25",6,100,3),("2014-05-25",8,51,58),("2014-03-19",9,14,25),("2014-05-20",3,29,20),("2014-10-07",5,25,45),("2014-04-24",7,71,62),("2014-04-28",5,57,1),("2014-02-12",7,23,96),("2014-10-12",10,37,99),("2014-06-23",9,55,91);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-10-10",5,34,69),("2014-02-03",10,86,74),("2014-01-01",6,68,52),("2014-02-24",4,64,62),("2014-05-14",1,45,36),("2014-07-17",1,43,11),("2014-05-26",8,33,18),("2014-06-06",10,55,48),("2014-03-23",8,22,46),("2014-04-12",10,51,6);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-03-19",4,38,64),("2014-05-23",1,67,93),("2014-03-02",1,74,99),("2014-06-07",2,24,30),("2014-10-09",3,45,21),("2014-02-26",7,100,85),("2014-07-10",4,52,90),("2014-01-21",4,79,24),("2014-02-16",7,95,51),("2014-05-24",8,67,61);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-04-24",8,11,52),("2014-09-29",10,60,21),("2014-03-31",2,7,97),("2014-03-12",9,33,87),("2014-05-10",5,53,37),("2014-06-14",2,65,63),("2014-10-10",8,33,59),("2014-04-14",9,77,69),("2014-02-19",10,47,20),("2014-01-20",8,34,77);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-08-26",8,85,75),("2014-09-05",8,96,38),("2014-09-02",9,82,64),("2014-06-19",4,79,87),("2014-02-24",5,51,90),("2014-08-24",4,26,43),("2014-07-21",10,97,67),("2014-06-28",2,8,3),("2014-07-30",7,100,57),("2014-10-03",8,84,86);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-02-19",10,69,96),("2014-04-01",10,76,3),("2014-05-25",4,10,54),("2014-07-06",7,22,92),("2014-02-17",1,58,47),("2014-09-01",9,36,99),("2014-01-11",7,72,16),("2014-08-26",9,73,13),("2014-09-04",2,83,15),("2014-07-19",5,34,10);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-08-05",10,31,40),("2014-06-15",4,32,76),("2014-08-31",7,92,35),("2014-02-19",5,61,66),("2014-08-24",3,92,38),("2014-05-11",4,70,60),("2014-06-29",10,28,51),("2014-01-29",6,24,42),("2014-05-25",6,33,81),("2014-10-13",3,54,44);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-05-24",2,69,61),("2014-02-09",8,49,48),("2014-07-04",6,14,56),("2014-07-20",3,75,91),("2014-10-11",9,15,14),("2014-09-18",8,26,29),("2014-01-25",5,86,43),("2014-10-15",4,95,74),("2014-09-20",3,57,54),("2014-01-18",2,88,91);
INSERT INTO transaction (datetime,MENU_menu_id,VENDOR_vendor_id,CUSTOMER_customer_id) VALUES ("2014-06-27",9,21,95),("2014-04-29",7,46,94),("2014-09-26",2,35,5),("2014-03-19",7,33,27),("2014-04-22",3,79,6),("2014-04-28",4,26,53),("2014-09-22",2,22,15),("2014-10-14",1,53,43),("2014-03-01",8,80,15),("2014-10-08",9,19,85);
