Wendy Lewis Only

profilejbrider
jridersqldata.txt

-------------------------------------------------------- -- File created - Wednesday-April-19-2017 -------------------------------------------------------- -------------------------------------------------------- -- DDL for Table CUSTOMERS -------------------------------------------------------- CREATE TABLE "CM420F16"."CUSTOMERS" ( "CUST_ID" VARCHAR2(10 BYTE), "FIRST_NAME" VARCHAR2(15 BYTE), "MIDDLE_INITIAL" VARCHAR2(5 BYTE), "LAST_NAME" VARCHAR2(15 BYTE), "STREET_ADDRESS" VARCHAR2(30 BYTE), "CITY" VARCHAR2(15 BYTE), "STATE" VARCHAR2(20 BYTE), "ZIP" NUMBER(5,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Table FINANCING_PLANS -------------------------------------------------------- CREATE TABLE "CM420F16"."FINANCING_PLANS" ( "PLAN_ID" VARCHAR2(10 BYTE), "INSTITUTION" VARCHAR2(12 BYTE), "PERCENTAGE" VARCHAR2(12 BYTE), "LOAN_TYPE" VARCHAR2(12 BYTE), "MAX_TERM" NUMBER(*,0), "MIN_DOWN" NUMBER(10,0), "MAX_LOAN_AMT" NUMBER(10,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Table SALE_FINANCING -------------------------------------------------------- CREATE TABLE "CM420F16"."SALE_FINANCING" ( "SALE_ID" VARCHAR2(10 BYTE), "PLAN_ID" VARCHAR2(10 BYTE), "DOWNPAYMENT" NUMBER(10,0), "LOAN_TERM" NUMBER(5,0) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Table SALES -------------------------------------------------------- CREATE TABLE "CM420F16"."SALES" ( "SALE_ID" VARCHAR2(10 BYTE), "GROSS_SALE_PRICE" VARCHAR2(10 BYTE), "VIN" VARCHAR2(10 BYTE), "SALESPERSON_ID" VARCHAR2(10 BYTE), "CUST_ID" VARCHAR2(10 BYTE), "MILEAGE" VARCHAR2(10 BYTE), "SALE_DATE" VARCHAR2(15 BYTE), "VEHICLE_STATUS" VARCHAR2(10 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Table SALESPERSONS -------------------------------------------------------- CREATE TABLE "CM420F16"."SALESPERSONS" ( "SALESPERSON_ID" VARCHAR2(10 BYTE), "TITLE" VARCHAR2(15 BYTE), "FIRST_NAME" VARCHAR2(15 BYTE), "MIDDLE_INITIAL" VARCHAR2(5 BYTE), "LAST_NAME" VARCHAR2(15 BYTE), "HIRE_DATE" DATE ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Table VEHICLES -------------------------------------------------------- CREATE TABLE "CM420F16"."VEHICLES" ( "VIN" VARCHAR2(10 BYTE), "TYPE" VARCHAR2(12 BYTE), "MODEL" VARCHAR2(15 BYTE), "MAKE" VARCHAR2(15 BYTE), "TRADE_ID" VARCHAR2(10 BYTE), "WHOLESALE_COST" VARCHAR2(15 BYTE), "WHERE_FROM" VARCHAR2(15 BYTE) ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; REM INSERTING into CM420F16.CUSTOMERS SET DEFINE OFF; Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST001','DEIDRE','S','KIRKPATRICK','32 GREEN STREET','PENSACOLA','FL',32506); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST002','ELLEN','T','LEWIS','15 HILLSDALE DRIVE','CLARKSVILLE','TN',37040); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST003','FIONA','V','MARSHALL','5743 RED OAK DRIVE','NASHVILLE','MI',49074); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST004','GEORGE','W','NELSON','5453 OAKVALE DRIVE','HONOLULU','HI',96859); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST005','HERBERT','A','OBRIEN','2341 PINE OAK BLVD','SEMINOLE','AL',36574); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST006','DEIDRE','S','KIRK','32 ELM STREET','PENSACOLA','FL',32508); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST007','HELLEN','A','LEWIS','15 HILL DRIVE','CLARKSVILLE','TN',37041); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST008','FIONA','V','MARSH','2743 OAK DRIVE','NASHVILLE','MI',49074); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST009','MIKE','W','GEORGE','453 OAKViEW DRIVE','HONOLULU','HI',96858); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST010','HERMAN','D','OSHEA','23 PINE OAK BLVD','SEMINOLE','AL',36574); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST011','DENISE','S','CLARK','32 ELM STREET','MILTON','FL',32508); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST012','HAL','A','LEWISON','15 HILLWOOD DRIVE','BROOKSVILLE','TN',37041); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST013','FRED','T','MARSHALL','2743 FERN DRIVE','NASHVILLE','MI',49075); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST014','MINDY','A','GREEN','453 OAK ROAD','WAIMEA','HI',96858); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST015','HARRY','J','BUSSEY','23 TWIN OAKS BLVD','SEMINOLE','FL',32574); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST016','DENNIS','M','MCCLOUD','32 BOURBON STREET','MILTON','LA',43219); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST017','DAVID','L','PRICE','1551 BRENTWOOD DRIVE','BROOKSVILLE','IN',39041); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST018','FRANK','J','ADAMS','743 FERN GULLY ROAD','CHATANOOGA','TN',38459); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST019','MIA','A','BROWN','453 REDLEAF ROAD','WAIMEA','HI',96858); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST020','HERBERT','D','SMALL','333 TWIN PINES BLVD','HOLLYWOOD','FL',32574); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST021','DENNIS','M','MCCOY','327 BONNIE STREET','DULAC','LA',43249); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST022','DAVID','M','PROCTER','551 SMALLWOOD DRIVE','EVANSVILLE','IN',39041); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST023','FRANKLIN','T','PIERCE','1256 FERN GULLY ROAD','CHATANOOGA','TN',38459); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST024','MILLA','A','DOBROWSI','21 RED MILL ROAD','BRONSON','RI',21132); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST025','HELGA','S','SMITH','133 TWIN LAKES BLVD','KISSIMMEE','FL',32574); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST026','DENISE','M','MCELROY','1327 BLUE BELL AVE','JACKSON','MS',41349); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST027','DAVID','M','PRICHARD','229 SMALLVALLEY DRIVE','SMALL VALLEY','IN',39241); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST028','FRANCIS','L','PINE','1174 DOVER ROAD','TEKONSHA','TN',37459); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST029','CAMILA','A','ETHERIDGE','121 RED TOP ROAD','BRONSON','CT',21132); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST030','HORRACE','S','ROBERTS','113 TWIN PALMS BLVD','TAMPA','FL',32574); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST031','DEBRA','M','WINGER','127 BLUE BELL AVE','COLUMBIA','MS',41379); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST032','MICHAEL','R','PRICE','2129 SMALL DRIVE','HIDDEN VALLEY','IN',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST033','STEVEN','L','BAKER','74 TERRACE ROAD','LAKEVIEW','TN',37459); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST034','CARTER','A','NASH','271 REBAR ROAD','BROWNSVILLE','NH',26132); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST035','HOPPER','S','ADAMS','2231 SANDY BLVD','JACKSONVILLE','FL',33594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST036','DONNA','J','WING','1127 BLUE BELL AVE','COLUMBIA','MS',41379); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST037','MICHAEL','J','FOXX','2127 SMALL DRIVE','HIDDEN VALLEY','IN',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST038','STEPHANIE','L','BARKER','24 TERRACE ROAD','LAKEVIEW','TN',37459); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST039','CALVIN','B','NORMAN','333 REBAR ROAD','BROWNSVILLE','NH',26133); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST040','HARPER','T','LEE','3931 SANDY BLVD','JACKSONVILLE','FL',33594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST041','DONNA','J','SWING','1127 BLUE BELL AVE','COLUMBIA','MS',41379); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST042','MICHAEL','J','ROXX','2127 SMALL DRIVE','HIDDEN VALLEY','IN',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST043','STEPHANIE','L','PARKER','24 TERRACE ROAD','LAKEVIEW','TN',37459); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST044','CALVIN','B','GORMAN','333 REBAR ROAD','BROWNSVILLE','NH',26133); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST045','HARPER','T','LEWE','3931 SANDY BLVD','JACKSONVILLE','FL',33594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST046','DONNA','J','INGLES','117 BLUE BELL AVE','COLUMBIA','MS',41379); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST047','MICHAEL','K','DRIVER','212 SMALL STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST048','STEPHAN','B','BARKER','245 TERRACE STREET','LAKEHILL','TN',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST049','MELVIN','C','GORSMAN','1333 REBECCA ROAD','MIDVILLE','CT',26138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST050','HARLAND','R','MAXWELL','2121 SANDY BAY BLVD','TALAHASSEE','FL',33594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST051','DONALD','J','GLESSON','211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST052','MICHA','F','SHRIVER','912 SMITH STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST053','STEPHEN','B','HAYES','645 TERRANCE STREET','LAKEHILL','TN',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST054','MELVINA','C','GORSEMAN','333 BECCA ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST055','HARLOWE','T','BROOKS','1213 SAND BAR ROAD','PANAMA CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST056','DONALD','J','GLESSON','211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST057','MICHA','F','SHRIVER','912 SMITH STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST058','STEPHEN','B','HAYES','645 TERRANCE STREET','LAKEHILL','TN',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST059','MELVINA','C','GORSEMAN','333 BECCA ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST060','HARLOWE','T','BROOKS','1213 SAND BAR ROAD','PANAMA CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST061','RONALD','J','GLENN','2211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST062','MICHAEL','R','SHRINER','92 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST063','STEPHEN','B','SEGAL','65 TERRA STREET','BLAKEHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST064','MELVIN','C','NORSEMAN','1244 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST065','HARCOURT','L','ROOKS','113 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST066','DONALD','J','FLYNN','211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST067','MICHAEL','R','GRINER','92 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST068','STEVEN','B','REGAL','65 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST069','MELVIN','C','MORSEMAN','1244 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST070','COURTNEY','L','CROOKS','113 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST071','DONALD','J','MARTIN','7211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST072','MICHAEL','R','RINGER','392 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST073','STEVEN','B','GALEN','6599 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST074','MELVIN','C','MOSER','124 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST075','WALLY','P','BOOKS','1713 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST076','DON','J','VARIN','7211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST077','MIKE','R','STRINGER','392 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST078','STEVE','B','GALES','6599 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST079','MARVIN','C','MORRIN','124 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST080','WALLACE','P','BAKER','1713 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST081','RON','J','MARTIN','7211 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST082','NIKE','R','STRANGE','392 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST083','STEVEN','B','BALES','6599 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST084','MARTIN','C','BORMAN','124 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST085','WALLTER','P','BARKER','1713 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST086','AARON','J','ARTIS','711 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST087','RIKE','T','RANGER','2392 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST088','STEFFANIE','A','ZALES','659 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST089','MARK','C','MANFORT','124 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST090','WALLACE','A','MCTAVISH','713 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST091','AllenN','J','ARTHER','7711 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST092','RILEY','T','GRANGER','23 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST093','STEFFANO','A','GONZALES','6539 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST094','MARKEITH','C','ORTEGA','1524 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST095','WILMA','B','FLINSTONE','7613 SANDY LANE','LAKE CITY','FL',32594); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST096','ANJA','P','BRAUN','777 BLUE ANGEL AVE','COLUMBIA','MS',41382); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST097','ROGER','R','RANGER','2399 SMART STREET','BLUE VALLEY','IL',39247); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST098','STERLINGO','C','GONZAGA','6539 TERRA NOVA STREET','BLACKHILL','TX',37451); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST099','KEITH','D','VAUGHN','524 BECKWITH ROAD','MIDVALE','VT',16138); Insert into CM420F16.CUSTOMERS (CUST_ID,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,STREET_ADDRESS,CITY,STATE,ZIP) values ('CUST100','WILLIE','E','FLINE','7932 SANDY LANE','LAKE CITY','FL',32594); REM INSERTING into CM420F16.FINANCING_PLANS SET DEFINE OFF; Insert into CM420F16.FINANCING_PLANS (PLAN_ID,INSTITUTION,PERCENTAGE,LOAN_TYPE,MAX_TERM,MIN_DOWN,MAX_LOAN_AMT) values ('PLAN001','BANK','12','CONSUMER',10,1500,50000); Insert into CM420F16.FINANCING_PLANS (PLAN_ID,INSTITUTION,PERCENTAGE,LOAN_TYPE,MAX_TERM,MIN_DOWN,MAX_LOAN_AMT) values ('PLAN002','BANK','9','CONSUMER',8,2500,40000); Insert into CM420F16.FINANCING_PLANS (PLAN_ID,INSTITUTION,PERCENTAGE,LOAN_TYPE,MAX_TERM,MIN_DOWN,MAX_LOAN_AMT) values ('PLAN003','CU','6','CONSUMER',8,500,45000); Insert into CM420F16.FINANCING_PLANS (PLAN_ID,INSTITUTION,PERCENTAGE,LOAN_TYPE,MAX_TERM,MIN_DOWN,MAX_LOAN_AMT) values ('PLAN004','CU','7','AUTO',7,1200,48000); Insert into CM420F16.FINANCING_PLANS (PLAN_ID,INSTITUTION,PERCENTAGE,LOAN_TYPE,MAX_TERM,MIN_DOWN,MAX_LOAN_AMT) values ('PLAN005','ONLINE','21','AUTO',5,7500,35000); REM INSERTING into CM420F16.SALE_FINANCING SET DEFINE OFF; Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE001','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE002','PLAN002',1200,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE003','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE004','PLAN004',500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE005','PLAN005',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE006','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE007','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE008','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE009','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE010','PLAN005',1995,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE011','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE012','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE013','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE014','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE015','PLAN005',1995,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE016','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE017','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE018','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE019','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE020','PLAN005',1995,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE021','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE022','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE023','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE024','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE025','PLAN005',1995,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE026','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE027','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE028','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE029','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE030','PLAN005',1995,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE031','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE032','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE033','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE034','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE035','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE036','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE037','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE038','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE039','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE040','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE041','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE042','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE043','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE044','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE045','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE046','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE047','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE048','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE049','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE050','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE051','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE052','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE053','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE054','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE055','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE056','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE057','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE058','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE059','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE060','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE061','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE062','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE063','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE064','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE065','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE066','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE067','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE068','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE069','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE070','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE071','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE072','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE073','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE074','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE075','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE076','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE077','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE078','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE079','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE080','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE081','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE082','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE083','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE084','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE085','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE086','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE087','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE088','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE089','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE090','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE091','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE092','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE093','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE094','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE095','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE096','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE097','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE098','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE099','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE100','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE101','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE102','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE103','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE104','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE105','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE106','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE107','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE108','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE109','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE110','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE111','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE112','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE113','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE114','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE115','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE116','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE117','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE118','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE119','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE120','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE121','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE122','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE123','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE124','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE125','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE126','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE127','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE128','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE129','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE130','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE131','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE132','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE133','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE134','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE135','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE136','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE137','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE138','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE139','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE140','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE141','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE142','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE143','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE144','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE145','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE146','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE147','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE148','PLAN001',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE149','PLAN002',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE150','PLAN002',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE151','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE152','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE153','PLAN001',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE154','PLAN005',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE155','PLAN003',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE156','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE157','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE158','PLAN001',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE159','PLAN005',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE160','PLAN003',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE161','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE162','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE163','PLAN001',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE164','PLAN005',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE165','PLAN003',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE161','PLAN002',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE162','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE163','PLAN002',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE164','PLAN003',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE165','PLAN004',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE166','PLAN002',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE167','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE168','PLAN002',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE169','PLAN003',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE170','PLAN004',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE171','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE172','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE173','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE174','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE175','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE176','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE177','PLAN001',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE178','PLAN002',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE179','PLAN002',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE180','PLAN003',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE181','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE182','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE183','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE184','PLAN003',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE185','PLAN004',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE186','PLAN002',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE187','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE188','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE189','PLAN004',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE190','PLAN005',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE191','PLAN003',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE192','PLAN004',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE193','PLAN005',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE194','PLAN001',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE195','PLAN002',1795,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE196','PLAN001',2500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE197','PLAN002',1500,5); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE198','PLAN003',2000,6); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE199','PLAN001',1500,3); Insert into CM420F16.SALE_FINANCING (SALE_ID,PLAN_ID,DOWNPAYMENT,LOAN_TERM) values ('SALE200','PLAN002',1795,6); REM INSERTING into CM420F16.SALES SET DEFINE OFF; Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE011','14995','VIN011','SP003','CUST011','14373','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE012','11995','VIN012','SP007','CUST012','19271','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE013','15500','VIN013','SP002','CUST013','13730','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE014','19950','VIN014','SP003','CUST014','24330','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE015','24995','VIN015','SP003','CUST015','10670','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE016','14795','VIN016','SP001','CUST016','10972','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE017','9995','VIN017','SP007','CUST017','19280','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE018','13725','VIN018','SP002','CUST018','13799','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE019','11950','VIN019','SP003','CUST019','24189','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE020','27995','VIN020','SP008','CUST020','30670','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE021','24775','VIN021','SP009','CUST021','12779','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE022','19953','VIN022','SP008','CUST022','19204','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE023','18372','VIN023','SP010','CUST023','12337','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE024','21950','VIN024','SP006','CUST024','21890','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE025','23895','VIN025','SP005','CUST025','7670','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE026','25192','VIN026','SP003','CUST026','18792','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE027','15950','VIN027','SP001','CUST027','15120','20170324','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE028','15558','VIN028','SP010','CUST028','11233','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE029','20195','VIN029','SP004','CUST029','18903','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE030','19575','VIN030','SP007','CUST030','27679','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE031','15197','VIN031','SP002','CUST031','11499','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE032','15395','VIN032','SP001','CUST032','25123','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE033','17558','VIN033','SP010','CUST033','17146','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE034','22195','VIN034','SP004','CUST034','18903','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE035','15895','VIN035','SP003','CUST035','37867','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE036','19723','VIN036','SP008','CUST036','41199','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE037','18595','VIN037','SP005','CUST037','22443','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE038','16558','VIN038','SP009','CUST038','31645','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE039','23457','VIN039','SP010','CUST039','19037','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE040','21895','VIN040','SP006','CUST040','37111','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE041','12995','VIN041','SP009','CUST041','57644','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE042','15750','VIN042','SP008','CUST042','19448','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE043','14995','VIN043','SP007','CUST043','61345','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE044','13579','VIN044','SP006','CUST044','21903','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE045','24895','VIN045','SP005','CUST045','27181','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE046','12995','VIN046','SP004','CUST046','37644','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE047','17850','VIN047','SP003','CUST047','29487','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE048','17995','VIN048','SP002','CUST048','34516','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE049','16575','VIN049','SP001','CUST049','19034','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE050','22895','VIN050','SP002','CUST050','18110','20170325','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE051','14995','VIN051','SP003','CUST051','17644','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE052','19785','VIN052','SP004','CUST052','39876','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE053','17995','VIN053','SP005','CUST053','45162','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE054','18575','VIN054','SP006','CUST054','39324','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE055','12995','VIN055','SP007','CUST055','48210','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE056','17995','VIN056','SP008','CUST056','17640','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE057','19785','VIN057','SP009','CUST057','19876','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE058','17995','VIN058','SP010','CUST058','25162','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE059','18575','VIN059','SP001','CUST059','36324','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE060','12995','VIN060','SP001','CUST060','38210','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE061','14995','VIN061','SP002','CUST061','14093','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE062','19995','VIN062','SP002','CUST062','18767','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE063','14995','VIN063','SP003','CUST063','35762','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE064','18675','VIN064','SP003','CUST064','26328','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE065','12795','VIN065','SP004','CUST065','18211','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE066','13995','VIN066','SP004','CUST066','24931','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE067','16995','VIN067','SP005','CUST067','18788','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE068','24995','VIN068','SP005','CUST068','15765','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE069','18750','VIN069','SP006','CUST069','36329','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE070','19795','VIN070','SP0064','CUST070','21115','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE071','14995','VIN071','SP007','CUST071','19105','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE072','19970','VIN072','SP008','CUST072','18300','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE073','24990','VIN073','SP009','CUST073','18765','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE074','18754','VIN074','SP010','CUST074','19329','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE075','19395','VIN075','SP009','CUST075','21158','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE076','16995','VIN076','SP008','CUST076','19105','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE077','18999','VIN077','SP007','CUST077','18300','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE078','17950','VIN078','SP006','CUST078','18765','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE079','15478','VIN079','SP005','CUST079','19329','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE080','19995','VIN080','SP004','CUST080','21158','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE081','16950','VIN081','SP003','CUST081','15225','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE082','18991','VIN082','SP002','CUST082','18375','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE083','17957','VIN083','SP001','CUST083','17659','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE084','15474','VIN084','SP001','CUST084','29329','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE085','19999','VIN085','SP002','CUST085','31158','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE086','16955','VIN086','SP001','CUST086','12925','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE087','19916','VIN087','SP001','CUST087','21375','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE088','27957','VIN088','SP001','CUST088','17697','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE089','16494','VIN089','SP003','CUST089','29929','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE090','29999','VIN090','SP003','CUST090','18762','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE091','19955','VIN091','SP001','CUST091','29725','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE092','16795','VIN092','SP001','CUST092','21579','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE093','19570','VIN093','SP001','CUST093','18693','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE094','26496','VIN094','SP003','CUST094','19969','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE095','19999','VIN095','SP003','CUST095','17621','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE096','15955','VIN096','SP004','CUST096','29723','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE097','17791','VIN097','SP004','CUST097','21576','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE098','19577','VIN098','SP005','CUST098','18699','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE099','26456','VIN099','SP006','CUST099','19962','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE100','19972','VIN100','SP007','CUST100','17625','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE101','16956','VIN101','SP008','CUST0101','29725','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE102','17791','VIN102','SP009','CUST102','21578','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE103','19577','VIN103','SP010','CUST103','18697','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE104','26456','VIN104','SP009','CUST104','19911','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE105','19972','VIN105','SP008','CUST105','18624','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE106','16865','VIN106','SP007','CUST0106','29721','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE107','17792','VIN107','SP006','CUST107','21572','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE108','18577','VIN108','SP005','CUST108','18693','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE109','21450','VIN109','SP004','CUST109','19914','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE110','17970','VIN110','SP003','CUST110','18625','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE111','16825','VIN111','SP002','CUST0111','23721','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE112','17752','VIN112','SP001','CUST112','21272','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE113','16577','VIN113','SP002','CUST113','18893','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE114','31450','VIN114','SP003','CUST114','19314','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE115','19970','VIN115','SP004','CUST115','18925','20170326','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE116','16925','VIN116','SP005','CUST0116','13723','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE117','13759','VIN117','SP006','CUST117','21572','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE118','16777','VIN118','SP007','CUST118','18838','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE119','11450','VIN119','SP008','CUST11','17318','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE120','18978','VIN120','SP009','CUST120','18977','2017032','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE121','19922','VIN121','SP010','CUST0121','12123','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE122','15753','VIN122','SP001','CUST122','21662','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE123','16775','VIN123','SP001','CUST123','18998','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE124','10786','VIN124','SP002','CUST124','16318','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE125','22973','VIN125','SP003','CUST125','21007','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE126','18900','VIN126','SP004','CUST0121','12123','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE127','17531','VIN127','SP005','CUST122','21662','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE128','17750','VIN128','SP006','CUST123','18998','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE129','18335','VIN129','SP007','CUST124','16318','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE130','27973','VIN130','SP008','CUST125','21007','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE131','14905','VIN131','SP009','CUST021','121023','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE132','17531','VIN132','SP010','CUST023','21222','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE133','17750','VIN133','SP010','CUST023','18957','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE134','18335','VIN134','SP009','CUST024','13190','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE135','27973','VIN135','SP008','CUST025','21057','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE136','24905','VIN136','SP009','CUST021','121023','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE137','17531','VIN137','SP010','CUST023','21222','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE138','17750','VIN138','SP010','CUST023','18957','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE139','18732','VIN139','SP009','CUST024','13190','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE140','27954','VIN140','SP008','CUST025','21057','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE141','29995','VIN141','SP007','CUST011','19873','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE142','17953','VIN142','SP006','CUST012','21277','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE143','18850','VIN143','SP005','CUST013','19574','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE144','18798','VIN144','SP004','CUST014','13170','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE145','23959','VIN145','SP003','CUST015','21790','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE146','21995','VIN041','SP007','CUST021','19873','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE147','19530','VIN042','SP006','CUST032','21277','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE148','19503','VIN043','SP005','CUST043','19574','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE149','13795','VIN044','SP004','CUST054','13170','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE150','20954','VIN045','SP003','CUST065','21790','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE151','27995','VIN020','SP001','CUST011','19873','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE152','19530','VIN042','SP003','CUST037','21277','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE153','19503','VIN043','SP005','CUST022','19574','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE154','13795','VIN044','SP007','CUST052','13170','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE155','20954','VIN045','SP009','CUST001','21790','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE156','27998','VIN029','SP002','CUST019','19873','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE157','29535','VIN037','SP004','CUST057','21277','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE158','19578','VIN013','SP006','CUST082','19574','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE159','23765','VIN014','SP008','CUST093','13170','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE160','28955','VIN050','SP010','CUST091','21790','20170327','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE161','27945','VIN039','SP001','CUST015','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE162','29342','VIN030','SP003','CUST067','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE163','39571','VIN005','SP005','CUST042','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE164','29760','VIN010','SP007','CUST090','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE165','24953','VIN033','SP009','CUST056','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE166','33945','VIN009','SP001','CUST015','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE167','26348','VIN018','SP001','CUST067','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE168','35575','VIN012','SP002','CUST042','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE169','29999','VIN017','SP002','CUST090','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE170','34359','VIN028','SP003','CUST056','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE171','33545','VIN029','SP003','CUST035','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE172','28934','VIN015','SP004','CUST077','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE173','33572','VIN019','SP004','CUST049','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE174','39997','VIN027','SP005','CUST098','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE175','44350','VIN024','SP005','CUST016','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE176','35457','VIN006','SP006','CUST015','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE177','38935','VIN010','SP006','CUST087','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE178','35729','VIN039','SP007','CUST019','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE179','29992','VIN007','SP007','CUST058','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE180','34755','VIN004','SP008','CUST006','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE181','24975','VIN003','SP008','CUST035','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE182','38935','VIN016','SP009','CUST039','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE183','35729','VIN049','SP009','CUST049','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE184','29992','VIN037','SP010','CUST059','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE185','34755','VIN008','SP010','CUST099','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE186','24977','VIN013','SP001','CUST001','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE187','38925','VIN015','SP001','CUST003','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE188','35929','VIN022','SP001','CUST005','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE189','19994','VIN024','SP002','CUST007','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE190','34759','VIN050','SP002','CUST009','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE191','24900','VIN014','SP002','CUST011','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE192','38995','VIN016','SP003','CUST013','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE193','35664','VIN023','SP003','CUST015','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE194','29924','VIN025','SP003','CUST017','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE195','34958','VIN027','SP004','CUST019','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE196','24970','VIN033','SP002','CUST021','19873','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE197','38795','VIN046','SP003','CUST023','21277','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE198','30554','VIN023','SP003','CUST025','19574','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE199','28124','VIN026','SP003','CUST027','13170','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE200','24951','VIN043','SP004','CUST029','21790','20170328','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE001','9995','VIN001','SP001','CUST001','21424','20170319','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE002','16995','VIN002','SP001','CUST002','37989','20170319','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE003','11995','VIN003','SP002','CUST003','49773','20170319','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE004','13995','VIN004','SP001','CUST004','42221','20170320','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE005','21995','VIN005','SP001','CUST005','31116','20170320','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE006','9995','VIN006','SP002','CUST006','61378','03/20/2017','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE007','29995','VIN007','SP002','CUST007','43282','20170321','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE009','25995','VIN009','SP002','CUST009','33445','03/21/2017','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE010','39995','VIN010','SP001','CUST010','16338','20170322','READY'); Insert into CM420F16.SALES (SALE_ID,GROSS_SALE_PRICE,VIN,SALESPERSON_ID,CUST_ID,MILEAGE,SALE_DATE,VEHICLE_STATUS) values ('SALE008','21995','VIN008','SP001','CUST008','28245','20170321','READY'); REM INSERTING into CM420F16.SALESPERSONS SET DEFINE OFF; Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP001','MR','DAVID','R','STEINMAN',to_date('01-MAY-14','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP002','MR','MICHAEL','T','DAVIDSON',to_date('08-SEP-12','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP003','MS','SHARON','H','THOMAS',to_date('01-FEB-11','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP004','MR','DION','A','ADAMS',to_date('11-MAR-15','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP005','MRS','MARY','K','BROWN',to_date('01-MAY-14','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP006','MR','JUSTIN','C','RIDER',to_date('21-NOV-11','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP007','MS','MICHELL','L','PARKER',to_date('24-APR-15','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP008','MS','ANDREA','J','SMITH',to_date('29-SEP-14','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP009','MR','DIXON','M','HILL',to_date('27-DEC-10','DD-MON-RR')); Insert into CM420F16.SALESPERSONS (SALESPERSON_ID,TITLE,FIRST_NAME,MIDDLE_INITIAL,LAST_NAME,HIRE_DATE) values ('SP010','MS','JESSICA','E','NICHOLS',to_date('16-MAY-16','DD-MON-RR')); REM INSERTING into CM420F16.VEHICLES SET DEFINE OFF; Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN011','COMPACT','GOLF','VW','TRADE011','10995','GERMANY'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN012','COMPACT','YARIS','TOYOTA','TRADE012','8995','JAPAN'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN013','MIDSIZE','COROLLA','TOYOTA','TRADE013','12995','JAPAN'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN014','SUV','RAV4','TOYOTA','TRADE014','14995','JAPAN'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN015','SEDAN','CAMRY','TOYOTA','TRADE015','14000','JAPAN'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN016','COUPE','IMPREZZA','SUBARU','TRADE016','13995','AUSTRALIA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN017','MIDSIZE','REGAL','BUICK','TRADE017','8995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN018','MIDSIZE','CHARGER','DODGE','TRADE018','17995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN019','SUV','JOURNEY','DODGE','TRADE019','7995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN020','SPORT','VIPER','DODGE','TRADE020','24000','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN021','COUPE','300','DODGE','TRADE021','15995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN022','MIDSIZE','MALIBU','CHEVROLET','TRADE022','8995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN023','VAN','CARAVAN','DODGE','TRADE023','11500','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN024','SUV','JOURNEY','DODGE','TRADE024','9995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN025','LUXURY','LS','LEXUS','TRADE025','44000','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN026','LUXURY','LC COUPE','LEXUS','TRADE026','75995','JAPAN'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN027','MIDSIZE','FUSION','FORD','TRADE027','18995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN028','SEDAN','TAURUS','FORD','TRADE028','21500','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN029','COMPACT','DART','DODGE','TRADE029','7995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN030','SUV','EXPLORER','FORD','TRADE030','18200','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN031','SEDAN','300S','CHRYSLER','TRADE031','18995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN032','MIDSIZE','MALIBU','CHEVROLET','TRADE032','11495','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN033','VAN','CARAVAN','DODGE','TRADE033','13350','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN034','SUV','JOURNEY','DODGE','TRADE034','8995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN035','LUXURY','LACROSSE','BUICK','TRADE035','21499','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN036','SEDAN','200S','CHRYSLER','TRADE036','12500','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN037','MIDSIZE','CAMARO','CHEVROLET','TRADE037','19795','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN038','SUV','EDGE','FORD','TRADE038','14795','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN039','COMPACT','FIESTA','FORD','TRADE039','6995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN040','COMPACT','FOCUS','FORD','TRADE040','6499','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN041','SEDAN','RDX','ACURA','TRADE041','32500','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN042','MIDSIZE','CRUZE','CHEVROLET','TRADE042','10795','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN043','SUV','TRAX','CHEVROLET','TRADE043','14995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN044','COMPACT','FIESTA','FORD','TRADE044','6995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN045','COMPACT','SONIC','CHEVROLET','TRADE045','6999','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN046','SEDAN','IMPALA','CHEVROLET','TRADE046','16500','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN047','MIDSIZE','CRUZE','CHEVROLET','TRADE047','11095','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN048','SUV','TRAX','CHEVROLET','TRADE048','16995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN049','COMPACT','FIESTA','FORD','TRADE049','5595','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN050','SEDAN','ACCORD','HONDA','TRADE045','16999','JAPAN'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN001','COMPACT','ESCORT','FORD','TRADE001','9995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN002','SEDAN','REGAL','BUICK','TRADE002','16995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN003','SEDAN','MALIBU','CHEVROLET','TRADE003','11995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN004','SUV','ESCAPE','FORD','TRADE004','13995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN005','TRUCK','F150','FORD','TRADE005','21995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN006','SEDAN','200','CHRYSLER','TRADE006','9995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN007','COUPE','MUSTANG GT','FORD','TRADE007','29995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN008','SUV','ACADIA','GMC','TRADE008','21995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN009','TRUCK','RAM 1500','DODGE','TRADE009','25995','USA'); Insert into CM420F16.VEHICLES (VIN,TYPE,MODEL,MAKE,TRADE_ID,WHOLESALE_COST,WHERE_FROM) values ('VIN010','SEDAN','330i','BMW','TRADE010','39995','GERMANY'); -------------------------------------------------------- -- DDL for Index CUSTOMERS_PK -------------------------------------------------------- CREATE UNIQUE INDEX "CM420F16"."CUSTOMERS_PK" ON "CM420F16"."CUSTOMERS" ("CUST_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Index FINANCING_PLANS_PK -------------------------------------------------------- CREATE UNIQUE INDEX "CM420F16"."FINANCING_PLANS_PK" ON "CM420F16"."FINANCING_PLANS" ("PLAN_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Index SALE_FINANCING_PK -------------------------------------------------------- CREATE UNIQUE INDEX "CM420F16"."SALE_FINANCING_PK" ON "CM420F16"."SALE_FINANCING" ("SALE_ID", "PLAN_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Index SALE_PK -------------------------------------------------------- CREATE UNIQUE INDEX "CM420F16"."SALE_PK" ON "CM420F16"."SALES" ("SALE_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Index SALESPERSONS_PK -------------------------------------------------------- CREATE UNIQUE INDEX "CM420F16"."SALESPERSONS_PK" ON "CM420F16"."SALESPERSONS" ("SALESPERSON_ID") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- DDL for Index VEHICLES_PK -------------------------------------------------------- CREATE UNIQUE INDEX "CM420F16"."VEHICLES_PK" ON "CM420F16"."VEHICLES" ("VIN") PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ; -------------------------------------------------------- -- Constraints for Table CUSTOMERS -------------------------------------------------------- ALTER TABLE "CM420F16"."CUSTOMERS" ADD CONSTRAINT "CUSTOMERS_PK" PRIMARY KEY ("CUST_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ENABLE; -------------------------------------------------------- -- Constraints for Table FINANCING_PLANS -------------------------------------------------------- ALTER TABLE "CM420F16"."FINANCING_PLANS" ADD CONSTRAINT "FINANCING_PLANS_PK" PRIMARY KEY ("PLAN_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ENABLE; -------------------------------------------------------- -- Constraints for Table SALE_FINANCING -------------------------------------------------------- ALTER TABLE "CM420F16"."SALE_FINANCING" ADD CONSTRAINT "SALE_FINANCING_PK" PRIMARY KEY ("SALE_ID", "PLAN_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ENABLE; -------------------------------------------------------- -- Constraints for Table SALES -------------------------------------------------------- ALTER TABLE "CM420F16"."SALES" ADD CONSTRAINT "SALE_PK" PRIMARY KEY ("SALE_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ENABLE; -------------------------------------------------------- -- Constraints for Table SALESPERSONS -------------------------------------------------------- ALTER TABLE "CM420F16"."SALESPERSONS" ADD CONSTRAINT "SALESPERSONS_PK" PRIMARY KEY ("SALESPERSON_ID") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ENABLE; -------------------------------------------------------- -- Constraints for Table VEHICLES -------------------------------------------------------- ALTER TABLE "CM420F16"."VEHICLES" ADD CONSTRAINT "VEHICLES_PK" PRIMARY KEY ("VIN") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS STORAGE(INITIAL 1048576 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CLASS" ENABLE;