text: CREATE DATABASE db_SalesTracking;
  
  DROP DATABASE db_SalesTracking;
  
  --Statements to allow creation and insertion
  USE db_SalesTracking
  GO
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  SET IDENTITY_INSERT BORROWER ON
  
  --Table creation with keys 
  drop table Customers cascade constraints;
  drop table Cards cascade constraints;
  drop table Games cascade constraints;
  drop table Publishers cascade constraints;
  drop table Employees cascade constraints;
  drop table Online_orders cascade constraints;
  drop table Local_sales cascade constraints;
  drop table Branches cascade constraints;
  drop table Warehouses cascade constraints;
  
  create table Customers (
      Cust_id Varchar2 (10),
      Cust_gender Varchar2 (10),
      Cust_name Varchar2 (40),
      Cust_address Varchar2 (40),
      Region Varchar2 (10),
      Cust_class Varchar2 (10),
      Cust_card_code Varchar2 (10),
      Prime Varchar2 (10),
      constraint Customers_pk primary key (Cust_id)
  );
  
  create table Cards (
      Card_id Varchar2 (10),
      Credit Number,
      Card_status Varchar2 (10),
      Act_date Date,
      Exp_date Date,
      constraint Cards_pk primary key (Card_id)
  );
  
  create table Games (
      Prod_id Varchar2 (10),
      Prod_name Varchar2 (40),
      Genre Varchar2 (20),
      Publisher Varchar2 (40),
      Dev_studio Varchar2 (40),
      PEGI_rating Varchar2 (10),
      Metacritic_score Number,
      Playtime Varchar2 (30),
      Edition Varchar2 (30),
      Retail_price Number,
      Wholesale_price Number,
      Max_profit_margin Number,
      Possible_discount Number,
      Monthly_sales Number,
      constraint Games_pk primary key (Prod_id)
  );
  
  create table Publishers (
      Publisher_name Varchar2(40),
      Publisher_cut Number,
      Publisher_sales Number,
      Publisher_stock Number,
      Publisher_demand Varchar2(10),
      constraint Publishers_pk primary key (Publisher_name)
  );
  
  create table Employees (
      Empl_id Varchar2(10),
      Empl_name Varchar2(40),
      Branch_id Varchar2(10),
      Status Varchar2(20),
      Base_sal Number,
      Commission Number,
      constraint Employees_pk primary key (Empl_id)
  );
  
  create table Online_orders (
      Ord_id Varchar2(10),
      Ord_date Date,
      Cust_id Varchar2(10),
      Prod_id Varchar2(10),
      Urgency Varchar2(10),
      Warehouse_id Varchar2(10),
      constraint Online_orders_pk primary key (Ord_id)
  );
  
  create table Local_sales (
      Sale_id Varchar2(10),
      Cust_id Varchar2(10),
      Sale_date Date,
      Prod_id Varchar2(10),
      Branch_id Varchar2(10),
      Empl_id Varchar2(10),
      constraint Local_sales_pk primary key (Sale_id)
  );
  
  create table Branches (
      Branch_id Varchar2(10),
      Region Varchar2(10),
      Manager_id Varchar2(10),
      Manager_salary Number,
      Sales Number,
      Util_cost Number,
      constraint Branches_pk primary key (Branch_id)
  );
  
  create table Warehouses (
      Warehouse_id Varchar2(10),
      Region Varchar2(10),
      Emp_num Number,
      Shipping Varchar2(10),
      constraint Warehouses_pk primary key (Warehouse_id)
  );
  
  
  insert into Customers values ('cust-001', 'Other', 'Klara Hammer', '38 Cornelius Place', 'CENTRAL', 'HIGH', null, 'NO');
  insert into Customers values ('cust-002', 'Other', 'Domingo Chan', '294 Chambers Square', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-003', 'Male', 'Neil Kincaid', '22 Emerson Avenue', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-004', 'Female', 'Sima Nielsen', '104 Ullman Lane', 'CENTRAL', 'HIGH', null, 'NO');
  insert into Customers values ('cust-005', 'Other', 'Kiyoko Ruiz', '110 Mcfadden Lane', 'CENTRAL', 'MED', 'crd_090', 'YES');
  insert into Customers values ('cust-006', 'Female', 'Constance Pierson', '25 Mcgraw Park', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-007', 'Other', 'Noma Hubble', '225 Felix Square', 'CENTRAL', 'LOW', 'crd_089', 'YES');
  insert into Customers values ('cust-008', 'Male', 'Rodolfo Caprioli', '96 Holbrook Park', 'NORTH', 'VIP', null, 'NO');
  insert into Customers values ('cust-009', 'Other', 'Ardell Barber', '98 Sargent Lane', 'NORTH', 'MED', 'crd_002', 'YES');
  insert into Customers values ('cust-010', 'Other', 'Sharell Farmer', '289 Becker Place', 'CENTRAL', 'VIP', null, 'NO');
  insert into Customers values ('cust-011', 'Other', 'Noma Whitman', '263 Raab Place', 'CENTRAL', 'LOW', null, 'YES');
  insert into Customers values ('cust-012', 'Female', 'Sheilah Sherwood', '271 Cooper Avenue', 'CENTRAL', 'VIP', null, 'YES');
  insert into Customers values ('cust-013', 'Male', 'Joel Hebert', '137 Hancock Street', 'EAST', 'HIGH', 'crd_058', 'YES');
  insert into Customers values ('cust-014', 'Male', 'Franklin Curry', '25 Kent Square', 'EAST', 'LOW', null, 'YES');
  insert into Customers values ('cust-015', 'Female', 'Christiane Randall', '60 Shannon Avenue', 'NORTH', 'VIP', 'crd_059', 'NO');
  insert into Customers values ('cust-016', 'Male', 'Brad Ng', '116 Triplett Lane', 'CENTRAL', 'VIP', 'crd_083', 'NO');
  insert into Customers values ('cust-017', 'Other', 'Ardell McClintock', '252 Nunez Square', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-018', 'Other', 'Ardell Crowell', '24 Velez Square', 'SOUTH', 'MED', null, 'NO');
  insert into Customers values ('cust-019', 'Female', 'Joeann Quinn', '48 Moon Street', 'SOUTH', 'MED', null, 'NO');
  insert into Customers values ('cust-020', 'Male', 'Jerrell Herzog', '16 Keith Street', 'CENTRAL', 'HIGH', null, 'NO');
  insert into Customers values ('cust-021', 'Male', 'Matt Simon', '106 Montano Place', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-022', 'Other', 'Noma Aragon', '123 Keats Park', 'CENTRAL', 'MED', null, 'YES');
  insert into Customers values ('cust-023', 'Male', 'Harley Dietz', '97 Berry Street', 'CENTRAL', 'HIGH', 'crd_080', 'NO');
  insert into Customers values ('cust-024', 'Male', 'Donnell Erickson', '83 Moser Street', 'EAST', 'LOW', null, 'NO');
  insert into Customers values ('cust-025', 'Male', 'Anibal Jewell', '132 Strickland Park', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-026', 'Other', 'Fabian Spader', '51 Brennan Lane', 'CENTRAL', 'VIP', null, 'NO');
  insert into Customers values ('cust-027', 'Other', 'Noma Childress', '23 Benton Street', 'NORTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-028', 'Other', 'Sharell Bitchum', '255 Callahan Square', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-029', 'Male', 'Basil Huang', '183 Phillips Place', 'NORTH', 'VIP', 'crd_019', 'YES');
  insert into Customers values ('cust-030', 'Other', 'Kiyoko Tyson', '294 Calvert Street', 'SOUTH', 'HIGH', null, 'YES');
  insert into Customers values ('cust-031', 'Male', 'Ashley Levy', '215 Wooten Street', 'CENTRAL', 'HIGH', null, 'YES');
  insert into Customers values ('cust-032', 'Other', 'Harlan Stallings', '124 Meyers Street', 'SOUTH', 'VIP', 'crd_041', 'NO');
  insert into Customers values ('cust-033', 'Male', 'Merlin Welsh', '288 Rosenthal Street', 'NORTH', 'HIGH', 'crd_048', 'YES');
  insert into Customers values ('cust-034', 'Other', 'Jeffery Kishel', '267 Frederick Avenue', 'WEST', 'VIP', null, 'NO');
  insert into Customers values ('cust-035', 'Female', 'Ekave Sinclair', '18 Corley Lane', 'CENTRAL', 'VIP', null, 'YES');
  insert into Customers values ('cust-036', 'Female', 'Olive Hill', '161 Souza Avenue', 'CENTRAL', 'MED', null, 'NO');
  insert into Customers values ('cust-037', 'Other', 'Teressa Marquez', '286 Wisser Place', 'CENTRAL', 'LOW', 'crd_013', 'NO');
  insert into Customers values ('cust-038', 'Female', 'Yolanda Newsome', '190 Crawford Lane', 'NORTH', 'VIP', null, 'YES');
  insert into Customers values ('cust-039', 'Other', 'Harlan Otto', '87 Morrison Avenue', 'SOUTH', 'HIGH', null, 'YES');
  insert into Customers values ('cust-040', 'Male', 'Long Boggs', '219 Hamm Lane', 'WEST', 'MED', 'crd_065', 'YES');
  insert into Customers values ('cust-041', 'Other', 'Teressa Weiss', '255 Jacobson Square', 'WEST', 'LOW', 'crd_017', 'NO');
  insert into Customers values ('cust-042', 'Female', 'Muriel Angel', '144 Pritchett Lane', 'SOUTH', 'VIP', 'crd_056', 'YES');
  insert into Customers values ('cust-043', 'Male', 'Nick Bradshaw', '268 Keys Square', 'SOUTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-044', 'Other', 'Domingo Hahnemann', '263 Halliburton Lane', 'EAST', 'MED', 'crd_032', 'YES');
  insert into Customers values ('cust-045', 'Female', 'Barbie Phillips', '192 Galis Place', 'WEST', 'MED', null, 'NO');
  insert into Customers values ('cust-046', 'Male', 'Gerry Leon', '97 Marin Place', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-047', 'Female', 'Vivian Park', '32 Hargrove Place', 'EAST', 'LOW', 'crd_076', 'YES');
  insert into Customers values ('cust-048', 'Other', 'Sharell Ricks', '5 Paulano Place', 'CENTRAL', 'HIGH', 'crd_097', 'NO');
  insert into Customers values ('cust-049', 'Female', 'Amparo Solano', '68 Medrano Avenue', 'EAST', 'MED', 'crd_006', 'YES');
  insert into Customers values ('cust-050', 'Other', 'Klara Juarez', '286 Dewitt Place', 'CENTRAL', 'VIP', null, 'YES');
  insert into Customers values ('cust-051', 'Other', 'Sharell Simpson', '37 Block Square', 'EAST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-052', 'Female', 'Pamela Miner', '258 Barnett Park', 'SOUTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-053', 'Male', 'Tony Huff', '122 Como Lane', 'WEST', 'VIP', null, 'NO');
  insert into Customers values ('cust-054', 'Male', 'Conrad Huff', '123 Song Place', 'NORTH', 'MED', 'crd_096', 'NO');
  insert into Customers values ('cust-055', 'Other', 'Domingo Little', '239 Whaley Square', 'EAST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-056', 'Other', 'Noma Pruitt', '247 Schwartz Avenue', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-057', 'Male', 'Stacy Como', '96 Lugo Place', 'SOUTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-058', 'Other', 'Harlan Kimsey', '3 Mansfield Avenue', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-059', 'Male', 'Leander Brock', '205 Walton Square', 'NORTH', 'VIP', 'crd_027', 'YES');
  insert into Customers values ('cust-060', 'Other', 'Harlan Austin', '63 Norris Lane', 'CENTRAL', 'VIP', 'crd_055', 'YES');
  insert into Customers values ('cust-061', 'Other', 'Domingo Vogel', '292 Simon Street', 'WEST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-062', 'Other', 'Noma Horner', '260 Dorsey Avenue', 'WEST', 'LOW', null, 'YES');
  insert into Customers values ('cust-063', 'Female', 'Lauren Frank', '199 Foreman Street', 'CENTRAL', 'MED', 'crd_042', 'YES');
  insert into Customers values ('cust-064', 'Male', 'Reiner Akers', '164 Leigh Lane', 'WEST', 'LOW', 'crd_036', 'NO');
  insert into Customers values ('cust-065', 'Male', 'Dante Cole', '154 Dribler Place', 'WEST', 'MED', null, 'NO');
  insert into Customers values ('cust-066', 'Other', 'Fabian Holden', '226 Dodge Park', 'WEST', 'LOW', null, 'YES');
  insert into Customers values ('cust-067', 'Male', 'Kirk Hightower', '206 Paulson Park', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-068', 'Other', 'Noma Prescott', '124 Gertheim Street', 'EAST', 'LOW', 'crd_031', 'NO');
  insert into Customers values ('cust-069', 'Other', 'Domingo Tedescho', '60 Proctor Square', 'EAST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-070', 'Male', 'Myles Briggs', '267 Gil Park', 'NORTH', 'VIP', null, 'YES');
  insert into Customers values ('cust-071', 'Male', 'Refugio Hepburn', '134 Oppenheimer Avenue', 'WEST', 'MED', 'crd_003', 'NO');
  insert into Customers values ('cust-072', 'Other', 'Sharell Kernos', '40 Paige Street', 'EAST', 'LOW', null, 'NO');
  insert into Customers values ('cust-073', 'Other', 'Ardell Bird', '240 Stabler Lane', 'NORTH', 'MED', null, 'NO');
  insert into Customers values ('cust-074', 'Male', 'Dick Sachs', '206 Coleman Park', 'NORTH', 'LOW', 'crd_044', 'YES');
  insert into Customers values ('cust-075', 'Male', 'Jo Dawkins', '38 Mcneil Lane', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-076', 'Male', 'Tony Tovar', '283 Richey Park', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-077', 'Male', 'Johnny Zimmer', '75 Houser Place', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-078', 'Other', 'Teressa Justice', '178 Pate Place', 'NORTH', 'MED', null, 'NO');
  insert into Customers values ('cust-079', 'Female', 'Lucille Duvall', '168 Rowland Avenue', 'NORTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-080', 'Male', 'Adolph DesCartes', '72 Levinson Park', 'EAST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-081', 'Male', 'Brant Lamb', '105 Becerra Lane', 'NORTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-082', 'Male', 'Michael Cassidy', '97 Conrad Lane', 'CENTRAL', 'HIGH', 'crd_072', 'NO');
  insert into Customers values ('cust-083', 'Female', 'Kirstin Polk', '230 Oppenheimer Lane', 'WEST', 'LOW', 'crd_020', 'YES');
  insert into Customers values ('cust-084', 'Female', 'Lula Armstrong', '144 Boyer Square', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-085', 'Female', 'Saundra Costello', '231 Dutch Square', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-086', 'Female', 'Meggan Ochoa', '287 Morton Avenue', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-087', 'Male', 'Marcel Barton', '225 Oleary Place', 'SOUTH', 'VIP', 'crd_040', 'YES');
  insert into Customers values ('cust-088', 'Other', 'Jeffery Myers', '11 Haywood Place', 'SOUTH', 'VIP', null, 'YES');
  insert into Customers values ('cust-089', 'Female', 'Mina Stevens', '203 Patel Park', 'NORTH', 'MED', null, 'NO');
  insert into Customers values ('cust-090', 'Female', 'Sasha Dillon', '103 Oaklie Street', 'WEST', 'VIP', null, 'NO');
  insert into Customers values ('cust-091', 'Female', 'Collette Forman', '150 Herring Avenue', 'EAST', 'LOW', null, 'NO');
  insert into Customers values ('cust-092', 'Male', 'Darin Rodrigues', '283 Leigh Avenue', 'CENTRAL', 'LOW', 'crd_078', 'NO');
  insert into Customers values ('cust-093', 'Female', 'Bobette Robbins', '0 Varela Avenue', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-094', 'Other', 'Sharell Moreno', '236 Vaughan Street', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-095', 'Male', 'Emile Simon', '227 Downey Park', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-096', 'Female', 'Rhiannon Langley', '115 Driscoll Lane', 'NORTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-097', 'Other', 'Klara Meade', '274 Parrish Place', 'EAST', 'LOW', null, 'YES');
  insert into Customers values ('cust-098', 'Other', 'Domingo Crowley', '211 Pickerton Street', 'CENTRAL', 'MED', null, 'NO');
  insert into Customers values ('cust-099', 'Male', 'Wesley Valentine', '16 Vernon Lane', 'SOUTH', 'VIP', null, 'NO');
  insert into Customers values ('cust-100', 'Other', 'Domingo Caper', '238 Valentine Square', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-101', 'Male', 'Dale Gray', '290 Montes Place', 'NORTH', 'MED', null, 'NO');
  insert into Customers values ('cust-102', 'Male', 'Grady Milligan', '5 Kirby Square', 'CENTRAL', 'VIP', null, 'NO');
  insert into Customers values ('cust-103', 'Male', 'Dorian Henson', '91 Branch Park', 'EAST', 'HIGH', 'crd_004', 'YES');
  insert into Customers values ('cust-104', 'Female', 'Khalilah Stanley', '74 Lin Street', 'SOUTH', 'HIGH', null, 'YES');
  insert into Customers values ('cust-105', 'Male', 'Quinn Bui', '80 Mack Lane', 'EAST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-106', 'Other', 'Kiyoko Galloway', '39 Moyer Square', 'EAST', 'MED', 'crd_099', 'NO');
  insert into Customers values ('cust-107', 'Female', 'Melissa Burton', '163 Riley Park', 'SOUTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-108', 'Female', 'Tia Poe', '62 Penn Square', 'WEST', 'LOW', null, 'YES');
  insert into Customers values ('cust-109', 'Male', 'Ivan Livingston', '155 Alford Park', 'WEST', 'VIP', null, 'YES');
  insert into Customers values ('cust-110', 'Female', 'Charlesetta Everett', '8 Stubbs Square', 'CENTRAL', 'VIP', null, 'YES');
  insert into Customers values ('cust-111', 'Female', 'Carissa Gilliam', '19 Alfaro Avenue', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-112', 'Male', 'Grover Walters', '174 Berensohn Lane', 'SOUTH', 'HIGH', 'crd_012', 'NO');
  insert into Customers values ('cust-113', 'Male', 'Benny Greenberg', '168 Crain Street', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-114', 'Other', 'Jeffery Panucci', '30 Ogden Street', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-115', 'Male', 'Menander Summers', '266 Pelletier Street', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-116', 'Male', 'Palmer Bethel', '92 Kuhn Lane', 'SOUTH', 'LOW', 'crd_069', 'NO');
  insert into Customers values ('cust-117', 'Other', 'Noma Regan', '157 Hartman Park', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-118', 'Female', 'Paula Ngo', '148 Walker Park', 'WEST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-119', 'Other', 'Jeffery Dejesus', '216 Ash Lane', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-120', 'Female', 'Yoshie Camp', '243 Mullen Place', 'WEST', 'LOW', null, 'YES');
  insert into Customers values ('cust-121', 'Other', 'Klara Werner', '74 Walker Square', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-122', 'Other', 'Harlan Bullard', '37 Fermi Park', 'EAST', 'MED', 'crd_005', 'YES');
  insert into Customers values ('cust-123', 'Other', 'Fabian Paredes', '61 Sweet Square', 'SOUTH', 'HIGH', 'crd_045', 'YES');
  insert into Customers values ('cust-124', 'Male', 'Eli Berry', '74 Nicholson Park', 'NORTH', 'LOW', 'crd_092', 'NO');
  insert into Customers values ('cust-125', 'Female', 'Merna Rowe', '40 Herbert Place', 'EAST', 'LOW', null, 'NO');
  insert into Customers values ('cust-126', 'Other', 'Domingo Welch', '292 Rubio Place', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-127', 'Male', 'Michal Santiago', '211 Engel Square', 'CENTRAL', 'MED', 'crd_043', 'YES');
  insert into Customers values ('cust-128', 'Female', 'Christia Paris', '273 Ostranski Place', 'CENTRAL', 'HIGH', null, 'YES');
  insert into Customers values ('cust-129', 'Female', 'Lisa Sears', '3 Towers Street', 'WEST', 'VIP', null, 'NO');
  insert into Customers values ('cust-130', 'Other', 'Harlan Brady', '124 Aquino Square', 'CENTRAL', 'VIP', null, 'YES');
  insert into Customers values ('cust-131', 'Female', 'Lula Hale', '67 Cruz Avenue', 'CENTRAL', 'LOW', null, 'NO');
  insert into Customers values ('cust-132', 'Male', 'Wesley Witt', '172 Lester Street', 'EAST', 'LOW', 'crd_068', 'YES');
  insert into Customers values ('cust-133', 'Female', 'Shanelle Butts', '290 Keys Place', 'NORTH', 'LOW', 'crd_038', 'NO');
  insert into Customers values ('cust-134', 'Other', 'Fabian Herrera', '58 Castillo Square', 'SOUTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-135', 'Other', 'Sharell Whitney', '107 Hilton Street', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-136', 'Male', 'Clark Fletcher', '21 Fritz Place', 'EAST', 'MED', 'crd_064', 'YES');
  insert into Customers values ('cust-137', 'Female', 'Cathy Milner', '167 Siegel Street', 'NORTH', 'LOW', 'crd_074', 'YES');
  insert into Customers values ('cust-138', 'Male', 'Ceanu Marks', '100 Bunkers Place', 'CENTRAL', 'LOW', 'crd_067', 'YES');
  insert into Customers values ('cust-139', 'Other', 'Domingo Gallardo', '129 Mcgrath Lane', 'SOUTH', 'VIP', 'crd_018', 'NO');
  insert into Customers values ('cust-140', 'Male', 'Bradly Blackburn', '145 McGuyver Lane', 'EAST', 'LOW', null, 'NO');
  insert into Customers values ('cust-141', 'Female', 'Lexi Odonnell', '172 Kemp Square', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-142', 'Other', 'Harlan Werner', '161 Morton Place', 'CENTRAL', 'LOW', null, 'YES');
  insert into Customers values ('cust-143', 'Male', 'Fidelio Pappas', '295 Banach Park', 'NORTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-144', 'Male', 'Werner Leonards', '195 Shearer Lane', 'CENTRAL', 'VIP', null, 'YES');
  insert into Customers values ('cust-145', 'Other', 'Jeffery Villalobos', '251 Dirac Street', 'CENTRAL', 'VIP', null, 'NO');
  insert into Customers values ('cust-146', 'Other', 'Ardell Reichstag', '54 Cheng Street', 'SOUTH', 'MED', null, 'NO');
  insert into Customers values ('cust-147', 'Other', 'Klara Friend', '242 Pittman Place', 'SOUTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-148', 'Other', 'Jeffery Moore', '213 Penn Park', 'WEST', 'HIGH', 'crd_022', 'YES');
  insert into Customers values ('cust-149', 'Female', 'Ryann Pyne', '14 Hurd Square', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-150', 'Female', 'Margarite Winter', '77 Mack Avenue', 'CENTRAL', 'HIGH', null, 'YES');
  insert into Customers values ('cust-151', 'Other', 'Ardell Garner', '33 Kessler Park', 'CENTRAL', 'HIGH', 'crd_001', 'NO');
  insert into Customers values ('cust-152', 'Other', 'Jeffery Vickers', '184 Leonards Place', 'SOUTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-153', 'Female', 'Theodora Raines', '79 Renault Square', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-154', 'Other', 'Klara Page', '291 Stewart Avenue', 'CENTRAL', 'MED', 'crd_077', 'NO');
  insert into Customers values ('cust-155', 'Female', 'Marylynn Cordova', '117 Sewell Lane', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-156', 'Male', 'Kyle Eddy', '137 Schultz Lane', 'WEST', 'VIP', null, 'NO');
  insert into Customers values ('cust-157', 'Female', 'Carmen Sapp', '30 Oakes Place', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-158', 'Other', 'Harlan Guy', '203 Lehman Lane', 'WEST', 'LOW', 'crd_025', 'YES');
  insert into Customers values ('cust-159', 'Other', 'Teressa Reed', '87 Westbrook Avenue', 'CENTRAL', 'HIGH', 'crd_084', 'YES');
  insert into Customers values ('cust-160', 'Female', 'Pa Turner', '101 Lockwood Avenue', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-161', 'Female', 'Albertha Lecter', '94 Mcwilliams Square', 'SOUTH', 'VIP', 'crd_061', 'YES');
  insert into Customers values ('cust-162', 'Other', 'Klara Cameron', '44 Small Place', 'SOUTH', 'LOW', 'crd_034', 'YES');
  insert into Customers values ('cust-163', 'Female', 'Lola Sellers', '192 De Agostini Park', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-164', 'Other', 'Harlan Aviles', '206 De Agostini Square', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-165', 'Male', 'Moses Cordero', '89 Prigogine Street', 'CENTRAL', 'HIGH', 'crd_071', 'NO');
  insert into Customers values ('cust-166', 'Other', 'Noma Baker', '154 Feldenkreis Lane', 'NORTH', 'VIP', null, 'YES');
  insert into Customers values ('cust-167', 'Other', 'Kiyoko Pinto', '47 Gould Place', 'SOUTH', 'VIP', 'crd_085', 'NO');
  insert into Customers values ('cust-168', 'Female', 'Marilyn Beasley', '194 Evangelista Park', 'WEST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-169', 'Female', 'Dione Sikorski', '197 Small Street', 'WEST', 'HIGH', 'crd_095', 'YES');
  insert into Customers values ('cust-170', 'Other', 'Noma Lancaster', '190 Landry Place', 'WEST', 'MED', null, 'NO');
  insert into Customers values ('cust-171', 'Other', 'Jeffery Andrade', '142 Shipley Square', 'CENTRAL', 'VIP', null, 'NO');
  insert into Customers values ('cust-172', 'Female', 'Andria Eckstein', '61 Carroll Square', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-173', 'Other', 'Teressa Manning', '74 John Park', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-174', 'Other', 'Teressa Maclaren', '94 Shearer Avenue', 'CENTRAL', 'MED', 'crd_007', 'NO');
  insert into Customers values ('cust-175', 'Female', 'Nicolle Jacob', '92 Reece Lane', 'NORTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-176', 'Female', 'Lizzie Hollis', '286 Hodge Place', 'SOUTH', 'LOW', 'crd_087', 'NO');
  insert into Customers values ('cust-177', 'Male', 'Denny Gomes', '116 Caprioli Square', 'CENTRAL', 'MED', 'crd_066', 'YES');
  insert into Customers values ('cust-178', 'Male', 'Ty Swain', '123 Quintero Avenue', 'NORTH', 'VIP', 'crd_021', 'YES');
  insert into Customers values ('cust-179', 'Other', 'Ardell Vinson', '269 Bingham Lane', 'EAST', 'MED', 'crd_062', 'YES');
  insert into Customers values ('cust-180', 'Other', 'Ardell Wilkes', '146 Richards Street', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-181', 'Female', 'Domenique Okeefe', '231 Paulson Avenue', 'WEST', 'HIGH', 'crd_079', 'NO');
  insert into Customers values ('cust-182', 'Female', 'Petrina Cash', '78 Levy Park', 'WEST', 'MED', 'crd_075', 'YES');
  insert into Customers values ('cust-183', 'Female', 'Mai Fontenot', '116 Fritz Square', 'EAST', 'LOW', null, 'YES');
  insert into Customers values ('cust-184', 'Other', 'Klara Messi', '47 Barker Square', 'SOUTH', 'VIP', null, 'NO');
  insert into Customers values ('cust-185', 'Male', 'Alberto Oakley', '129 Larson Square', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-186', 'Female', 'Eustolia Rodin', '48 Doty Lane', 'NORTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-187', 'Other', 'Domingo Bonner', '291 Beal Park', 'CENTRAL', 'LOW', 'crd_098', 'NO');
  insert into Customers values ('cust-188', 'Other', 'Sharell Fitzgerald', '79 Serna Square', 'SOUTH', 'MED', null, 'NO');
  insert into Customers values ('cust-189', 'Male', 'Gail Helm', '216 Adkins Square', 'EAST', 'VIP', 'crd_010', 'YES');
  insert into Customers values ('cust-190', 'Male', 'Valery Langston', '49 Wallace Avenue', 'CENTRAL', 'HIGH', null, 'NO');
  insert into Customers values ('cust-191', 'Female', 'Sachiko Rankin', '157 Kelly Avenue', 'CENTRAL', 'VIP', 'crd_051', 'NO');
  insert into Customers values ('cust-192', 'Other', 'Noma Stanford', '54 Taylor Park', 'EAST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-193', 'Female', 'Ronni Foreman', '207 Choi Square', 'CENTRAL', 'VIP', 'crd_047', 'NO');
  insert into Customers values ('cust-194', 'Other', 'Klara Vincent', '69 Goldman Street', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-195', 'Male', 'Rayan Maclaren', '274 Mulligan Street', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-196', 'Other', 'Noma Binder', '52 Crump Park', 'WEST', 'MED', 'crd_030', 'NO');
  insert into Customers values ('cust-197', 'Female', 'Loma Gilbert', '130 Felix Street', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-198', 'Male', 'Luther Tyler', '271 Navarro Street', 'NORTH', 'LOW', 'crd_033', 'NO');
  insert into Customers values ('cust-199', 'Other', 'Fabian Nash', '18 Carlton Street', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-200', 'Female', 'Brittny Reyna', '54 Arias Square', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-201', 'Other', 'Kiyoko Thurman', '154 Randolph Avenue', 'NORTH', 'LOW', 'crd_053', 'NO');
  insert into Customers values ('cust-202', 'Other', 'Fabian McCullough', '23 Page Lane', 'WEST', 'MED', null, 'NO');
  insert into Customers values ('cust-203', 'Male', 'Silas Oneil', '87 Craig Park', 'EAST', 'VIP', 'crd_050', 'NO');
  insert into Customers values ('cust-204', 'Female', 'Gwen Dwyer', '18 Hyde Place', 'EAST', 'MED', 'crd_039', 'NO');
  insert into Customers values ('cust-205', 'Female', 'Aisha Prater', '139 Dobbs Place', 'WEST', 'HIGH', 'crd_091', 'YES');
  insert into Customers values ('cust-206', 'Male', 'Gerard Tennet', '281 Leyva Lane', 'EAST', 'MED', null, 'NO');
  insert into Customers values ('cust-207', 'Other', 'Klara Wright', '114 Oppenheimer Lane', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-208', 'Female', 'Lolita Mcclure', '278 Valencia Park', 'SOUTH', 'HIGH', 'crd_029', 'NO');
  insert into Customers values ('cust-209', 'Male', 'Serge Floyd', '135 Tapia Street', 'NORTH', 'HIGH', 'crd_088', 'YES');
  insert into Customers values ('cust-210', 'Other', 'Kiyoko Morton', '220 Overton Place', 'SOUTH', 'VIP', null, 'NO');
  insert into Customers values ('cust-211', 'Male', 'Fredrick Cardona', '81 Powers Park', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-212', 'Male', 'Keenan Farmer', '117 Neal Avenue', 'EAST', 'LOW', null, 'YES');
  insert into Customers values ('cust-213', 'Female', 'Bailey Saunders', '228 Putnam Square', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-214', 'Male', 'Joaquin Gaston', '101 Chang Street', 'EAST', 'LOW', null, 'YES');
  insert into Customers values ('cust-215', 'Male', 'Nestor Milligan', '2 Caprioli Street', 'SOUTH', 'MED', null, 'NO');
  insert into Customers values ('cust-216', 'Male', 'Matt Fountain', '172 Hinton Street', 'NORTH', 'LOW', 'crd_026', 'NO');
  insert into Customers values ('cust-217', 'Female', 'Jayne Pauley', '298 Steiner Street', 'NORTH', 'HIGH', 'crd_093', 'YES');
  insert into Customers values ('cust-218', 'Male', 'Shane Snow', '201 Sorensen Park', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-219', 'Other', 'Noma Porsche', '297 Goode Place', 'WEST', 'LOW', 'crd_100', 'NO');
  insert into Customers values ('cust-220', 'Female', 'Callie Tolbert', '11 Booth Place', 'EAST', 'MED', null, 'YES');
  insert into Customers values ('cust-221', 'Male', 'Jo Thomas', '292 Erwin Place', 'CENTRAL', 'MED', null, 'NO');
  insert into Customers values ('cust-222', 'Male', 'Walter Hendrickson', '192 Guillet Park', 'CENTRAL', 'VIP', 'crd_008', 'YES');
  insert into Customers values ('cust-223', 'Female', 'Ta Pineiro', '91 Calvert Place', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-224', 'Male', 'James Mcbride', '140 Olvera Lane', 'SOUTH', 'MED', 'crd_054', 'YES');
  insert into Customers values ('cust-225', 'Male', 'Wilton Pavlov', '233 Simons Place', 'SOUTH', 'MED', null, 'NO');
  insert into Customers values ('cust-226', 'Female', 'Annabell Roche', '295 Mead Place', 'WEST', 'MED', null, 'NO');
  insert into Customers values ('cust-227', 'Other', 'Domingo Longworth', '278 Justice Square', 'CENTRAL', 'HIGH', null, 'YES');
  insert into Customers values ('cust-228', 'Male', 'Lon Wells', '207 Waller Square', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-229', 'Other', 'Teressa Boucher', '108 Figueroa Place', 'EAST', 'LOW', null, 'YES');
  insert into Customers values ('cust-230', 'Male', 'Mauricio Hartman', '293 Salgado Street', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-231', 'Female', 'Sallie Wesley', '283 Dalton Place', 'EAST', 'MED', null, 'NO');
  insert into Customers values ('cust-232', 'Other', 'Noma Huynh', '111 Bowman Avenue', 'EAST', 'VIP', 'crd_024', 'YES');
  insert into Customers values ('cust-233', 'Female', 'Youlanda Benedict', '177 Hamm Square', 'WEST', 'VIP', 'crd_082', 'NO');
  insert into Customers values ('cust-234', 'Other', 'Kiyoko Hammer', '126 Hughes Avenue', 'SOUTH', 'MED', null, 'YES');
  insert into Customers values ('cust-235', 'Female', 'Seema Landers', '45 Clifford Park', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-236', 'Male', 'Vzevolod Bright', '51 Williamson Place', 'NORTH', 'HIGH', null, 'YES');
  insert into Customers values ('cust-237', 'Female', 'Meghann Wainwright', '26 Pruitt Street', 'NORTH', 'LOW', 'crd_094', 'YES');
  insert into Customers values ('cust-238', 'Male', 'Louie Nelson', '146 Broussard Place', 'CENTRAL', 'LOW', 'crd_086', 'NO');
  insert into Customers values ('cust-239', 'Other', 'Noma Wisser', '86 Deleon Street', 'SOUTH', 'MED', 'crd_063', 'YES');
  insert into Customers values ('cust-240', 'Male', 'Edwin Davidson', '113 Gallegos Street', 'SOUTH', 'VIP', 'crd_014', 'YES');
  insert into Customers values ('cust-241', 'Female', 'LeeAnne Salgado', '295 Hopper Place', 'SOUTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-242', 'Female', 'Angla Hirsch', '177 Christie Avenue', 'EAST', 'VIP', null, 'NO');
  insert into Customers values ('cust-243', 'Male', 'Orlando Cruz', '116 Wright Lane', 'EAST', 'VIP', null, 'YES');
  insert into Customers values ('cust-244', 'Female', 'Marisa Mcdaniel', '35 Burkett Lane', 'CENTRAL', 'HIGH', null, 'YES');
  insert into Customers values ('cust-245', 'Female', 'Astarte Beyer', '157 Casillas Lane', 'CENTRAL', 'LOW', 'crd_028', 'YES');
  insert into Customers values ('cust-246', 'Female', 'Joann Hanley', '245 Mikasa Park', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-247', 'Male', 'Geoffrey Christiansen', '129 Mcneill Lane', 'WEST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-248', 'Male', 'Zbig Compton', '225 Bolden Place', 'SOUTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-249', 'Male', 'Emmett Stephenson', '73 Chisholm Place', 'WEST', 'MED', 'crd_037', 'YES');
  insert into Customers values ('cust-250', 'Female', 'Jeanett Diaz', '131 Fleming Street', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-251', 'Male', 'Rolf Allison', '131 Houser Square', 'SOUTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-252', 'Male', 'Teodoro Ellis', '278 Dunham Park', 'WEST', 'VIP', null, 'YES');
  insert into Customers values ('cust-253', 'Male', 'Pepito Sheehan', '147 Glover Street', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-254', 'Female', 'Nickie Song', '205 Towers Lane', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-255', 'Other', 'Domingo Levin', '256 Porter Lane', 'WEST', 'LOW', 'crd_015', 'NO');
  insert into Customers values ('cust-256', 'Other', 'Noma York', '50 Saldana Place', 'WEST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-257', 'Female', 'Lori Stone', '138 Benoit Park', 'WEST', 'VIP', null, 'NO');
  insert into Customers values ('cust-258', 'Male', 'Jerald Craft', '185 Souza Avenue', 'NORTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-259', 'Male', 'Willian Delaney', '33 Hines Avenue', 'CENTRAL', 'MED', null, 'YES');
  insert into Customers values ('cust-260', 'Other', 'Domingo Peoples', '33 Wiseman Square', 'EAST', 'HIGH', 'crd_057', 'YES');
  insert into Customers values ('cust-261', 'Other', 'Sharell Rankin', '90 Pritchett Square', 'WEST', 'MED', null, 'YES');
  insert into Customers values ('cust-262', 'Other', 'Ardell Cheltenham', '123 Kessler Park', 'WEST', 'MED', 'crd_035', 'NO');
  insert into Customers values ('cust-263', 'Female', 'Marina Wilhelm', '162 Briggs Place', 'EAST', 'MED', null, 'NO');
  insert into Customers values ('cust-264', 'Male', 'Fermin Horn', '239 Nash Park', 'CENTRAL', 'HIGH', null, 'YES');
  insert into Customers values ('cust-265', 'Female', 'Cherise Dodge', '184 Markov Avenue', 'CENTRAL', 'LOW', null, 'NO');
  insert into Customers values ('cust-266', 'Male', 'Pafnuti Lindsay', '241 Emerald Place', 'NORTH', 'HIGH', 'crd_009', 'YES');
  insert into Customers values ('cust-267', 'Other', 'Kiyoko Plummer', '116 Starks Square', 'CENTRAL', 'HIGH', null, 'NO');
  insert into Customers values ('cust-268', 'Other', 'Sharell Diaz', '242 Mcallister Place', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-269', 'Male', 'Ludwig Ogden', '120 Samuel Street', 'NORTH', 'MED', null, 'YES');
  insert into Customers values ('cust-270', 'Female', 'Tasia Pritchard', '84 Tedescho Street', 'WEST', 'LOW', null, 'NO');
  insert into Customers values ('cust-271', 'Female', 'Shannon Springer', '176 Hobbs Place', 'SOUTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-272', 'Male', 'Jarrett Hutchison', '257 Conley Park', 'EAST', 'HIGH', 'crd_081', 'YES');
  insert into Customers values ('cust-273', 'Female', 'Dahlia Nguyen', '24 Gay Avenue', 'SOUTH', 'VIP', null, 'NO');
  insert into Customers values ('cust-274', 'Male', 'Lasse Rossini', '215 Burnett Street', 'WEST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-275', 'Female', 'Minnie Alfaro', '268 Jewell Lane', 'WEST', 'VIP', 'crd_023', 'NO');
  insert into Customers values ('cust-276', 'Female', 'Annetta Mansfield', '155 Moore Square', 'SOUTH', 'LOW', 'crd_073', 'NO');
  insert into Customers values ('cust-277', 'Other', 'Fabian Novak', '117 Deleon Street', 'EAST', 'MED', null, 'NO');
  insert into Customers values ('cust-278', 'Male', 'Francis Dickens', '107 Pinto Park', 'CENTRAL', 'MED', 'crd_046', 'YES');
  insert into Customers values ('cust-279', 'Male', 'Reid Dennis', '47 Dijkstra Avenue', 'WEST', 'VIP', null, 'YES');
  insert into Customers values ('cust-280', 'Male', 'Matt McCullough', '131 Gunn Lane', 'NORTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-281', 'Male', 'Isaias Vogt', '5 Mccollum Avenue', 'SOUTH', 'HIGH', null, 'NO');
  insert into Customers values ('cust-282', 'Other', 'Harlan Rooney', '63 Cain Avenue', 'CENTRAL', 'MED', null, 'YES');
  insert into Customers values ('cust-283', 'Other', 'Jeffery Cruz', '237 Lanceberger Square', 'WEST', 'HIGH', null, 'NO');
  insert into Customers values ('cust-284', 'Female', 'Filomena Sorensen', '271 Dickey Avenue', 'CENTRAL', 'MED', null, 'YES');
  insert into Customers values ('cust-285', 'Male', 'Jasper Kendall', '131 Phelps Street', 'WEST', 'VIP', null, 'YES');
  insert into Customers values ('cust-286', 'Female', 'Shanna Croft', '171 Drummond Square', 'SOUTH', 'LOW', 'crd_049', 'YES');
  insert into Customers values ('cust-287', 'Male', 'Damian Omalley', '157 Byrd Place', 'CENTRAL', 'VIP', 'crd_016', 'YES');
  insert into Customers values ('cust-288', 'Other', 'Jeffery Singleton', '147 DesCartes Avenue', 'WEST', 'LOW', null, 'YES');
  insert into Customers values ('cust-289', 'Male', 'Jackie Fletcher', '298 Vega Street', 'NORTH', 'VIP', null, 'NO');
  insert into Customers values ('cust-290', 'Male', 'Horacio Stapleton', '247 Chin Avenue', 'EAST', 'MED', 'crd_011', 'NO');
  insert into Customers values ('cust-291', 'Other', 'Kiyoko Douglas', '102 Wheeler Place', 'WEST', 'MED', null, 'NO');
  insert into Customers values ('cust-292', 'Other', 'Kiyoko Weaver', '148 Sapp Avenue', 'EAST', 'VIP', 'crd_052', 'YES');
  insert into Customers values ('cust-293', 'Male', 'Lester Vickers', '64 Crouch Street', 'WEST', 'MED', 'crd_060', 'NO');
  insert into Customers values ('cust-294', 'Female', 'Mary Willis', '72 Manakis Park', 'NORTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-295', 'Male', 'Kurtis Dodge', '270 Dalton Square', 'SOUTH', 'VIP', null, 'YES');
  insert into Customers values ('cust-296', 'Female', 'Petrina Duvall', '16 Crane Place', 'NORTH', 'LOW', null, 'NO');
  insert into Customers values ('cust-297', 'Female', 'Elizabet Inman', '11 Doherty Park', 'SOUTH', 'VIP', null, 'YES');
  insert into Customers values ('cust-298', 'Female', 'Sheilah Dewitt', '299 Raab Street', 'NORTH', 'LOW', null, 'YES');
  insert into Customers values ('cust-299', 'Female', 'Niesha Chong', '121 Battle Place', 'EAST', 'HIGH', null, 'YES');
  insert into Customers values ('cust-300', 'Other', 'Teressa Winkler', '230 Sherwood Avenue', 'CENTRAL', 'MED', 'crd_070', 'NO');
  
  
  insert into Cards values ('crd_001', 3360, 'INACTIVE', '12-Jul-2019', '07-Apr-2022');
  insert into Cards values ('crd_002', 9007, 'INACTIVE', '11-Mar-2020', '06-Dec-2022');
  insert into Cards values ('crd_003', 1477, 'INACTIVE', '25-Jan-2020', '21-Oct-2022');
  insert into Cards values ('crd_004', 4687, 'INACTIVE', '25-Jan-2019', '21-Oct-2021');
  insert into Cards values ('crd_005', 4526, 'INACTIVE', '22-Jan-2018', '18-Oct-2020');
  insert into Cards values ('crd_006', 9191, 'ACTIVE', '14-Aug-2019', '10-May-2022');
  insert into Cards values ('crd_007', 5425, 'ACTIVE', '23-Nov-2020', '20-Aug-2023');
  insert into Cards values ('crd_008', 9750, 'ACTIVE', '06-Apr-2019', '31-Dec-2021');
  insert into Cards values ('crd_009', 2412, 'ACTIVE', '07-Nov-2019', '03-Aug-2022');
  insert into Cards values ('crd_010', 5407, 'ACTIVE', '19-Jun-2019', '15-Mar-2022');
  insert into Cards values ('crd_011', 4899, 'ACTIVE', '19-Mar-2018', '13-Dec-2020');
  insert into Cards values ('crd_012', 9202, 'INACTIVE', '26-Mar-2018', '20-Dec-2020');
  insert into Cards values ('crd_013', 2657, 'INACTIVE', '27-Apr-2019', '21-Jan-2022');
  insert into Cards values ('crd_014', 8996, 'INACTIVE', '24-Apr-2018', '18-Jan-2021');
  insert into Cards values ('crd_015', 3064, 'ACTIVE', '04-Feb-2018', '31-Oct-2020');
  insert into Cards values ('crd_016', 9648, 'ACTIVE', '06-May-2018', '30-Jan-2021');
  insert into Cards values ('crd_017', 7893, 'INACTIVE', '07-Mar-2020', '02-Dec-2022');
  insert into Cards values ('crd_018', 872, 'INACTIVE', '27-Dec-2020', '23-Sep-2023');
  insert into Cards values ('crd_019', 6082, 'ACTIVE', '28-Apr-2019', '22-Jan-2022');
  insert into Cards values ('crd_020', 4593, 'ACTIVE', '28-Mar-2018', '22-Dec-2020');
  insert into Cards values ('crd_021', 7681, 'INACTIVE', '04-Sep-2020', '01-Jun-2023');
  insert into Cards values ('crd_022', 1117, 'INACTIVE', '18-Jul-2019', '13-Apr-2022');
  insert into Cards values ('crd_023', 4803, 'ACTIVE', '20-Jun-2020', '17-Mar-2023');
  insert into Cards values ('crd_024', 3780, 'INACTIVE', '17-Aug-2019', '13-May-2022');
  insert into Cards values ('crd_025', 7655, 'ACTIVE', '02-May-2018', '26-Jan-2021');
  insert into Cards values ('crd_026', 9984, 'INACTIVE', '15-Jul-2020', '11-Apr-2023');
  insert into Cards values ('crd_027', 8500, 'INACTIVE', '31-Oct-2020', '28-Jul-2023');
  insert into Cards values ('crd_028', 8200, 'ACTIVE', '28-May-2019', '21-Feb-2022');
  insert into Cards values ('crd_029', 2863, 'ACTIVE', '29-Sep-2018', '25-Jun-2021');
  insert into Cards values ('crd_030', 1478, 'ACTIVE', '09-Feb-2020', '05-Nov-2022');
  insert into Cards values ('crd_031', 2020, 'INACTIVE', '29-Apr-2019', '23-Jan-2022');
  insert into Cards values ('crd_032', 1718, 'INACTIVE', '16-Jul-2018', '11-Apr-2021');
  insert into Cards values ('crd_033', 5043, 'ACTIVE', '03-Dec-2020', '30-Aug-2023');
  insert into Cards values ('crd_034', 2603, 'INACTIVE', '22-May-2020', '16-Feb-2023');
  insert into Cards values ('crd_035', 4277, 'ACTIVE', '25-May-2019', '18-Feb-2022');
  insert into Cards values ('crd_036', 2738, 'INACTIVE', '15-Sep-2019', '11-Jun-2022');
  insert into Cards values ('crd_037', 3151, 'ACTIVE', '05-Jul-2019', '31-Mar-2022');
  insert into Cards values ('crd_038', 9271, 'ACTIVE', '05-Oct-2018', '01-Jul-2021');
  insert into Cards values ('crd_039', 8907, 'INACTIVE', '27-Oct-2020', '24-Jul-2023');
  insert into Cards values ('crd_040', 9006, 'INACTIVE', '28-Dec-2019', '23-Sep-2022');
  insert into Cards values ('crd_041', 2682, 'ACTIVE', '21-Jun-2018', '17-Mar-2021');
  insert into Cards values ('crd_042', 8426, 'INACTIVE', '21-Jan-2019', '17-Oct-2021');
  insert into Cards values ('crd_043', 8802, 'ACTIVE', '19-Apr-2020', '14-Jan-2023');
  insert into Cards values ('crd_044', 7055, 'ACTIVE', '10-Oct-2020', '07-Jul-2023');
  insert into Cards values ('crd_045', 8425, 'INACTIVE', '06-Jul-2020', '02-Apr-2023');
  insert into Cards values ('crd_046', 6723, 'INACTIVE', '17-Dec-2020', '13-Sep-2023');
  insert into Cards values ('crd_047', 9295, 'INACTIVE', '27-Aug-2018', '23-May-2021');
  insert into Cards values ('crd_048', 5598, 'INACTIVE', '26-Jan-2020', '22-Oct-2022');
  insert into Cards values ('crd_049', 2374, 'ACTIVE', '16-Jan-2020', '12-Oct-2022');
  insert into Cards values ('crd_050', 5814, 'ACTIVE', '04-Jun-2018', '28-Feb-2021');
  insert into Cards values ('crd_051', 3727, 'INACTIVE', '07-Jul-2018', '02-Apr-2021');
  insert into Cards values ('crd_052', 5107, 'ACTIVE', '13-Jun-2018', '09-Mar-2021');
  insert into Cards values ('crd_053', 3640, 'INACTIVE', '14-Jul-2019', '09-Apr-2022');
  insert into Cards values ('crd_054', 4776, 'ACTIVE', '17-Mar-2018', '11-Dec-2020');
  insert into Cards values ('crd_055', 1564, 'INACTIVE', '08-Dec-2018', '03-Sep-2021');
  insert into Cards values ('crd_056', 817, 'ACTIVE', '11-Jul-2019', '06-Apr-2022');
  insert into Cards values ('crd_057', 4659, 'INACTIVE', '14-May-2019', '07-Feb-2022');
  insert into Cards values ('crd_058', 9361, 'INACTIVE', '05-Jul-2019', '31-Mar-2022');
  insert into Cards values ('crd_059', 7798, 'ACTIVE', '25-Apr-2020', '20-Jan-2023');
  insert into Cards values ('crd_060', 5219, 'ACTIVE', '05-Jul-2019', '31-Mar-2022');
  insert into Cards values ('crd_061', 3191, 'ACTIVE', '25-Mar-2018', '19-Dec-2020');
  insert into Cards values ('crd_062', 7559, 'ACTIVE', '12-Nov-2020', '09-Aug-2023');
  insert into Cards values ('crd_063', 7185, 'INACTIVE', '20-Dec-2018', '15-Sep-2021');
  insert into Cards values ('crd_064', 3608, 'ACTIVE', '13-Dec-2020', '09-Sep-2023');
  insert into Cards values ('crd_065', 1105, 'ACTIVE', '12-Aug-2020', '09-May-2023');
  insert into Cards values ('crd_066', 6984, 'INACTIVE', '13-Nov-2020', '10-Aug-2023');
  insert into Cards values ('crd_067', 4376, 'INACTIVE', '18-Sep-2019', '14-Jun-2022');
  insert into Cards values ('crd_068', 6598, 'INACTIVE', '01-Nov-2019', '28-Jul-2022');
  insert into Cards values ('crd_069', 7938, 'ACTIVE', '27-Apr-2020', '22-Jan-2023');
  insert into Cards values ('crd_070', 3389, 'ACTIVE', '06-Aug-2019', '02-May-2022');
  insert into Cards values ('crd_071', 2359, 'INACTIVE', '11-Dec-2019', '06-Sep-2022');
  insert into Cards values ('crd_072', 6858, 'ACTIVE', '12-Sep-2018', '08-Jun-2021');
  insert into Cards values ('crd_073', 4262, 'ACTIVE', '02-Dec-2018', '28-Aug-2021');
  insert into Cards values ('crd_074', 31, 'INACTIVE', '19-Oct-2019', '15-Jul-2022');
  insert into Cards values ('crd_075', 691, 'ACTIVE', '23-Nov-2018', '19-Aug-2021');
  insert into Cards values ('crd_076', 9566, 'ACTIVE', '31-Jan-2019', '27-Oct-2021');
  insert into Cards values ('crd_077', 5125, 'ACTIVE', '02-Apr-2018', '27-Dec-2020');
  insert into Cards values ('crd_078', 1669, 'INACTIVE', '18-Dec-2020', '14-Sep-2023');
  insert into Cards values ('crd_079', 1852, 'ACTIVE', '01-Sep-2018', '28-May-2021');
  insert into Cards values ('crd_080', 7199, 'INACTIVE', '08-Jul-2018', '03-Apr-2021');
  insert into Cards values ('crd_081', 4138, 'INACTIVE', '22-Sep-2018', '18-Jun-2021');
  insert into Cards values ('crd_082', 9780, 'ACTIVE', '14-Mar-2018', '08-Dec-2020');
  insert into Cards values ('crd_083', 5035, 'ACTIVE', '14-Jan-2018', '10-Oct-2020');
  insert into Cards values ('crd_084', 2561, 'INACTIVE', '01-Jan-2019', '27-Sep-2021');
  insert into Cards values ('crd_085', 4259, 'INACTIVE', '20-Feb-2019', '16-Nov-2021');
  insert into Cards values ('crd_086', 2017, 'ACTIVE', '17-Sep-2018', '13-Jun-2021');
  insert into Cards values ('crd_087', 1413, 'INACTIVE', '22-Mar-2018', '16-Dec-2020');
  insert into Cards values ('crd_088', 8928, 'INACTIVE', '30-Dec-2019', '25-Sep-2022');
  insert into Cards values ('crd_089', 2565, 'INACTIVE', '25-Sep-2020', '22-Jun-2023');
  insert into Cards values ('crd_090', 9317, 'ACTIVE', '26-Sep-2020', '23-Jun-2023');
  insert into Cards values ('crd_091', 1253, 'ACTIVE', '07-Jan-2020', '03-Oct-2022');
  insert into Cards values ('crd_092', 7997, 'ACTIVE', '01-Feb-2018', '28-Oct-2020');
  insert into Cards values ('crd_093', 1630, 'INACTIVE', '05-Nov-2020', '02-Aug-2023');
  insert into Cards values ('crd_094', 8249, 'ACTIVE', '29-Apr-2020', '24-Jan-2023');
  insert into Cards values ('crd_095', 2185, 'ACTIVE', '24-Aug-2020', '21-May-2023');
  insert into Cards values ('crd_096', 6181, 'INACTIVE', '24-Jan-2018', '20-Oct-2020');
  insert into Cards values ('crd_097', 6253, 'ACTIVE', '12-Oct-2019', '08-Jul-2022');
  insert into Cards values ('crd_098', 6669, 'INACTIVE', '11-Feb-2019', '07-Nov-2021');
  insert into Cards values ('crd_099', 7883, 'ACTIVE', '19-Aug-2019', '15-May-2022');
  insert into Cards values ('crd_100', 3276, 'ACTIVE', '17-Jan-2020', '13-Oct-2022');
  
  
  insert into Games values ('Prod-001', 'Red Omen', 'Action', 'Surprisystems', 'Blind Raccoon Productions', 'PEGI-12', 68, '37 Hours', 'Collector', 120, 66, 0.45, 0.4, 310);
  insert into Games values ('Prod-002', 'Titan Carnage', 'Action', 'Cliff Acoustics', 'Golden Boa Interactive', 'PEGI-12', 73, '46 Hours', 'Standard', 30, 24, 0.2, 0.1, 741);
  insert into Games values ('Prod-003', 'Pillage of Opportunity', 'Action', 'Lionshine', 'Thunderstorm Studios', 'PEGI-3', 91, '8 Hours', 'Deluxe', 50, 35, 0.3, 0.4, 333);
  insert into Games values ('Prod-004', 'Vengeance of Trickery', 'Action', 'Fairyhive', 'Thunderstorm Studios', 'PEGI-3', 90, '71 Hours', 'Collector', 280, 154, 0.45, 0, 944);
  insert into Games values ('Prod-005', 'Ghosts and Command', 'Action', 'Alphacom', 'Dumb Luck Entertainment', 'PEGI-3', 86, '23 Hours', 'Standard', 30, 24, 0.2, 0.75, 63);
  insert into Games values ('Prod-006', 'Duty and Control', 'Action', 'Fairyhive', 'Filthy Door Interactive', 'PEGI-3', 77, '65 Hours', 'Standard', 50, 40, 0.2, 0.4, 429);
  insert into Games values ('Prod-007', 'Farforce', 'Action', 'Diamond Media', 'Numb Kitten Productions', 'PEGI-7', 99, '25 Hours', 'Standard', 50, 40, 0.2, 0.1, 767);
  insert into Games values ('Prod-008', 'Blueborne', 'Action', 'Crypticorps', 'Winterpunch Game Studios', 'PEGI-12', 89, '58 Hours', 'Gold', 100, 65, 0.35, 0.4, 448);
  insert into Games values ('Prod-009', 'Everrain', 'Action', 'Diamond Media', 'Scary Lizard Productions', 'PEGI-16', 69, '68 Hours', 'Deluxe', 50, 35, 0.3, 0.75, 220);
  insert into Games values ('Prod-010', 'Antilust', 'Action', 'Heartpoint', 'Dumb Luck Entertainment', 'PEGI-16', 60, '19 Hours', 'Collector', 240, 132, 0.45, 0.75, 258);
  insert into Games values ('Prod-011', 'Heroic Legacy', 'Adventure', 'Alphacom', 'Golden Boa Interactive', 'PEGI-7', 78, '45 Hours', 'Collector', 170, 93.5, 0.45, 0.4, 360);
  insert into Games values ('Prod-012', 'Dark Sect', 'Adventure', 'Crypticorps', 'Filthy Door Interactive', 'PEGI-3', 72, '25 Hours', 'Collector', 180, 99, 0.45, 0.1, 695);
  insert into Games values ('Prod-013', 'Monsters of Nightmares', 'Adventure', 'Alphacom', 'Numb Kitten Productions', 'PEGI-18', 55, '36 Hours', 'Deluxe', 80, 56, 0.3, 0.75, 96);
  insert into Games values ('Prod-014', 'Wizards of Sorrow', 'Adventure', 'Heartpoint', 'Winterpunch Game Studios', 'PEGI-12', 98, '44 Hours', 'Gold', 70, 45.5, 0.35, 0.1, 680);
  insert into Games values ('Prod-015', 'Hand and Chronicles', 'Adventure', 'Surprisystems', 'Autotale Arts', 'PEGI-3', 70, '42 Hours', 'Deluxe', 80, 56, 0.3, 0.75, 244);
  insert into Games values ('Prod-016', 'Heaven and Alchemy', 'Adventure', 'Lionshine', 'Starsoft Productions', 'PEGI-16', 90, '59 Hours', 'Deluxe', 40, 28, 0.3, 0.75, 147);
  insert into Games values ('Prod-017', 'Madscape', 'Adventure', 'Lionshine', 'Blind Raccoon Productions', 'PEGI-7', 72, '45 Hours', 'Standard', 60, 48, 0.2, 0.4, 437);
  insert into Games values ('Prod-018', 'Bloodscape', 'Adventure', 'Heartpoint', 'Moonware Interactive', 'PEGI-18', 51, '11 Hours', 'Deluxe', 80, 56, 0.3, 0.75, 224);
  insert into Games values ('Prod-019', 'Chronorite', 'Adventure', 'Alphacom', 'Numb Kitten Productions', 'PEGI-3', 66, '16 Hours', 'Gold', 110, 71.5, 0.35, 0.1, 624);
  insert into Games values ('Prod-020', 'Emberville', 'Adventure', 'Surprisystems', 'Starsoft Productions', 'PEGI-16', 97, '8 Hours', 'Gold', 100, 65, 0.35, 0.75, 172);
  insert into Games values ('Prod-021', 'Infernal Faction', 'RPG', 'Crypticorps', 'Filthy Door Interactive', 'PEGI-16', 70, '14 Hours', 'Standard', 30, 24, 0.2, 0.75, 260);
  insert into Games values ('Prod-022', 'Eternal Harvest', 'RPG', 'Lionshine', 'Blind Raccoon Productions', 'PEGI-18', 54, '3 Hours', 'Standard', 30, 24, 0.2, 0.75, 88);
  insert into Games values ('Prod-023', 'Magic of Mythology', 'RPG', 'Moondustries', 'Blind Raccoon Productions', 'PEGI-7', 91, '10 Hours', 'Standard', 50, 40, 0.2, 0, 891);
  insert into Games values ('Prod-024', 'Spirits of Heritage', 'RPG', 'Crypticorps', 'Rare Spectre Arts', 'PEGI-12', 93, '72 Hours', 'Deluxe', 50, 35, 0.3, 0.4, 551);
  insert into Games values ('Prod-025', 'Enemy and Demons', 'RPG', 'Lionshine', 'Autotale Arts', 'PEGI-7', 82, '44 Hours', 'Collector', 170, 93.5, 0.45, 0.1, 626);
  insert into Games values ('Prod-026', 'Honor and Earth', 'RPG', 'Diamond Media', 'Golden Boa Interactive', 'PEGI-16', 64, '78 Hours', 'Standard', 20, 16, 0.2, 0, 861);
  insert into Games values ('Prod-027', 'Shardforce', 'RPG', 'Fairyhive', 'Subdomain Game Studios', 'PEGI-16', 70, '64 Hours', 'Gold', 100, 65, 0.35, 0.4, 488);
  insert into Games values ('Prod-028', 'Warhunt', 'RPG', 'Lionshine', 'Fierce Studios', 'PEGI-18', 63, '11 Hours', 'Gold', 70, 45.5, 0.35, 0.75, 150);
  insert into Games values ('Prod-029', 'Magechild', 'RPG', 'Crypticorps', 'Vagabond Interactive', 'PEGI-7', 75, '17 Hours', 'Gold', 100, 65, 0.35, 0.75, 144);
  insert into Games values ('Prod-030', 'Arcanepath', 'RPG', 'Cliff Acoustics', 'Filthy Door Interactive', 'PEGI-18', 97, '49 Hours', 'Gold', 110, 71.5, 0.35, 0, 846);
  insert into Games values ('Prod-031', 'Android Dynasty', 'Strategy', 'Lionshine', 'Dapper Bull Media', 'PEGI-16', 78, '67 Hours', 'Gold', 60, 39, 0.35, 0.75, 248);
  insert into Games values ('Prod-032', 'Blood Cataclysm', 'Strategy', 'Cliff Acoustics', 'Numb Kitten Productions', 'PEGI-7', 87, '13 Hours', 'Standard', 50, 40, 0.2, 0.4, 490);
  insert into Games values ('Prod-033', 'Warlords of Turmoil', 'Strategy', 'Lionshine', 'Moonware Interactive', 'PEGI-3', 87, '52 Hours', 'Deluxe', 60, 42, 0.3, 0.4, 440);
  insert into Games values ('Prod-034', 'Titans of Pain', 'Strategy', 'Diamond Media', 'Dapper Bull Media', 'PEGI-18', 62, '26 Hours', 'Collector', 210, 115.5, 0.45, 0, 889);
  insert into Games values ('Prod-035', 'Legions and Warlords', 'Strategy', 'Surprisystems', 'Scary Lizard Productions', 'PEGI-3', 96, '77 Hours', 'Deluxe', 70, 49, 0.3, 0.4, 395);
  insert into Games values ('Prod-036', 'Tactics and Wonder', 'Strategy', 'Fairyhive', 'Golden Boa Interactive', 'PEGI-12', 88, '78 Hours', 'Deluxe', 40, 28, 0.3, 0, 808);
  insert into Games values ('Prod-037', 'Phantomland', 'Strategy', 'Surprisystems', 'Subdomain Game Studios', 'PEGI-12', 66, '57 Hours', 'Standard', 40, 32, 0.2, 0.75, 238);
  insert into Games values ('Prod-038', 'Siegefront', 'Strategy', 'Moondustries', 'Starsoft Productions', 'PEGI-16', 83, '25 Hours', 'Standard', 30, 24, 0.2, 0.1, 607);
  insert into Games values ('Prod-039', 'Ashcommand', 'Strategy', 'Diamond Media', 'Golden Boa Interactive', 'PEGI-12', 76, '18 Hours', 'Standard', 50, 40, 0.2, 0.75, 223);
  insert into Games values ('Prod-040', 'Netherheart', 'Strategy', 'Crypticorps', 'Light Crow Games', 'PEGI-7', 68, '45 Hours', 'Gold', 110, 71.5, 0.35, 0.1, 608);
  
  
  insert into Publishers values ('Diamond Media', 0.3, 8915, 107, 'LOW');
  insert into Publishers values ('Cliff Acoustics', 0.3, 6456, 117, 'HIGH');
  insert into Publishers values ('Alphacom', 0.3, 9503, 98, 'HIGH');
  insert into Publishers values ('Crypticorps', 0.3, 7282, 135, 'HIGH');
  insert into Publishers values ('Moondustries', 0.1, 1509, 73, 'HIGH');
  insert into Publishers values ('Surprisystems', 0.15, 5798, 135, 'MEDIUM');
  insert into Publishers values ('Lionshine', 0.1, 2650, 109, 'HIGH');
  insert into Publishers values ('Fairyhive', 0.15, 5371, 136, 'MEDIUM');
  insert into Publishers values ('Heartpoint', 0.3, 7499, 104, 'HIGH');
  
  
  insert into Employees values ('empl_001', 'Kristin Belushi', 'br-020', 'ON_LEAVE', 620, 0.11);
  insert into Employees values ('empl_002', 'Erich Signori', 'br-005', 'ACTIVE', 620, 0.29);
  insert into Employees values ('empl_003', 'Hellen Wynn', 'br-008', 'ON_LEAVE', 800, 0.14);
  insert into Employees values ('empl_004', 'Kirsten Durham', 'br-008', 'ON_LEAVE', 690, 0.15);
  insert into Employees values ('empl_005', 'Trey Wall', 'br-003', 'ON_LEAVE', 600, 0.11);
  insert into Employees values ('empl_006', 'Sonny Childs', 'br-012', 'ON_LEAVE', 760, 0.25);
  insert into Employees values ('empl_007', 'Charles Pagan', 'br-002', 'ON_LEAVE', 730, 0.23);
  insert into Employees values ('empl_008', 'Lesley Mckenzie', 'br-001', 'ACTIVE', 670, 0.15);
  insert into Employees values ('empl_009', 'Jorge Emery', 'br-006', 'ACTIVE', 800, 0.18);
  insert into Employees values ('empl_010', 'Jama Skinner', 'br-019', 'ON_LEAVE', 650, 0.25);
  insert into Employees values ('empl_011', 'Lucy Lester', 'br-008', 'ON_LEAVE', 800, 0.25);
  insert into Employees values ('empl_012', 'Andreas Crawford', 'br-014', 'ACTIVE', 800, 0.28);
  insert into Employees values ('empl_013', 'Merna Deal', 'br-008', 'ACTIVE', 640, 0.17);
  insert into Employees values ('empl_014', 'Asuncion Chernenko', 'br-011', 'ACTIVE', 610, 0.27);
  insert into Employees values ('empl_015', 'Tamra Hahn', 'br-001', 'ACTIVE', 630, 0.18);
  insert into Employees values ('empl_016', 'Olive Kernos', 'br-007', 'ACTIVE', 610, 0.13);
  insert into Employees values ('empl_017', 'Rocco Wiles', 'br-018', 'ACTIVE', 650, 0.18);
  insert into Employees values ('empl_018', 'Joe Arthur', 'br-015', 'ACTIVE', 710, 0.16);
  insert into Employees values ('empl_019', 'Granville McClintock', 'br-019', 'ON_LEAVE', 750, 0.22);
  insert into Employees values ('empl_020', 'Merna Alvarado', 'br-006', 'ON_LEAVE', 680, 0.12);
  insert into Employees values ('empl_021', 'Egon Griffith', 'br-020', 'ACTIVE', 660, 0.23);
  insert into Employees values ('empl_022', 'Hans Lawrence', 'br-007', 'ON_LEAVE', 760, 0.23);
  insert into Employees values ('empl_023', 'Russel Fitzgerald', 'br-011', 'ON_LEAVE', 740, 0.22);
  insert into Employees values ('empl_024', 'Jed Harvey', 'br-002', 'ON_LEAVE', 610, 0.11);
  insert into Employees values ('empl_025', 'Sanjuana Bowen', 'br-012', 'ACTIVE', 680, 0.3);
  insert into Employees values ('empl_026', 'Ellena Mayo', 'br-013', 'ACTIVE', 650, 0.18);
  insert into Employees values ('empl_027', 'Cody Haney', 'br-015', 'ON_LEAVE', 740, 0.19);
  insert into Employees values ('empl_028', 'Bernt Kern', 'br-002', 'ON_LEAVE', 610, 0.17);
  insert into Employees values ('empl_029', 'Jimmie Sforza', 'br-008', 'ON_LEAVE', 600, 0.13);
  insert into Employees values ('empl_030', 'Barry Roth', 'br-006', 'ACTIVE', 710, 0.1);
  insert into Employees values ('empl_031', 'Brice Townsend', 'br-005', 'ACTIVE', 750, 0.18);
  insert into Employees values ('empl_032', 'Henry Rivers', 'br-015', 'ACTIVE', 710, 0.11);
  insert into Employees values ('empl_033', 'Cody Reyna', 'br-004', 'ON_LEAVE', 670, 0.3);
  insert into Employees values ('empl_034', 'Frank Dang', 'br-007', 'ON_LEAVE', 620, 0.17);
  insert into Employees values ('empl_035', 'Delbert Childress', 'br-004', 'ON_LEAVE', 670, 0.25);
  insert into Employees values ('empl_036', 'Herman Liszt', 'br-006', 'ACTIVE', 730, 0.23);
  insert into Employees values ('empl_037', 'Lesa Cameron', 'br-014', 'ACTIVE', 740, 0.16);
  insert into Employees values ('empl_038', 'Alec Milic', 'br-020', 'ACTIVE', 770, 0.12);
  insert into Employees values ('empl_039', 'Tabetha Mott', 'br-001', 'ON_LEAVE', 790, 0.17);
  insert into Employees values ('empl_040', 'Silas Chin', 'br-015', 'ON_LEAVE', 720, 0.17);
  insert into Employees values ('empl_041', 'Jorge Ruiz', 'br-017', 'ON_LEAVE', 640, 0.15);
  insert into Employees values ('empl_042', 'Kristyn Adams', 'br-010', 'ACTIVE', 710, 0.22);
  insert into Employees values ('empl_043', 'Hermila Gorman', 'br-003', 'ACTIVE', 770, 0.1);
  insert into Employees values ('empl_044', 'Mervin Sizemore', 'br-016', 'ACTIVE', 610, 0.16);
  insert into Employees values ('empl_045', 'Gerry Pineiro', 'br-006', 'ACTIVE', 660, 0.24);
  insert into Employees values ('empl_046', 'Irving Terrell', 'br-010', 'ACTIVE', 710, 0.26);
  insert into Employees values ('empl_047', 'Gene Farmer', 'br-012', 'ACTIVE', 670, 0.1);
  insert into Employees values ('empl_048', 'Artie Rush', 'br-001', 'ACTIVE', 790, 0.14);
  insert into Employees values ('empl_049', 'Astarte Figueroa', 'br-015', 'ACTIVE', 770, 0.3);
  insert into Employees values ('empl_050', 'Israel Hester', 'br-004', 'ON_LEAVE', 780, 0.3);
  insert into Employees values ('empl_051', 'Clementine Towers', 'br-017', 'ACTIVE', 770, 0.1);
  insert into Employees values ('empl_052', 'Alden Booth', 'br-002', 'ACTIVE', 790, 0.23);
  insert into Employees values ('empl_053', 'Serina Peugeot', 'br-011', 'ACTIVE', 710, 0.13);
  insert into Employees values ('empl_054', 'Danial Vela', 'br-018', 'ON_LEAVE', 650, 0.13);
  insert into Employees values ('empl_055', 'Ervin Lincoln', 'br-018', 'ON_LEAVE', 770, 0.1);
  insert into Employees values ('empl_056', 'Alane Lowe', 'br-014', 'ACTIVE', 680, 0.18);
  insert into Employees values ('empl_057', 'Quinn Holliday', 'br-011', 'ON_LEAVE', 700, 0.15);
  insert into Employees values ('empl_058', 'Bernard Corona', 'br-018', 'ON_LEAVE', 750, 0.25);
  insert into Employees values ('empl_059', 'Delmer Cates', 'br-013', 'ACTIVE', 700, 0.17);
  insert into Employees values ('empl_060', 'Wiley Toveney', 'br-013', 'ACTIVE', 660, 0.17);
  insert into Employees values ('empl_061', 'Jesse Francisco', 'br-004', 'ACTIVE', 660, 0.24);
  insert into Employees values ('empl_062', 'Xavier Underwood', 'br-006', 'ON_LEAVE', 610, 0.27);
  insert into Employees values ('empl_063', 'Mervin Gay', 'br-009', 'ACTIVE', 640, 0.12);
  insert into Employees values ('empl_064', 'Marvis Belzer', 'br-010', 'ON_LEAVE', 640, 0.11);
  insert into Employees values ('empl_065', 'Shawna Fitzgerald', 'br-003', 'ACTIVE', 800, 0.17);
  insert into Employees values ('empl_066', 'Kit Everett', 'br-001', 'ACTIVE', 670, 0.15);
  insert into Employees values ('empl_067', 'Cheryl Feldman', 'br-014', 'ON_LEAVE', 760, 0.14);
  insert into Employees values ('empl_068', 'Brunilda Savage', 'br-012', 'ACTIVE', 670, 0.3);
  insert into Employees values ('empl_069', 'Marcelino Alvarez', 'br-010', 'ON_LEAVE', 610, 0.26);
  insert into Employees values ('empl_070', 'Morgan Montague', 'br-015', 'ON_LEAVE', 730, 0.15);
  insert into Employees values ('empl_071', 'Fredrick Chavez', 'br-008', 'ON_LEAVE', 620, 0.11);
  insert into Employees values ('empl_072', 'Carmen Funk', 'br-009', 'ACTIVE', 630, 0.18);
  insert into Employees values ('empl_073', 'Paige Shimura', 'br-003', 'ACTIVE', 770, 0.21);
  insert into Employees values ('empl_074', 'Minh Bermudez', 'br-020', 'ON_LEAVE', 740, 0.19);
  insert into Employees values ('empl_075', 'Candace Diaz', 'br-006', 'ACTIVE', 710, 0.17);
  insert into Employees values ('empl_076', 'Richie Sexton', 'br-004', 'ON_LEAVE', 640, 0.24);
  insert into Employees values ('empl_077', 'Kareem Nieto', 'br-009', 'ON_LEAVE', 760, 0.23);
  insert into Employees values ('empl_078', 'Lewis Mcallister', 'br-014', 'ACTIVE', 640, 0.2);
  insert into Employees values ('empl_079', 'Blondell Hobbs', 'br-014', 'ON_LEAVE', 740, 0.24);
  insert into Employees values ('empl_080', 'Raymond Maurer', 'br-015', 'ACTIVE', 670, 0.12);
  insert into Employees values ('empl_081', 'Alberto Harrison', 'br-015', 'ACTIVE', 760, 0.15);
  insert into Employees values ('empl_082', 'Christia John', 'br-002', 'ACTIVE', 600, 0.24);
  insert into Employees values ('empl_083', 'Sharell Aragon', 'br-017', 'ACTIVE', 730, 0.24);
  insert into Employees values ('empl_084', 'Judith Bowman', 'br-010', 'ACTIVE', 680, 0.23);
  insert into Employees values ('empl_085', 'Bette Hatch', 'br-002', 'ACTIVE', 790, 0.16);
  insert into Employees values ('empl_086', 'Kenton Levin', 'br-015', 'ACTIVE', 670, 0.28);
  insert into Employees values ('empl_087', 'Cordell Britt', 'br-006', 'ON_LEAVE', 730, 0.3);
  insert into Employees values ('empl_088', 'Jolynn Thacker', 'br-002', 'ACTIVE', 680, 0.12);
  insert into Employees values ('empl_089', 'Zenon Mayes', 'br-013', 'ON_LEAVE', 750, 0.22);
  insert into Employees values ('empl_090', 'Minh Kraft', 'br-004', 'ACTIVE', 670, 0.18);
  insert into Employees values ('empl_091', 'Vivian Rosenkrantz', 'br-008', 'ON_LEAVE', 750, 0.28);
  insert into Employees values ('empl_092', 'Emory McGuyver', 'br-010', 'ON_LEAVE', 740, 0.3);
  insert into Employees values ('empl_093', 'Modesto Osborn', 'br-002', 'ACTIVE', 600, 0.18);
  insert into Employees values ('empl_094', 'Peggie Avila', 'br-002', 'ACTIVE', 690, 0.1);
  insert into Employees values ('empl_095', 'Everette Bovary', 'br-006', 'ACTIVE', 610, 0.24);
  insert into Employees values ('empl_096', 'Ai Wooten', 'br-017', 'ACTIVE', 640, 0.17);
  insert into Employees values ('empl_097', 'Whitney Summers', 'br-007', 'ON_LEAVE', 790, 0.19);
  insert into Employees values ('empl_098', 'Shane Mortimer', 'br-010', 'ON_LEAVE', 700, 0.24);
  insert into Employees values ('empl_099', 'Danial Pelletier', 'br-011', 'ON_LEAVE', 750, 0.24);
  insert into Employees values ('empl_100', 'Norbert Daniel', 'br-020', 'ACTIVE', 640, 0.16);
  
  
  insert into Online_orders values ('Ord-001', '08-Dec-2020', 'cust-247', 'Prod-034', 'MEDIUM', 'wrh-002');
  insert into Online_orders values ('Ord-002', '07-Feb-2020', 'cust-068', 'Prod-005', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-003', '27-Mar-2020', 'cust-293', 'Prod-010', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-004', '03-Dec-2020', 'cust-190', 'Prod-033', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-005', '07-May-2020', 'cust-198', 'Prod-016', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-006', '27-Feb-2020', 'cust-105', 'Prod-029', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-007', '07-Sep-2020', 'cust-186', 'Prod-020', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-008', '30-Sep-2020', 'cust-011', 'Prod-037', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-009', '20-Dec-2020', 'cust-273', 'Prod-026', 'LOW', 'wrh-001');
  insert into Online_orders values ('Ord-010', '17-Oct-2020', 'cust-120', 'Prod-034', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-011', '20-Oct-2020', 'cust-167', 'Prod-012', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-012', '26-Jun-2020', 'cust-118', 'Prod-036', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-013', '07-May-2020', 'cust-047', 'Prod-021', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-014', '04-Jul-2020', 'cust-079', 'Prod-001', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-015', '20-Sep-2020', 'cust-250', 'Prod-023', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-016', '10-Oct-2020', 'cust-036', 'Prod-012', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-017', '27-Oct-2020', 'cust-172', 'Prod-017', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-018', '14-Nov-2020', 'cust-128', 'Prod-028', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-019', '24-Dec-2020', 'cust-130', 'Prod-012', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-020', '18-Jul-2020', 'cust-238', 'Prod-005', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-021', '11-Jun-2020', 'cust-018', 'Prod-019', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-022', '08-Feb-2020', 'cust-018', 'Prod-038', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-023', '25-Jul-2020', 'cust-150', 'Prod-031', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-024', '20-Jul-2020', 'cust-274', 'Prod-012', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-025', '04-Jan-2020', 'cust-001', 'Prod-004', 'MEDIUM', 'wrh-003');
  insert into Online_orders values ('Ord-026', '22-Jan-2020', 'cust-175', 'Prod-032', 'LOW', 'wrh-001');
  insert into Online_orders values ('Ord-027', '06-May-2020', 'cust-284', 'Prod-036', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-028', '22-Jun-2020', 'cust-218', 'Prod-002', 'MEDIUM', 'wrh-002');
  insert into Online_orders values ('Ord-029', '28-May-2020', 'cust-048', 'Prod-020', 'LOW', 'wrh-001');
  insert into Online_orders values ('Ord-030', '05-Jan-2020', 'cust-008', 'Prod-036', 'MEDIUM', 'wrh-004');
  insert into Online_orders values ('Ord-031', '12-Sep-2020', 'cust-278', 'Prod-001', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-032', '31-Jan-2020', 'cust-148', 'Prod-004', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-033', '24-Sep-2020', 'cust-148', 'Prod-001', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-034', '23-Nov-2020', 'cust-272', 'Prod-023', 'LOW', 'wrh-001');
  insert into Online_orders values ('Ord-035', '02-Dec-2020', 'cust-179', 'Prod-013', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-036', '30-Dec-2020', 'cust-068', 'Prod-005', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-037', '19-Feb-2020', 'cust-155', 'Prod-038', 'MEDIUM', 'wrh-004');
  insert into Online_orders values ('Ord-038', '10-Jul-2020', 'cust-239', 'Prod-017', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-039', '10-Jun-2020', 'cust-075', 'Prod-024', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-040', '05-Feb-2020', 'cust-015', 'Prod-004', 'LOW', 'wrh-003');
  insert into Online_orders values ('Ord-041', '18-Nov-2020', 'cust-220', 'Prod-026', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-042', '27-May-2020', 'cust-014', 'Prod-008', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-043', '23-Dec-2020', 'cust-163', 'Prod-028', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-044', '31-Mar-2020', 'cust-122', 'Prod-020', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-045', '01-Jun-2020', 'cust-188', 'Prod-019', 'MEDIUM', 'wrh-001');
  insert into Online_orders values ('Ord-046', '29-Dec-2020', 'cust-241', 'Prod-038', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-047', '02-May-2020', 'cust-105', 'Prod-009', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-048', '26-Jul-2020', 'cust-096', 'Prod-035', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-049', '06-Sep-2020', 'cust-150', 'Prod-017', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-050', '09-Nov-2020', 'cust-194', 'Prod-002', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-051', '14-Mar-2020', 'cust-293', 'Prod-002', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-052', '13-May-2020', 'cust-112', 'Prod-002', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-053', '17-Jul-2020', 'cust-277', 'Prod-039', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-054', '10-Jun-2020', 'cust-052', 'Prod-009', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-055', '04-Apr-2020', 'cust-033', 'Prod-027', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-056', '09-Mar-2020', 'cust-156', 'Prod-034', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-057', '08-Jan-2020', 'cust-214', 'Prod-005', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-058', '14-May-2020', 'cust-288', 'Prod-015', 'LOW', 'wrh-003');
  insert into Online_orders values ('Ord-059', '26-Jun-2020', 'cust-105', 'Prod-033', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-060', '21-Dec-2020', 'cust-180', 'Prod-001', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-061', '29-Nov-2020', 'cust-052', 'Prod-022', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-062', '17-Nov-2020', 'cust-119', 'Prod-004', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-063', '04-Jan-2020', 'cust-056', 'Prod-021', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-064', '05-Jun-2020', 'cust-229', 'Prod-013', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-065', '21-Mar-2020', 'cust-018', 'Prod-033', 'MEDIUM', 'wrh-002');
  insert into Online_orders values ('Ord-066', '20-Jan-2020', 'cust-091', 'Prod-026', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-067', '08-Jan-2020', 'cust-109', 'Prod-016', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-068', '11-Apr-2020', 'cust-064', 'Prod-038', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-069', '23-Oct-2020', 'cust-117', 'Prod-029', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-070', '13-Aug-2020', 'cust-088', 'Prod-007', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-071', '31-Oct-2020', 'cust-084', 'Prod-038', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-072', '18-May-2020', 'cust-213', 'Prod-033', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-073', '03-Sep-2020', 'cust-210', 'Prod-010', 'LOW', 'wrh-001');
  insert into Online_orders values ('Ord-074', '18-Nov-2020', 'cust-215', 'Prod-018', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-075', '02-Dec-2020', 'cust-184', 'Prod-034', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-076', '17-Nov-2020', 'cust-053', 'Prod-022', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-077', '10-May-2020', 'cust-134', 'Prod-011', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-078', '26-Mar-2020', 'cust-014', 'Prod-016', 'LOW', 'wrh-005');
  insert into Online_orders values ('Ord-079', '13-Mar-2020', 'cust-214', 'Prod-019', 'HIGH', 'wrh-001');
  insert into Online_orders values ('Ord-080', '07-Mar-2020', 'cust-050', 'Prod-002', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-081', '04-Dec-2020', 'cust-009', 'Prod-011', 'MEDIUM', 'wrh-003');
  insert into Online_orders values ('Ord-082', '28-May-2020', 'cust-044', 'Prod-034', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-083', '03-Jul-2020', 'cust-093', 'Prod-009', 'HIGH', 'wrh-004');
  insert into Online_orders values ('Ord-084', '29-May-2020', 'cust-173', 'Prod-037', 'HIGH', 'wrh-005');
  insert into Online_orders values ('Ord-085', '28-Feb-2020', 'cust-128', 'Prod-020', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-086', '10-Jan-2020', 'cust-246', 'Prod-030', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-087', '10-Apr-2020', 'cust-207', 'Prod-001', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-088', '18-Apr-2020', 'cust-155', 'Prod-005', 'MEDIUM', 'wrh-004');
  insert into Online_orders values ('Ord-089', '08-Jul-2020', 'cust-013', 'Prod-040', 'HIGH', 'wrh-003');
  insert into Online_orders values ('Ord-090', '28-Nov-2020', 'cust-150', 'Prod-006', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-091', '15-Apr-2020', 'cust-238', 'Prod-003', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-092', '19-Apr-2020', 'cust-163', 'Prod-009', 'MEDIUM', 'wrh-005');
  insert into Online_orders values ('Ord-093', '04-May-2020', 'cust-146', 'Prod-008', 'HIGH', 'wrh-002');
  insert into Online_orders values ('Ord-094', '17-Feb-2020', 'cust-012', 'Prod-027', 'MEDIUM', 'wrh-001');
  insert into Online_orders values ('Ord-095', '26-Dec-2020', 'cust-013', 'Prod-003', 'MEDIUM', 'wrh-001');
  insert into Online_orders values ('Ord-096', '13-Dec-2020', 'cust-258', 'Prod-032', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-097', '05-Oct-2020', 'cust-206', 'Prod-001', 'LOW', 'wrh-004');
  insert into Online_orders values ('Ord-098', '29-Oct-2020', 'cust-107', 'Prod-025', 'LOW', 'wrh-003');
  insert into Online_orders values ('Ord-099', '08-Nov-2020', 'cust-075', 'Prod-007', 'LOW', 'wrh-002');
  insert into Online_orders values ('Ord-100', '02-Dec-2020', 'cust-293', 'Prod-010', 'MEDIUM', 'wrh-002');
  
  
  insert into Local_sales values ('Sale-001', 'cust-125', '25-Jun-2020', 'Prod-006', 'br-012', 'empl_009');
  insert into Local_sales values ('Sale-002', 'cust-188', '04-Mar-2020', 'Prod-016', 'br-003', 'empl_094');
  insert into Local_sales values ('Sale-003', 'cust-176', '08-Apr-2020', 'Prod-022', 'br-020', 'empl_080');
  insert into Local_sales values ('Sale-004', 'cust-300', '04-Jul-2020', 'Prod-012', 'br-004', 'empl_076');
  insert into Local_sales values ('Sale-005', 'cust-292', '27-Oct-2020', 'Prod-028', 'br-008', 'empl_002');
  insert into Local_sales values ('Sale-006', 'cust-196', '01-Mar-2020', 'Prod-040', 'br-007', 'empl_068');
  insert into Local_sales values ('Sale-007', 'cust-105', '28-Feb-2020', 'Prod-017', 'br-016', 'empl_017');
  insert into Local_sales values ('Sale-008', 'cust-088', '07-Dec-2020', 'Prod-039', 'br-019', 'empl_060');
  insert into Local_sales values ('Sale-009', 'cust-138', '04-Apr-2020', 'Prod-039', 'br-005', 'empl_040');
  insert into Local_sales values ('Sale-010', 'cust-231', '24-Apr-2020', 'Prod-021', 'br-007', 'empl_013');
  insert into Local_sales values ('Sale-011', 'cust-166', '13-Dec-2020', 'Prod-034', 'br-006', 'empl_036');
  insert into Local_sales values ('Sale-012', 'cust-210', '19-Sep-2020', 'Prod-015', 'br-005', 'empl_049');
  insert into Local_sales values ('Sale-013', 'cust-106', '14-Dec-2020', 'Prod-037', 'br-005', 'empl_087');
  insert into Local_sales values ('Sale-014', 'cust-097', '12-Jan-2020', 'Prod-033', 'br-013', 'empl_045');
  insert into Local_sales values ('Sale-015', 'cust-065', '07-Feb-2020', 'Prod-011', 'br-005', 'empl_064');
  insert into Local_sales values ('Sale-016', 'cust-245', '03-Oct-2020', 'Prod-035', 'br-017', 'empl_093');
  insert into Local_sales values ('Sale-017', 'cust-289', '30-Sep-2020', 'Prod-025', 'br-009', 'empl_096');
  insert into Local_sales values ('Sale-018', 'cust-185', '08-Dec-2020', 'Prod-005', 'br-011', 'empl_026');
  insert into Local_sales values ('Sale-019', 'cust-258', '16-Oct-2020', 'Prod-026', 'br-014', 'empl_023');
  insert into Local_sales values ('Sale-020', 'cust-185', '06-Sep-2020', 'Prod-004', 'br-007', 'empl_036');
  insert into Local_sales values ('Sale-021', 'cust-191', '14-May-2020', 'Prod-019', 'br-009', 'empl_085');
  insert into Local_sales values ('Sale-022', 'cust-240', '06-Apr-2020', 'Prod-007', 'br-006', 'empl_058');
  insert into Local_sales values ('Sale-023', 'cust-179', '10-Jun-2020', 'Prod-032', 'br-015', 'empl_022');
  insert into Local_sales values ('Sale-024', 'cust-065', '10-Mar-2020', 'Prod-021', 'br-002', 'empl_085');
  insert into Local_sales values ('Sale-025', 'cust-246', '19-Dec-2020', 'Prod-026', 'br-002', 'empl_016');
  insert into Local_sales values ('Sale-026', 'cust-261', '22-Oct-2020', 'Prod-002', 'br-014', 'empl_054');
  insert into Local_sales values ('Sale-027', 'cust-269', '30-Apr-2020', 'Prod-011', 'br-019', 'empl_084');
  insert into Local_sales values ('Sale-028', 'cust-272', '23-Jan-2020', 'Prod-010', 'br-020', 'empl_006');
  insert into Local_sales values ('Sale-029', 'cust-030', '04-Jan-2020', 'Prod-030', 'br-004', 'empl_016');
  insert into Local_sales values ('Sale-030', 'cust-018', '02-Jan-2020', 'Prod-030', 'br-016', 'empl_070');
  insert into Local_sales values ('Sale-031', 'cust-031', '05-Jul-2020', 'Prod-040', 'br-014', 'empl_078');
  insert into Local_sales values ('Sale-032', 'cust-157', '17-Jan-2020', 'Prod-001', 'br-002', 'empl_043');
  insert into Local_sales values ('Sale-033', 'cust-038', '11-Jul-2020', 'Prod-005', 'br-008', 'empl_020');
  insert into Local_sales values ('Sale-034', 'cust-172', '29-Jun-2020', 'Prod-036', 'br-015', 'empl_027');
  insert into Local_sales values ('Sale-035', 'cust-102', '13-Mar-2020', 'Prod-014', 'br-019', 'empl_036');
  insert into Local_sales values ('Sale-036', 'cust-173', '08-Sep-2020', 'Prod-040', 'br-012', 'empl_059');
  insert into Local_sales values ('Sale-037', 'cust-129', '03-Feb-2020', 'Prod-011', 'br-014', 'empl_079');
  insert into Local_sales values ('Sale-038', 'cust-157', '17-Jan-2020', 'Prod-021', 'br-018', 'empl_084');
  insert into Local_sales values ('Sale-039', 'cust-091', '05-May-2020', 'Prod-001', 'br-012', 'empl_024');
  insert into Local_sales values ('Sale-040', 'cust-115', '15-Dec-2020', 'Prod-001', 'br-013', 'empl_003');
  insert into Local_sales values ('Sale-041', 'cust-099', '09-Oct-2020', 'Prod-040', 'br-009', 'empl_008');
  insert into Local_sales values ('Sale-042', 'cust-229', '12-Apr-2020', 'Prod-021', 'br-018', 'empl_030');
  insert into Local_sales values ('Sale-043', 'cust-028', '29-Apr-2020', 'Prod-009', 'br-016', 'empl_015');
  insert into Local_sales values ('Sale-044', 'cust-289', '23-Jan-2020', 'Prod-026', 'br-008', 'empl_021');
  insert into Local_sales values ('Sale-045', 'cust-058', '28-Oct-2020', 'Prod-001', 'br-015', 'empl_003');
  insert into Local_sales values ('Sale-046', 'cust-013', '02-Mar-2020', 'Prod-002', 'br-001', 'empl_098');
  insert into Local_sales values ('Sale-047', 'cust-250', '21-Jul-2020', 'Prod-002', 'br-020', 'empl_066');
  insert into Local_sales values ('Sale-048', 'cust-293', '11-Jul-2020', 'Prod-009', 'br-011', 'empl_013');
  insert into Local_sales values ('Sale-049', 'cust-087', '01-Dec-2020', 'Prod-033', 'br-016', 'empl_037');
  insert into Local_sales values ('Sale-050', 'cust-258', '19-Sep-2020', 'Prod-035', 'br-015', 'empl_067');
  insert into Local_sales values ('Sale-051', 'cust-159', '13-Jan-2020', 'Prod-021', 'br-010', 'empl_017');
  insert into Local_sales values ('Sale-052', 'cust-085', '10-Oct-2020', 'Prod-016', 'br-013', 'empl_007');
  insert into Local_sales values ('Sale-053', 'cust-284', '18-Apr-2020', 'Prod-013', 'br-006', 'empl_021');
  insert into Local_sales values ('Sale-054', 'cust-175', '17-Jan-2020', 'Prod-032', 'br-014', 'empl_033');
  insert into Local_sales values ('Sale-055', 'cust-093', '18-Nov-2020', 'Prod-023', 'br-010', 'empl_050');
  insert into Local_sales values ('Sale-056', 'cust-257', '04-May-2020', 'Prod-036', 'br-015', 'empl_022');
  insert into Local_sales values ('Sale-057', 'cust-127', '16-Sep-2020', 'Prod-019', 'br-011', 'empl_087');
  insert into Local_sales values ('Sale-058', 'cust-229', '23-Mar-2020', 'Prod-001', 'br-016', 'empl_022');
  insert into Local_sales values ('Sale-059', 'cust-102', '15-Feb-2020', 'Prod-002', 'br-003', 'empl_064');
  insert into Local_sales values ('Sale-060', 'cust-067', '03-May-2020', 'Prod-005', 'br-001', 'empl_079');
  insert into Local_sales values ('Sale-061', 'cust-176', '17-Dec-2020', 'Prod-003', 'br-008', 'empl_076');
  insert into Local_sales values ('Sale-062', 'cust-259', '21-Sep-2020', 'Prod-019', 'br-006', 'empl_077');
  insert into Local_sales values ('Sale-063', 'cust-265', '02-Sep-2020', 'Prod-028', 'br-005', 'empl_067');
  insert into Local_sales values ('Sale-064', 'cust-104', '26-Apr-2020', 'Prod-030', 'br-002', 'empl_071');
  insert into Local_sales values ('Sale-065', 'cust-263', '06-Nov-2020', 'Prod-026', 'br-019', 'empl_077');
  insert into Local_sales values ('Sale-066', 'cust-181', '24-Nov-2020', 'Prod-027', 'br-012', 'empl_092');
  insert into Local_sales values ('Sale-067', 'cust-102', '20-Jun-2020', 'Prod-008', 'br-004', 'empl_045');
  insert into Local_sales values ('Sale-068', 'cust-066', '03-Mar-2020', 'Prod-006', 'br-005', 'empl_075');
  insert into Local_sales values ('Sale-069', 'cust-215', '01-Feb-2020', 'Prod-020', 'br-007', 'empl_068');
  insert into Local_sales values ('Sale-070', 'cust-156', '28-Jul-2020', 'Prod-037', 'br-014', 'empl_096');
  insert into Local_sales values ('Sale-071', 'cust-025', '25-Mar-2020', 'Prod-011', 'br-019', 'empl_038');
  insert into Local_sales values ('Sale-072', 'cust-106', '29-Jan-2020', 'Prod-031', 'br-019', 'empl_063');
  insert into Local_sales values ('Sale-073', 'cust-140', '25-Nov-2020', 'Prod-028', 'br-007', 'empl_084');
  insert into Local_sales values ('Sale-074', 'cust-254', '30-Nov-2020', 'Prod-020', 'br-011', 'empl_072');
  insert into Local_sales values ('Sale-075', 'cust-210', '11-Apr-2020', 'Prod-009', 'br-001', 'empl_099');
  insert into Local_sales values ('Sale-076', 'cust-099', '18-Jun-2020', 'Prod-007', 'br-008', 'empl_047');
  insert into Local_sales values ('Sale-077', 'cust-242', '09-Aug-2020', 'Prod-006', 'br-008', 'empl_045');
  insert into Local_sales values ('Sale-078', 'cust-005', '28-Mar-2020', 'Prod-003', 'br-009', 'empl_080');
  insert into Local_sales values ('Sale-079', 'cust-187', '23-Dec-2020', 'Prod-021', 'br-018', 'empl_037');
  insert into Local_sales values ('Sale-080', 'cust-252', '31-Mar-2020', 'Prod-024', 'br-008', 'empl_041');
  insert into Local_sales values ('Sale-081', 'cust-298', '05-Feb-2020', 'Prod-013', 'br-005', 'empl_077');
  insert into Local_sales values ('Sale-082', 'cust-283', '18-Jul-2020', 'Prod-010', 'br-001', 'empl_071');
  insert into Local_sales values ('Sale-083', 'cust-292', '07-Jul-2020', 'Prod-014', 'br-019', 'empl_062');
  insert into Local_sales values ('Sale-084', 'cust-153', '31-Mar-2020', 'Prod-039', 'br-002', 'empl_055');
  insert into Local_sales values ('Sale-085', 'cust-029', '10-Nov-2020', 'Prod-015', 'br-009', 'empl_095');
  insert into Local_sales values ('Sale-086', 'cust-253', '10-Dec-2020', 'Prod-031', 'br-005', 'empl_095');
  insert into Local_sales values ('Sale-087', 'cust-042', '02-May-2020', 'Prod-023', 'br-001', 'empl_063');
  insert into Local_sales values ('Sale-088', 'cust-300', '23-Mar-2020', 'Prod-039', 'br-017', 'empl_057');
  insert into Local_sales values ('Sale-089', 'cust-176', '17-May-2020', 'Prod-016', 'br-009', 'empl_024');
  insert into Local_sales values ('Sale-090', 'cust-164', '16-Feb-2020', 'Prod-037', 'br-019', 'empl_049');
  insert into Local_sales values ('Sale-091', 'cust-184', '03-Jun-2020', 'Prod-025', 'br-019', 'empl_099');
  insert into Local_sales values ('Sale-092', 'cust-087', '13-May-2020', 'Prod-009', 'br-019', 'empl_045');
  insert into Local_sales values ('Sale-093', 'cust-091', '25-Apr-2020', 'Prod-028', 'br-012', 'empl_074');
  insert into Local_sales values ('Sale-094', 'cust-067', '22-Sep-2020', 'Prod-023', 'br-005', 'empl_098');
  insert into Local_sales values ('Sale-095', 'cust-234', '19-Apr-2020', 'Prod-002', 'br-012', 'empl_078');
  insert into Local_sales values ('Sale-096', 'cust-254', '31-May-2020', 'Prod-027', 'br-001', 'empl_004');
  insert into Local_sales values ('Sale-097', 'cust-295', '11-Nov-2020', 'Prod-033', 'br-013', 'empl_041');
  insert into Local_sales values ('Sale-098', 'cust-191', '13-Aug-2020', 'Prod-026', 'br-001', 'empl_081');
  insert into Local_sales values ('Sale-099', 'cust-257', '17-Nov-2020', 'Prod-032', 'br-011', 'empl_056');
  insert into Local_sales values ('Sale-100', 'cust-288', '19-Apr-2020', 'Prod-034', 'br-004', 'empl_050');
  insert into Local_sales values ('Sale-101', 'cust-099', '23-Sep-2020', 'Prod-018', 'br-018', 'empl_026');
  insert into Local_sales values ('Sale-102', 'cust-060', '16-Nov-2020', 'Prod-026', 'br-014', 'empl_095');
  insert into Local_sales values ('Sale-103', 'cust-144', '27-Aug-2020', 'Prod-007', 'br-013', 'empl_030');
  insert into Local_sales values ('Sale-104', 'cust-002', '25-Feb-2020', 'Prod-005', 'br-002', 'empl_034');
  insert into Local_sales values ('Sale-105', 'cust-298', '12-Jan-2020', 'Prod-039', 'br-011', 'empl_008');
  insert into Local_sales values ('Sale-106', 'cust-219', '25-Sep-2020', 'Prod-037', 'br-010', 'empl_060');
  insert into Local_sales values ('Sale-107', 'cust-135', '28-Dec-2020', 'Prod-029', 'br-006', 'empl_084');
  insert into Local_sales values ('Sale-108', 'cust-131', '05-Jun-2020', 'Prod-010', 'br-013', 'empl_061');
  insert into Local_sales values ('Sale-109', 'cust-113', '09-Jul-2020', 'Prod-001', 'br-003', 'empl_062');
  insert into Local_sales values ('Sale-110', 'cust-147', '10-Jun-2020', 'Prod-010', 'br-007', 'empl_046');
  insert into Local_sales values ('Sale-111', 'cust-210', '21-Sep-2020', 'Prod-034', 'br-001', 'empl_054');
  insert into Local_sales values ('Sale-112', 'cust-185', '05-Feb-2020', 'Prod-035', 'br-007', 'empl_013');
  insert into Local_sales values ('Sale-113', 'cust-054', '02-Aug-2020', 'Prod-014', 'br-009', 'empl_083');
  insert into Local_sales values ('Sale-114', 'cust-247', '28-Mar-2020', 'Prod-037', 'br-010', 'empl_034');
  insert into Local_sales values ('Sale-115', 'cust-104', '10-Jan-2020', 'Prod-035', 'br-018', 'empl_068');
  insert into Local_sales values ('Sale-116', 'cust-067', '23-Sep-2020', 'Prod-028', 'br-018', 'empl_092');
  insert into Local_sales values ('Sale-117', 'cust-117', '01-Oct-2020', 'Prod-040', 'br-014', 'empl_032');
  insert into Local_sales values ('Sale-118', 'cust-151', '03-Feb-2020', 'Prod-035', 'br-002', 'empl_033');
  insert into Local_sales values ('Sale-119', 'cust-006', '23-Apr-2020', 'Prod-019', 'br-018', 'empl_012');
  insert into Local_sales values ('Sale-120', 'cust-293', '20-Mar-2020', 'Prod-020', 'br-015', 'empl_013');
  insert into Local_sales values ('Sale-121', 'cust-011', '22-Apr-2020', 'Prod-001', 'br-013', 'empl_071');
  insert into Local_sales values ('Sale-122', 'cust-259', '26-Mar-2020', 'Prod-029', 'br-012', 'empl_092');
  insert into Local_sales values ('Sale-123', 'cust-037', '13-Nov-2020', 'Prod-017', 'br-020', 'empl_067');
  insert into Local_sales values ('Sale-124', 'cust-094', '07-Aug-2020', 'Prod-019', 'br-001', 'empl_026');
  insert into Local_sales values ('Sale-125', 'cust-077', '11-Oct-2020', 'Prod-034', 'br-006', 'empl_079');
  insert into Local_sales values ('Sale-126', 'cust-091', '29-Jul-2020', 'Prod-031', 'br-004', 'empl_023');
  insert into Local_sales values ('Sale-127', 'cust-019', '06-May-2020', 'Prod-038', 'br-012', 'empl_047');
  insert into Local_sales values ('Sale-128', 'cust-201', '03-Feb-2020', 'Prod-025', 'br-017', 'empl_015');
  insert into Local_sales values ('Sale-129', 'cust-225', '10-Mar-2020', 'Prod-002', 'br-016', 'empl_089');
  insert into Local_sales values ('Sale-130', 'cust-072', '21-Apr-2020', 'Prod-003', 'br-011', 'empl_036');
  insert into Local_sales values ('Sale-131', 'cust-057', '20-Nov-2020', 'Prod-039', 'br-017', 'empl_073');
  insert into Local_sales values ('Sale-132', 'cust-213', '22-Jul-2020', 'Prod-012', 'br-013', 'empl_022');
  insert into Local_sales values ('Sale-133', 'cust-064', '02-Nov-2020', 'Prod-015', 'br-004', 'empl_010');
  insert into Local_sales values ('Sale-134', 'cust-257', '23-Feb-2020', 'Prod-040', 'br-019', 'empl_027');
  insert into Local_sales values ('Sale-135', 'cust-071', '21-Mar-2020', 'Prod-009', 'br-013', 'empl_023');
  insert into Local_sales values ('Sale-136', 'cust-235', '10-Jun-2020', 'Prod-001', 'br-008', 'empl_088');
  insert into Local_sales values ('Sale-137', 'cust-186', '10-Jan-2020', 'Prod-018', 'br-019', 'empl_072');
  insert into Local_sales values ('Sale-138', 'cust-230', '06-May-2020', 'Prod-026', 'br-011', 'empl_092');
  insert into Local_sales values ('Sale-139', 'cust-157', '15-Oct-2020', 'Prod-036', 'br-020', 'empl_061');
  insert into Local_sales values ('Sale-140', 'cust-266', '31-Jan-2020', 'Prod-013', 'br-009', 'empl_014');
  insert into Local_sales values ('Sale-141', 'cust-008', '11-Aug-2020', 'Prod-015', 'br-005', 'empl_066');
  insert into Local_sales values ('Sale-142', 'cust-044', '10-Apr-2020', 'Prod-033', 'br-002', 'empl_084');
  insert into Local_sales values ('Sale-143', 'cust-062', '19-Mar-2020', 'Prod-025', 'br-005', 'empl_016');
  insert into Local_sales values ('Sale-144', 'cust-146', '21-Apr-2020', 'Prod-014', 'br-004', 'empl_023');
  insert into Local_sales values ('Sale-145', 'cust-082', '02-Jan-2020', 'Prod-030', 'br-018', 'empl_037');
  insert into Local_sales values ('Sale-146', 'cust-284', '20-Jan-2020', 'Prod-037', 'br-007', 'empl_082');
  insert into Local_sales values ('Sale-147', 'cust-114', '06-Apr-2020', 'Prod-016', 'br-001', 'empl_056');
  insert into Local_sales values ('Sale-148', 'cust-069', '05-Mar-2020', 'Prod-033', 'br-008', 'empl_007');
  insert into Local_sales values ('Sale-149', 'cust-238', '28-Jan-2020', 'Prod-038', 'br-020', 'empl_074');
  insert into Local_sales values ('Sale-150', 'cust-242', '14-Feb-2020', 'Prod-001', 'br-014', 'empl_050');
  insert into Local_sales values ('Sale-151', 'cust-085', '22-Nov-2020', 'Prod-035', 'br-010', 'empl_008');
  insert into Local_sales values ('Sale-152', 'cust-165', '06-Nov-2020', 'Prod-032', 'br-002', 'empl_092');
  insert into Local_sales values ('Sale-153', 'cust-160', '11-Jun-2020', 'Prod-004', 'br-009', 'empl_072');
  insert into Local_sales values ('Sale-154', 'cust-145', '11-Sep-2020', 'Prod-022', 'br-019', 'empl_099');
  insert into Local_sales values ('Sale-155', 'cust-174', '21-Jun-2020', 'Prod-025', 'br-001', 'empl_097');
  insert into Local_sales values ('Sale-156', 'cust-180', '20-Oct-2020', 'Prod-004', 'br-014', 'empl_076');
  insert into Local_sales values ('Sale-157', 'cust-130', '02-Jul-2020', 'Prod-019', 'br-009', 'empl_057');
  insert into Local_sales values ('Sale-158', 'cust-129', '02-Oct-2020', 'Prod-014', 'br-001', 'empl_002');
  insert into Local_sales values ('Sale-159', 'cust-030', '21-Nov-2020', 'Prod-035', 'br-007', 'empl_090');
  insert into Local_sales values ('Sale-160', 'cust-123', '12-Aug-2020', 'Prod-016', 'br-013', 'empl_047');
  insert into Local_sales values ('Sale-161', 'cust-247', '16-Nov-2020', 'Prod-029', 'br-006', 'empl_087');
  insert into Local_sales values ('Sale-162', 'cust-041', '13-May-2020', 'Prod-034', 'br-010', 'empl_012');
  insert into Local_sales values ('Sale-163', 'cust-154', '03-Apr-2020', 'Prod-010', 'br-018', 'empl_034');
  insert into Local_sales values ('Sale-164', 'cust-264', '23-Oct-2020', 'Prod-007', 'br-003', 'empl_029');
  insert into Local_sales values ('Sale-165', 'cust-121', '12-Jun-2020', 'Prod-026', 'br-009', 'empl_029');
  insert into Local_sales values ('Sale-166', 'cust-018', '11-Dec-2020', 'Prod-007', 'br-020', 'empl_016');
  insert into Local_sales values ('Sale-167', 'cust-190', '10-Jul-2020', 'Prod-026', 'br-020', 'empl_042');
  insert into Local_sales values ('Sale-168', 'cust-269', '25-Feb-2020', 'Prod-016', 'br-012', 'empl_077');
  insert into Local_sales values ('Sale-169', 'cust-079', '25-Sep-2020', 'Prod-010', 'br-015', 'empl_051');
  insert into Local_sales values ('Sale-170', 'cust-045', '11-Jan-2020', 'Prod-015', 'br-001', 'empl_100');
  insert into Local_sales values ('Sale-171', 'cust-165', '07-Aug-2020', 'Prod-033', 'br-008', 'empl_051');
  insert into Local_sales values ('Sale-172', 'cust-292', '12-Aug-2020', 'Prod-026', 'br-017', 'empl_059');
  insert into Local_sales values ('Sale-173', 'cust-009', '01-May-2020', 'Prod-005', 'br-008', 'empl_075');
  insert into Local_sales values ('Sale-174', 'cust-291', '18-Feb-2020', 'Prod-039', 'br-016', 'empl_066');
  insert into Local_sales values ('Sale-175', 'cust-024', '09-Mar-2020', 'Prod-039', 'br-014', 'empl_010');
  insert into Local_sales values ('Sale-176', 'cust-280', '17-Sep-2020', 'Prod-016', 'br-019', 'empl_082');
  insert into Local_sales values ('Sale-177', 'cust-079', '16-Aug-2020', 'Prod-005', 'br-001', 'empl_078');
  insert into Local_sales values ('Sale-178', 'cust-086', '03-Mar-2020', 'Prod-001', 'br-011', 'empl_059');
  insert into Local_sales values ('Sale-179', 'cust-064', '12-Jan-2020', 'Prod-038', 'br-006', 'empl_063');
  insert into Local_sales values ('Sale-180', 'cust-047', '10-Nov-2020', 'Prod-017', 'br-016', 'empl_077');
  insert into Local_sales values ('Sale-181', 'cust-030', '15-Dec-2020', 'Prod-027', 'br-004', 'empl_082');
  insert into Local_sales values ('Sale-182', 'cust-062', '27-Mar-2020', 'Prod-040', 'br-009', 'empl_020');
  insert into Local_sales values ('Sale-183', 'cust-131', '19-Aug-2020', 'Prod-015', 'br-007', 'empl_097');
  insert into Local_sales values ('Sale-184', 'cust-269', '19-Jun-2020', 'Prod-034', 'br-012', 'empl_078');
  insert into Local_sales values ('Sale-185', 'cust-276', '27-Nov-2020', 'Prod-024', 'br-006', 'empl_095');
  insert into Local_sales values ('Sale-186', 'cust-263', '02-Nov-2020', 'Prod-027', 'br-008', 'empl_096');
  insert into Local_sales values ('Sale-187', 'cust-151', '03-Sep-2020', 'Prod-006', 'br-015', 'empl_060');
  insert into Local_sales values ('Sale-188', 'cust-230', '04-Dec-2020', 'Prod-005', 'br-004', 'empl_036');
  insert into Local_sales values ('Sale-189', 'cust-179', '06-Oct-2020', 'Prod-003', 'br-013', 'empl_008');
  insert into Local_sales values ('Sale-190', 'cust-255', '30-Aug-2020', 'Prod-035', 'br-019', 'empl_009');
  insert into Local_sales values ('Sale-191', 'cust-196', '03-Aug-2020', 'Prod-034', 'br-005', 'empl_011');
  insert into Local_sales values ('Sale-192', 'cust-106', '22-Jan-2020', 'Prod-028', 'br-004', 'empl_072');
  insert into Local_sales values ('Sale-193', 'cust-206', '03-Apr-2020', 'Prod-008', 'br-007', 'empl_023');
  insert into Local_sales values ('Sale-194', 'cust-118', '14-Nov-2020', 'Prod-036', 'br-012', 'empl_041');
  insert into Local_sales values ('Sale-195', 'cust-017', '17-Mar-2020', 'Prod-014', 'br-018', 'empl_005');
  insert into Local_sales values ('Sale-196', 'cust-027', '04-Aug-2020', 'Prod-005', 'br-017', 'empl_084');
  insert into Local_sales values ('Sale-197', 'cust-159', '30-Oct-2020', 'Prod-011', 'br-005', 'empl_099');
  insert into Local_sales values ('Sale-198', 'cust-280', '18-Oct-2020', 'Prod-039', 'br-013', 'empl_056');
  insert into Local_sales values ('Sale-199', 'cust-138', '17-Jun-2020', 'Prod-005', 'br-018', 'empl_004');
  insert into Local_sales values ('Sale-200', 'cust-244', '04-Jul-2020', 'Prod-034', 'br-011', 'empl_021');
  insert into Local_sales values ('Sale-201', 'cust-292', '12-Mar-2020', 'Prod-001', 'br-016', 'empl_053');
  insert into Local_sales values ('Sale-202', 'cust-181', '14-Dec-2020', 'Prod-034', 'br-012', 'empl_062');
  insert into Local_sales values ('Sale-203', 'cust-053', '10-Jul-2020', 'Prod-038', 'br-009', 'empl_037');
  insert into Local_sales values ('Sale-204', 'cust-284', '20-Jun-2020', 'Prod-040', 'br-013', 'empl_091');
  insert into Local_sales values ('Sale-205', 'cust-123', '04-Apr-2020', 'Prod-021', 'br-020', 'empl_012');
  insert into Local_sales values ('Sale-206', 'cust-098', '29-Oct-2020', 'Prod-015', 'br-001', 'empl_056');
  insert into Local_sales values ('Sale-207', 'cust-171', '13-Mar-2020', 'Prod-026', 'br-001', 'empl_078');
  insert into Local_sales values ('Sale-208', 'cust-046', '29-Jun-2020', 'Prod-003', 'br-014', 'empl_082');
  insert into Local_sales values ('Sale-209', 'cust-213', '30-Aug-2020', 'Prod-002', 'br-012', 'empl_019');
  insert into Local_sales values ('Sale-210', 'cust-263', '10-Mar-2020', 'Prod-029', 'br-015', 'empl_048');
  insert into Local_sales values ('Sale-211', 'cust-130', '27-Jun-2020', 'Prod-005', 'br-011', 'empl_020');
  insert into Local_sales values ('Sale-212', 'cust-017', '12-Feb-2020', 'Prod-009', 'br-019', 'empl_066');
  insert into Local_sales values ('Sale-213', 'cust-162', '08-Jun-2020', 'Prod-026', 'br-012', 'empl_038');
  insert into Local_sales values ('Sale-214', 'cust-002', '19-May-2020', 'Prod-038', 'br-020', 'empl_048');
  insert into Local_sales values ('Sale-215', 'cust-262', '11-Nov-2020', 'Prod-016', 'br-010', 'empl_047');
  insert into Local_sales values ('Sale-216', 'cust-191', '21-Oct-2020', 'Prod-030', 'br-001', 'empl_063');
  insert into Local_sales values ('Sale-217', 'cust-178', '05-Feb-2020', 'Prod-019', 'br-007', 'empl_010');
  insert into Local_sales values ('Sale-218', 'cust-260', '26-Feb-2020', 'Prod-002', 'br-010', 'empl_076');
  insert into Local_sales values ('Sale-219', 'cust-241', '07-Aug-2020', 'Prod-028', 'br-019', 'empl_054');
  insert into Local_sales values ('Sale-220', 'cust-084', '27-Nov-2020', 'Prod-023', 'br-012', 'empl_028');
  insert into Local_sales values ('Sale-221', 'cust-295', '16-Dec-2020', 'Prod-012', 'br-002', 'empl_085');
  insert into Local_sales values ('Sale-222', 'cust-080', '12-Jun-2020', 'Prod-025', 'br-007', 'empl_094');
  insert into Local_sales values ('Sale-223', 'cust-020', '07-Sep-2020', 'Prod-003', 'br-012', 'empl_065');
  insert into Local_sales values ('Sale-224', 'cust-114', '04-Feb-2020', 'Prod-018', 'br-019', 'empl_084');
  insert into Local_sales values ('Sale-225', 'cust-031', '13-Jul-2020', 'Prod-014', 'br-006', 'empl_078');
  insert into Local_sales values ('Sale-226', 'cust-254', '02-Mar-2020', 'Prod-016', 'br-007', 'empl_075');
  insert into Local_sales values ('Sale-227', 'cust-055', '08-Apr-2020', 'Prod-027', 'br-010', 'empl_090');
  insert into Local_sales values ('Sale-228', 'cust-197', '12-Jun-2020', 'Prod-021', 'br-009', 'empl_079');
  insert into Local_sales values ('Sale-229', 'cust-155', '16-Nov-2020', 'Prod-008', 'br-016', 'empl_091');
  insert into Local_sales values ('Sale-230', 'cust-076', '03-Jul-2020', 'Prod-015', 'br-005', 'empl_013');
  insert into Local_sales values ('Sale-231', 'cust-257', '29-Jan-2020', 'Prod-032', 'br-006', 'empl_092');
  insert into Local_sales values ('Sale-232', 'cust-269', '30-Dec-2020', 'Prod-033', 'br-001', 'empl_050');
  insert into Local_sales values ('Sale-233', 'cust-264', '14-Jan-2020', 'Prod-004', 'br-002', 'empl_009');
  insert into Local_sales values ('Sale-234', 'cust-289', '25-Jan-2020', 'Prod-028', 'br-008', 'empl_063');
  insert into Local_sales values ('Sale-235', 'cust-161', '05-Jan-2020', 'Prod-021', 'br-006', 'empl_034');
  insert into Local_sales values ('Sale-236', 'cust-102', '02-Jan-2020', 'Prod-010', 'br-010', 'empl_009');
  insert into Local_sales values ('Sale-237', 'cust-198', '01-Jan-2020', 'Prod-031', 'br-006', 'empl_060');
  insert into Local_sales values ('Sale-238', 'cust-237', '16-Mar-2020', 'Prod-037', 'br-001', 'empl_008');
  insert into Local_sales values ('Sale-239', 'cust-275', '30-Jul-2020', 'Prod-009', 'br-016', 'empl_079');
  insert into Local_sales values ('Sale-240', 'cust-061', '30-Nov-2020', 'Prod-040', 'br-015', 'empl_017');
  insert into Local_sales values ('Sale-241', 'cust-253', '04-May-2020', 'Prod-024', 'br-004', 'empl_058');
  insert into Local_sales values ('Sale-242', 'cust-224', '27-Oct-2020', 'Prod-010', 'br-013', 'empl_086');
  insert into Local_sales values ('Sale-243', 'cust-115', '31-Aug-2020', 'Prod-012', 'br-003', 'empl_059');
  insert into Local_sales values ('Sale-244', 'cust-046', '04-Apr-2020', 'Prod-033', 'br-003', 'empl_100');
  insert into Local_sales values ('Sale-245', 'cust-264', '14-Mar-2020', 'Prod-008', 'br-012', 'empl_086');
  insert into Local_sales values ('Sale-246', 'cust-103', '13-Feb-2020', 'Prod-018', 'br-004', 'empl_087');
  insert into Local_sales values ('Sale-247', 'cust-203', '12-Dec-2020', 'Prod-032', 'br-006', 'empl_043');
  insert into Local_sales values ('Sale-248', 'cust-247', '01-Nov-2020', 'Prod-026', 'br-019', 'empl_051');
  insert into Local_sales values ('Sale-249', 'cust-300', '08-May-2020', 'Prod-016', 'br-012', 'empl_013');
  insert into Local_sales values ('Sale-250', 'cust-134', '04-Mar-2020', 'Prod-034', 'br-016', 'empl_058');
  insert into Local_sales values ('Sale-251', 'cust-160', '25-Nov-2020', 'Prod-013', 'br-005', 'empl_064');
  insert into Local_sales values ('Sale-252', 'cust-118', '13-Apr-2020', 'Prod-003', 'br-008', 'empl_011');
  insert into Local_sales values ('Sale-253', 'cust-037', '30-Sep-2020', 'Prod-027', 'br-010', 'empl_023');
  insert into Local_sales values ('Sale-254', 'cust-110', '19-Jul-2020', 'Prod-013', 'br-010', 'empl_040');
  insert into Local_sales values ('Sale-255', 'cust-037', '20-Jun-2020', 'Prod-011', 'br-014', 'empl_012');
  insert into Local_sales values ('Sale-256', 'cust-023', '17-Jan-2020', 'Prod-023', 'br-004', 'empl_076');
  insert into Local_sales values ('Sale-257', 'cust-205', '29-Jan-2020', 'Prod-018', 'br-018', 'empl_038');
  insert into Local_sales values ('Sale-258', 'cust-235', '10-Jun-2020', 'Prod-022', 'br-020', 'empl_008');
  insert into Local_sales values ('Sale-259', 'cust-299', '15-Sep-2020', 'Prod-037', 'br-003', 'empl_067');
  insert into Local_sales values ('Sale-260', 'cust-151', '12-Jan-2020', 'Prod-025', 'br-011', 'empl_039');
  insert into Local_sales values ('Sale-261', 'cust-290', '18-Aug-2020', 'Prod-024', 'br-019', 'empl_075');
  insert into Local_sales values ('Sale-262', 'cust-170', '23-Apr-2020', 'Prod-011', 'br-006', 'empl_021');
  insert into Local_sales values ('Sale-263', 'cust-132', '04-May-2020', 'Prod-040', 'br-010', 'empl_037');
  insert into Local_sales values ('Sale-264', 'cust-205', '08-Mar-2020', 'Prod-010', 'br-004', 'empl_016');
  insert into Local_sales values ('Sale-265', 'cust-190', '08-Dec-2020', 'Prod-034', 'br-008', 'empl_014');
  insert into Local_sales values ('Sale-266', 'cust-238', '28-Jun-2020', 'Prod-008', 'br-009', 'empl_062');
  insert into Local_sales values ('Sale-267', 'cust-023', '18-Nov-2020', 'Prod-035', 'br-018', 'empl_002');
  insert into Local_sales values ('Sale-268', 'cust-298', '20-Mar-2020', 'Prod-007', 'br-016', 'empl_051');
  insert into Local_sales values ('Sale-269', 'cust-287', '12-Jan-2020', 'Prod-017', 'br-007', 'empl_026');
  insert into Local_sales values ('Sale-270', 'cust-065', '19-May-2020', 'Prod-036', 'br-004', 'empl_085');
  insert into Local_sales values ('Sale-271', 'cust-282', '11-Jul-2020', 'Prod-003', 'br-012', 'empl_081');
  insert into Local_sales values ('Sale-272', 'cust-227', '06-May-2020', 'Prod-027', 'br-001', 'empl_029');
  insert into Local_sales values ('Sale-273', 'cust-182', '09-May-2020', 'Prod-031', 'br-011', 'empl_068');
  insert into Local_sales values ('Sale-274', 'cust-042', '28-Apr-2020', 'Prod-014', 'br-004', 'empl_026');
  insert into Local_sales values ('Sale-275', 'cust-269', '09-Sep-2020', 'Prod-001', 'br-018', 'empl_001');
  insert into Local_sales values ('Sale-276', 'cust-276', '02-Mar-2020', 'Prod-036', 'br-018', 'empl_073');
  insert into Local_sales values ('Sale-277', 'cust-252', '01-Jul-2020', 'Prod-009', 'br-008', 'empl_023');
  insert into Local_sales values ('Sale-278', 'cust-075', '10-Jan-2020', 'Prod-037', 'br-006', 'empl_039');
  insert into Local_sales values ('Sale-279', 'cust-272', '07-Jun-2020', 'Prod-025', 'br-005', 'empl_020');
  insert into Local_sales values ('Sale-280', 'cust-198', '26-Dec-2020', 'Prod-012', 'br-005', 'empl_077');
  insert into Local_sales values ('Sale-281', 'cust-242', '09-Mar-2020', 'Prod-035', 'br-016', 'empl_042');
  insert into Local_sales values ('Sale-282', 'cust-133', '01-Feb-2020', 'Prod-033', 'br-006', 'empl_072');
  insert into Local_sales values ('Sale-283', 'cust-169', '02-Jan-2020', 'Prod-026', 'br-017', 'empl_076');
  insert into Local_sales values ('Sale-284', 'cust-269', '01-Nov-2020', 'Prod-037', 'br-004', 'empl_064');
  insert into Local_sales values ('Sale-285', 'cust-137', '22-Oct-2020', 'Prod-033', 'br-012', 'empl_074');
  insert into Local_sales values ('Sale-286', 'cust-229', '16-Jul-2020', 'Prod-007', 'br-003', 'empl_058');
  insert into Local_sales values ('Sale-287', 'cust-296', '23-Jul-2020', 'Prod-026', 'br-002', 'empl_033');
  insert into Local_sales values ('Sale-288', 'cust-041', '19-Jun-2020', 'Prod-035', 'br-020', 'empl_003');
  insert into Local_sales values ('Sale-289', 'cust-266', '12-May-2020', 'Prod-021', 'br-001', 'empl_063');
  insert into Local_sales values ('Sale-290', 'cust-176', '25-Oct-2020', 'Prod-008', 'br-004', 'empl_084');
  insert into Local_sales values ('Sale-291', 'cust-207', '13-Apr-2020', 'Prod-035', 'br-020', 'empl_047');
  insert into Local_sales values ('Sale-292', 'cust-012', '27-Apr-2020', 'Prod-016', 'br-011', 'empl_089');
  insert into Local_sales values ('Sale-293', 'cust-047', '28-Nov-2020', 'Prod-006', 'br-016', 'empl_040');
  insert into Local_sales values ('Sale-294', 'cust-290', '01-Mar-2020', 'Prod-001', 'br-012', 'empl_007');
  insert into Local_sales values ('Sale-295', 'cust-031', '06-Jul-2020', 'Prod-029', 'br-010', 'empl_057');
  insert into Local_sales values ('Sale-296', 'cust-009', '16-Dec-2020', 'Prod-029', 'br-012', 'empl_059');
  insert into Local_sales values ('Sale-297', 'cust-220', '12-Jun-2020', 'Prod-017', 'br-011', 'empl_012');
  insert into Local_sales values ('Sale-298', 'cust-180', '02-Mar-2020', 'Prod-021', 'br-006', 'empl_019');
  insert into Local_sales values ('Sale-299', 'cust-054', '17-Sep-2020', 'Prod-005', 'br-016', 'empl_043');
  insert into Local_sales values ('Sale-300', 'cust-023', '15-May-2020', 'Prod-022', 'br-017', 'empl_076');
  insert into Local_sales values ('Sale-301', 'cust-150', '25-Dec-2020', 'Prod-033', 'br-015', 'empl_050');
  insert into Local_sales values ('Sale-302', 'cust-176', '15-Apr-2020', 'Prod-016', 'br-004', 'empl_091');
  insert into Local_sales values ('Sale-303', 'cust-090', '26-Mar-2020', 'Prod-024', 'br-001', 'empl_009');
  insert into Local_sales values ('Sale-304', 'cust-274', '24-May-2020', 'Prod-020', 'br-017', 'empl_066');
  insert into Local_sales values ('Sale-305', 'cust-060', '09-Nov-2020', 'Prod-006', 'br-001', 'empl_067');
  insert into Local_sales values ('Sale-306', 'cust-260', '27-Jan-2020', 'Prod-021', 'br-001', 'empl_054');
  insert into Local_sales values ('Sale-307', 'cust-071', '01-Jun-2020', 'Prod-014', 'br-001', 'empl_044');
  insert into Local_sales values ('Sale-308', 'cust-236', '09-Sep-2020', 'Prod-005', 'br-016', 'empl_033');
  insert into Local_sales values ('Sale-309', 'cust-230', '15-Sep-2020', 'Prod-034', 'br-016', 'empl_077');
  insert into Local_sales values ('Sale-310', 'cust-061', '16-Jan-2020', 'Prod-011', 'br-007', 'empl_076');
  insert into Local_sales values ('Sale-311', 'cust-062', '14-Jul-2020', 'Prod-016', 'br-014', 'empl_069');
  insert into Local_sales values ('Sale-312', 'cust-196', '04-Sep-2020', 'Prod-039', 'br-015', 'empl_014');
  insert into Local_sales values ('Sale-313', 'cust-287', '01-Jun-2020', 'Prod-021', 'br-020', 'empl_061');
  insert into Local_sales values ('Sale-314', 'cust-165', '30-Nov-2020', 'Prod-001', 'br-017', 'empl_062');
  insert into Local_sales values ('Sale-315', 'cust-102', '10-Sep-2020', 'Prod-028', 'br-004', 'empl_007');
  insert into Local_sales values ('Sale-316', 'cust-040', '04-Jan-2020', 'Prod-011', 'br-002', 'empl_077');
  insert into Local_sales values ('Sale-317', 'cust-005', '07-May-2020', 'Prod-010', 'br-017', 'empl_082');
  insert into Local_sales values ('Sale-318', 'cust-187', '08-Jun-2020', 'Prod-028', 'br-008', 'empl_047');
  insert into Local_sales values ('Sale-319', 'cust-058', '20-Sep-2020', 'Prod-039', 'br-007', 'empl_085');
  insert into Local_sales values ('Sale-320', 'cust-225', '16-May-2020', 'Prod-036', 'br-009', 'empl_017');
  insert into Local_sales values ('Sale-321', 'cust-101', '18-Mar-2020', 'Prod-021', 'br-017', 'empl_009');
  insert into Local_sales values ('Sale-322', 'cust-072', '03-Oct-2020', 'Prod-021', 'br-005', 'empl_029');
  insert into Local_sales values ('Sale-323', 'cust-027', '01-Mar-2020', 'Prod-009', 'br-006', 'empl_015');
  insert into Local_sales values ('Sale-324', 'cust-273', '30-Mar-2020', 'Prod-001', 'br-020', 'empl_015');
  insert into Local_sales values ('Sale-325', 'cust-295', '13-Aug-2020', 'Prod-038', 'br-012', 'empl_036');
  insert into Local_sales values ('Sale-326', 'cust-063', '28-Jun-2020', 'Prod-037', 'br-001', 'empl_071');
  insert into Local_sales values ('Sale-327', 'cust-013', '07-Feb-2020', 'Prod-010', 'br-008', 'empl_073');
  insert into Local_sales values ('Sale-328', 'cust-093', '25-Dec-2020', 'Prod-035', 'br-001', 'empl_029');
  insert into Local_sales values ('Sale-329', 'cust-235', '10-Jan-2020', 'Prod-022', 'br-016', 'empl_045');
  insert into Local_sales values ('Sale-330', 'cust-288', '21-Jun-2020', 'Prod-003', 'br-010', 'empl_011');
  insert into Local_sales values ('Sale-331', 'cust-237', '31-Jul-2020', 'Prod-026', 'br-009', 'empl_005');
  insert into Local_sales values ('Sale-332', 'cust-073', '19-Oct-2020', 'Prod-026', 'br-015', 'empl_035');
  insert into Local_sales values ('Sale-333', 'cust-063', '10-Sep-2020', 'Prod-013', 'br-007', 'empl_018');
  insert into Local_sales values ('Sale-334', 'cust-221', '21-Mar-2020', 'Prod-031', 'br-004', 'empl_039');
  insert into Local_sales values ('Sale-335', 'cust-271', '17-Jun-2020', 'Prod-010', 'br-019', 'empl_025');
  insert into Local_sales values ('Sale-336', 'cust-086', '04-Jul-2020', 'Prod-032', 'br-015', 'empl_057');
  insert into Local_sales values ('Sale-337', 'cust-204', '27-Feb-2020', 'Prod-002', 'br-009', 'empl_021');
  insert into Local_sales values ('Sale-338', 'cust-041', '13-May-2020', 'Prod-020', 'br-004', 'empl_068');
  insert into Local_sales values ('Sale-339', 'cust-053', '26-Mar-2020', 'Prod-031', 'br-011', 'empl_035');
  insert into Local_sales values ('Sale-340', 'cust-202', '07-Sep-2020', 'Prod-002', 'br-015', 'empl_073');
  insert into Local_sales values ('Sale-341', 'cust-180', '14-Jun-2020', 'Prod-029', 'br-006', 'empl_066');
  insert into Local_sales values ('Sale-342', 'cust-287', '01-Jan-2020', 'Prod-012', 'br-002', 'empl_072');
  insert into Local_sales values ('Sale-343', 'cust-273', '03-Dec-2020', 'Prod-023', 'br-014', 'empl_098');
  insert into Local_sales values ('Sale-344', 'cust-092', '23-Apr-2020', 'Prod-030', 'br-003', 'empl_002');
  insert into Local_sales values ('Sale-345', 'cust-231', '10-Jan-2020', 'Prod-033', 'br-014', 'empl_045');
  insert into Local_sales values ('Sale-346', 'cust-265', '22-Nov-2020', 'Prod-012', 'br-009', 'empl_044');
  insert into Local_sales values ('Sale-347', 'cust-206', '11-Feb-2020', 'Prod-037', 'br-016', 'empl_050');
  insert into Local_sales values ('Sale-348', 'cust-066', '27-May-2020', 'Prod-018', 'br-002', 'empl_065');
  insert into Local_sales values ('Sale-349', 'cust-198', '25-May-2020', 'Prod-017', 'br-009', 'empl_044');
  insert into Local_sales values ('Sale-350', 'cust-027', '10-Jan-2020', 'Prod-004', 'br-002', 'empl_052');
  insert into Local_sales values ('Sale-351', 'cust-095', '13-Sep-2020', 'Prod-031', 'br-002', 'empl_028');
  insert into Local_sales values ('Sale-352', 'cust-107', '07-Oct-2020', 'Prod-027', 'br-014', 'empl_037');
  insert into Local_sales values ('Sale-353', 'cust-248', '19-Dec-2020', 'Prod-002', 'br-013', 'empl_040');
  insert into Local_sales values ('Sale-354', 'cust-090', '05-May-2020', 'Prod-007', 'br-015', 'empl_008');
  insert into Local_sales values ('Sale-355', 'cust-052', '27-Jun-2020', 'Prod-002', 'br-020', 'empl_013');
  insert into Local_sales values ('Sale-356', 'cust-210', '11-Oct-2020', 'Prod-001', 'br-018', 'empl_078');
  insert into Local_sales values ('Sale-357', 'cust-205', '02-Mar-2020', 'Prod-007', 'br-016', 'empl_069');
  insert into Local_sales values ('Sale-358', 'cust-115', '09-Jan-2020', 'Prod-012', 'br-002', 'empl_062');
  insert into Local_sales values ('Sale-359', 'cust-120', '15-Aug-2020', 'Prod-004', 'br-005', 'empl_032');
  insert into Local_sales values ('Sale-360', 'cust-173', '26-Dec-2020', 'Prod-014', 'br-020', 'empl_062');
  insert into Local_sales values ('Sale-361', 'cust-135', '01-May-2020', 'Prod-018', 'br-014', 'empl_023');
  insert into Local_sales values ('Sale-362', 'cust-193', '22-Apr-2020', 'Prod-016', 'br-020', 'empl_044');
  insert into Local_sales values ('Sale-363', 'cust-006', '20-Aug-2020', 'Prod-007', 'br-001', 'empl_021');
  insert into Local_sales values ('Sale-364', 'cust-168', '09-Nov-2020', 'Prod-028', 'br-017', 'empl_061');
  insert into Local_sales values ('Sale-365', 'cust-100', '19-Nov-2020', 'Prod-007', 'br-016', 'empl_088');
  insert into Local_sales values ('Sale-366', 'cust-010', '11-Nov-2020', 'Prod-012', 'br-007', 'empl_076');
  insert into Local_sales values ('Sale-367', 'cust-069', '31-Oct-2020', 'Prod-029', 'br-008', 'empl_083');
  insert into Local_sales values ('Sale-368', 'cust-010', '08-May-2020', 'Prod-013', 'br-014', 'empl_072');
  insert into Local_sales values ('Sale-369', 'cust-035', '07-Sep-2020', 'Prod-011', 'br-008', 'empl_091');
  insert into Local_sales values ('Sale-370', 'cust-155', '02-Apr-2020', 'Prod-040', 'br-018', 'empl_083');
  insert into Local_sales values ('Sale-371', 'cust-152', '25-Sep-2020', 'Prod-024', 'br-002', 'empl_073');
  insert into Local_sales values ('Sale-372', 'cust-029', '21-Oct-2020', 'Prod-039', 'br-013', 'empl_090');
  insert into Local_sales values ('Sale-373', 'cust-299', '23-Nov-2020', 'Prod-035', 'br-005', 'empl_078');
  insert into Local_sales values ('Sale-374', 'cust-131', '24-Jun-2020', 'Prod-004', 'br-012', 'empl_035');
  insert into Local_sales values ('Sale-375', 'cust-175', '07-Jun-2020', 'Prod-017', 'br-013', 'empl_083');
  insert into Local_sales values ('Sale-376', 'cust-219', '05-Jan-2020', 'Prod-011', 'br-015', 'empl_075');
  insert into Local_sales values ('Sale-377', 'cust-214', '03-Sep-2020', 'Prod-034', 'br-001', 'empl_024');
  insert into Local_sales values ('Sale-378', 'cust-100', '04-Nov-2020', 'Prod-027', 'br-003', 'empl_043');
  insert into Local_sales values ('Sale-379', 'cust-153', '16-Sep-2020', 'Prod-016', 'br-005', 'empl_019');
  insert into Local_sales values ('Sale-380', 'cust-206', '29-Dec-2020', 'Prod-019', 'br-019', 'empl_033');
  insert into Local_sales values ('Sale-381', 'cust-166', '21-Apr-2020', 'Prod-014', 'br-015', 'empl_073');
  insert into Local_sales values ('Sale-382', 'cust-169', '13-Dec-2020', 'Prod-003', 'br-010', 'empl_009');
  insert into Local_sales values ('Sale-383', 'cust-115', '17-Mar-2020', 'Prod-001', 'br-014', 'empl_046');
  insert into Local_sales values ('Sale-384', 'cust-175', '11-Aug-2020', 'Prod-026', 'br-010', 'empl_034');
  insert into Local_sales values ('Sale-385', 'cust-048', '29-Jun-2020', 'Prod-006', 'br-004', 'empl_022');
  insert into Local_sales values ('Sale-386', 'cust-038', '16-Sep-2020', 'Prod-014', 'br-008', 'empl_082');
  insert into Local_sales values ('Sale-387', 'cust-021', '01-Oct-2020', 'Prod-016', 'br-014', 'empl_084');
  insert into Local_sales values ('Sale-388', 'cust-087', '08-Jul-2020', 'Prod-036', 'br-012', 'empl_084');
  insert into Local_sales values ('Sale-389', 'cust-191', '15-Aug-2020', 'Prod-035', 'br-019', 'empl_029');
  insert into Local_sales values ('Sale-390', 'cust-213', '10-Mar-2020', 'Prod-005', 'br-002', 'empl_017');
  insert into Local_sales values ('Sale-391', 'cust-243', '15-Sep-2020', 'Prod-025', 'br-008', 'empl_032');
  insert into Local_sales values ('Sale-392', 'cust-030', '22-Feb-2020', 'Prod-037', 'br-015', 'empl_047');
  insert into Local_sales values ('Sale-393', 'cust-006', '23-Dec-2020', 'Prod-006', 'br-008', 'empl_077');
  insert into Local_sales values ('Sale-394', 'cust-003', '05-Apr-2020', 'Prod-001', 'br-016', 'empl_050');
  insert into Local_sales values ('Sale-395', 'cust-116', '17-Aug-2020', 'Prod-001', 'br-001', 'empl_050');
  insert into Local_sales values ('Sale-396', 'cust-019', '12-May-2020', 'Prod-015', 'br-016', 'empl_100');
  insert into Local_sales values ('Sale-397', 'cust-093', '01-Oct-2020', 'Prod-013', 'br-004', 'empl_050');
  insert into Local_sales values ('Sale-398', 'cust-154', '24-Feb-2020', 'Prod-017', 'br-006', 'empl_084');
  insert into Local_sales values ('Sale-399', 'cust-224', '28-Jan-2020', 'Prod-012', 'br-014', 'empl_063');
  insert into Local_sales values ('Sale-400', 'cust-226', '28-Jun-2020', 'Prod-003', 'br-015', 'empl_005');
  insert into Local_sales values ('Sale-401', 'cust-197', '30-Jul-2020', 'Prod-035', 'br-019', 'empl_036');
  insert into Local_sales values ('Sale-402', 'cust-069', '22-Mar-2020', 'Prod-008', 'br-017', 'empl_084');
  insert into Local_sales values ('Sale-403', 'cust-163', '08-Jan-2020', 'Prod-030', 'br-016', 'empl_093');
  insert into Local_sales values ('Sale-404', 'cust-006', '07-Dec-2020', 'Prod-022', 'br-010', 'empl_031');
  insert into Local_sales values ('Sale-405', 'cust-041', '15-Jan-2020', 'Prod-031', 'br-019', 'empl_015');
  insert into Local_sales values ('Sale-406', 'cust-171', '01-Oct-2020', 'Prod-020', 'br-014', 'empl_030');
  insert into Local_sales values ('Sale-407', 'cust-142', '21-Oct-2020', 'Prod-032', 'br-007', 'empl_093');
  insert into Local_sales values ('Sale-408', 'cust-124', '03-May-2020', 'Prod-032', 'br-018', 'empl_046');
  insert into Local_sales values ('Sale-409', 'cust-179', '09-Mar-2020', 'Prod-040', 'br-001', 'empl_012');
  insert into Local_sales values ('Sale-410', 'cust-123', '16-Dec-2020', 'Prod-036', 'br-018', 'empl_039');
  insert into Local_sales values ('Sale-411', 'cust-026', '04-Jul-2020', 'Prod-032', 'br-008', 'empl_071');
  insert into Local_sales values ('Sale-412', 'cust-286', '12-Jan-2020', 'Prod-027', 'br-020', 'empl_076');
  insert into Local_sales values ('Sale-413', 'cust-083', '01-Jul-2020', 'Prod-037', 'br-003', 'empl_003');
  insert into Local_sales values ('Sale-414', 'cust-014', '22-Nov-2020', 'Prod-012', 'br-018', 'empl_027');
  insert into Local_sales values ('Sale-415', 'cust-228', '28-May-2020', 'Prod-013', 'br-008', 'empl_017');
  insert into Local_sales values ('Sale-416', 'cust-189', '30-Jan-2020', 'Prod-016', 'br-020', 'empl_075');
  insert into Local_sales values ('Sale-417', 'cust-165', '19-Sep-2020', 'Prod-007', 'br-016', 'empl_061');
  insert into Local_sales values ('Sale-418', 'cust-150', '21-Jan-2020', 'Prod-007', 'br-020', 'empl_068');
  insert into Local_sales values ('Sale-419', 'cust-086', '21-Sep-2020', 'Prod-033', 'br-006', 'empl_010');
  insert into Local_sales values ('Sale-420', 'cust-125', '25-Oct-2020', 'Prod-029', 'br-012', 'empl_080');
  insert into Local_sales values ('Sale-421', 'cust-160', '15-Aug-2020', 'Prod-011', 'br-017', 'empl_098');
  insert into Local_sales values ('Sale-422', 'cust-002', '15-Sep-2020', 'Prod-026', 'br-010', 'empl_099');
  insert into Local_sales values ('Sale-423', 'cust-108', '03-Sep-2020', 'Prod-026', 'br-003', 'empl_011');
  insert into Local_sales values ('Sale-424', 'cust-188', '21-Oct-2020', 'Prod-013', 'br-018', 'empl_028');
  insert into Local_sales values ('Sale-425', 'cust-174', '23-Jun-2020', 'Prod-026', 'br-007', 'empl_084');
  insert into Local_sales values ('Sale-426', 'cust-031', '30-Nov-2020', 'Prod-006', 'br-002', 'empl_049');
  insert into Local_sales values ('Sale-427', 'cust-007', '04-Feb-2020', 'Prod-029', 'br-002', 'empl_002');
  insert into Local_sales values ('Sale-428', 'cust-174', '24-Feb-2020', 'Prod-009', 'br-003', 'empl_029');
  insert into Local_sales values ('Sale-429', 'cust-105', '17-Jan-2020', 'Prod-040', 'br-019', 'empl_067');
  insert into Local_sales values ('Sale-430', 'cust-101', '03-Jan-2020', 'Prod-012', 'br-007', 'empl_089');
  insert into Local_sales values ('Sale-431', 'cust-110', '05-Jun-2020', 'Prod-034', 'br-007', 'empl_077');
  insert into Local_sales values ('Sale-432', 'cust-121', '30-Jul-2020', 'Prod-004', 'br-015', 'empl_009');
  insert into Local_sales values ('Sale-433', 'cust-011', '17-Apr-2020', 'Prod-039', 'br-012', 'empl_087');
  insert into Local_sales values ('Sale-434', 'cust-210', '21-Apr-2020', 'Prod-027', 'br-011', 'empl_060');
  insert into Local_sales values ('Sale-435', 'cust-115', '30-Sep-2020', 'Prod-038', 'br-007', 'empl_064');
  insert into Local_sales values ('Sale-436', 'cust-034', '16-Dec-2020', 'Prod-028', 'br-004', 'empl_003');
  insert into Local_sales values ('Sale-437', 'cust-202', '16-Oct-2020', 'Prod-009', 'br-010', 'empl_100');
  insert into Local_sales values ('Sale-438', 'cust-300', '12-Nov-2020', 'Prod-023', 'br-007', 'empl_015');
  insert into Local_sales values ('Sale-439', 'cust-075', '23-Oct-2020', 'Prod-017', 'br-012', 'empl_016');
  insert into Local_sales values ('Sale-440', 'cust-027', '28-Jan-2020', 'Prod-031', 'br-020', 'empl_099');
  insert into Local_sales values ('Sale-441', 'cust-271', '13-Aug-2020', 'Prod-013', 'br-016', 'empl_087');
  insert into Local_sales values ('Sale-442', 'cust-183', '13-Dec-2020', 'Prod-027', 'br-014', 'empl_040');
  insert into Local_sales values ('Sale-443', 'cust-118', '24-May-2020', 'Prod-020', 'br-004', 'empl_078');
  insert into Local_sales values ('Sale-444', 'cust-102', '16-Nov-2020', 'Prod-018', 'br-018', 'empl_067');
  insert into Local_sales values ('Sale-445', 'cust-052', '04-Sep-2020', 'Prod-004', 'br-012', 'empl_047');
  insert into Local_sales values ('Sale-446', 'cust-008', '19-Dec-2020', 'Prod-015', 'br-014', 'empl_020');
  insert into Local_sales values ('Sale-447', 'cust-160', '14-Nov-2020', 'Prod-019', 'br-011', 'empl_075');
  insert into Local_sales values ('Sale-448', 'cust-159', '31-Jul-2020', 'Prod-008', 'br-009', 'empl_003');
  insert into Local_sales values ('Sale-449', 'cust-128', '05-Jul-2020', 'Prod-032', 'br-019', 'empl_006');
  insert into Local_sales values ('Sale-450', 'cust-164', '26-Jun-2020', 'Prod-004', 'br-020', 'empl_005');
  
  
  insert into Branches values ('br-001', 'NORTH', 'mgr_001', 1465, 37, 747);
  insert into Branches values ('br-002', 'NORTH', 'mgr_002', 1939, 59, 1082);
  insert into Branches values ('br-003', 'NORTH', 'mgr_003', 2102, 99, 1093);
  insert into Branches values ('br-004', 'NORTH', 'mgr_004', 2446, 100, 602);
  insert into Branches values ('br-005', 'SOUTH', 'mgr_005', 1560, 90, 1355);
  insert into Branches values ('br-006', 'EAST', 'mgr_006', 2202, 58, 1536);
  insert into Branches values ('br-007', 'EAST', 'mgr_007', 1159, 85, 1774);
  insert into Branches values ('br-008', 'SOUTH', 'mgr_008', 2651, 68, 1096);
  insert into Branches values ('br-009', 'SOUTH', 'mgr_009', 2266, 61, 1854);
  insert into Branches values ('br-010', 'SOUTH', 'mgr_010', 1095, 87, 1348);
  insert into Branches values ('br-011', 'EAST', 'mgr_011', 2210, 100, 2085);
  insert into Branches values ('br-012', 'EAST', 'mgr_012', 2711, 74, 1555);
  insert into Branches values ('br-013', 'WEST', 'mgr_013', 2616, 99, 2982);
  insert into Branches values ('br-014', 'WEST', 'mgr_014', 1037, 30, 3422);
  insert into Branches values ('br-015', 'CENTRAL', 'mgr_015', 2665, 20, 2946);
  insert into Branches values ('br-016', 'WEST', 'mgr_016', 2354, 67, 2725);
  insert into Branches values ('br-017', 'CENTRAL', 'mgr_017', 1321, 97, 2976);
  insert into Branches values ('br-018', 'WEST', 'mgr_018', 1603, 74, 2835);
  insert into Branches values ('br-019', 'CENTRAL', 'mgr_019', 2731, 69, 3058);
  insert into Branches values ('br-020', 'CENTRAL', 'mgr_020', 1970, 98, 3178);
  
  
  insert into Warehouses values ('wrh-001', 'North', 44, 'LOCAL');
  insert into Warehouses values ('wrh-002', 'East', 36, 'LOCAL');
  insert into Warehouses values ('wrh-003', 'South', 67, 'GLOBAL');
  insert into Warehouses values ('wrh-004', 'West', 61, 'GLOBAL');
  insert into Warehouses values ('wrh-005', 'Central', 83, 'GLOBAL');
  
  
  alter table Customers add constraint Customers_Cards_fk foreign key (Cust_card_code) references Cards (Card_id);
  
  alter table Games add constraint Games_Publishers_fk foreign key (Publisher) references Publishers (Publisher_name);
  
  alter table Employees add constraint Employees_Branches_fk foreign key (Branch_id) references Branches (Branch_id);
  
  alter table Online_orders add constraint Online_Customers_fk foreign key (Cust_id) references Customers (Cust_id);
  alter table Online_orders add constraint Online_Games_fk foreign key (Prod_id) references Games (Prod_id);
  alter table Online_orders add constraint Online_Warehouses_fk foreign key (Warehouse_id) references Warehouses (Warehouse_id);
  
  alter table Local_sales add constraint Local_Customers_fk foreign key (Cust_id) references Customers (Cust_id);
  alter table Local_sales add constraint Local_Games_fk foreign key (Prod_id) references Games (Prod_id);
  alter table Local_sales add constraint Local_Branches_fk foreign key (Branch_id) references Branches (Branch_id);
  alter table Local_sales add constraint Local_Employees_fk foreign key (Empl_id) references Employees (Empl_id);
  
  