SQL> SQL> /*2) Add 25 CUSTOMERSs so that you now have 50 total.*/ SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST026', 'ALASTAIR', 'COOK', 'P.O. BOX 2947', 5 'CODY', 'WY', '82414'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST027', 'SAM', 'ROBSON', 'P.O. BOX 851', 5 'CHICAGO', 'IL', '06985'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST028', 'GRAY', 'JAKE', 'P.O. BOX 983', 5 'SANTA MONICA', 'CA', '65892'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST029', 'IAN', 'BELL', 'P.O. BOX 650', 5 'EASTPOINT', 'FL', '35353'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST030', 'JOE', 'ROOT', 'P.O. BOX 150', 5 'SEATTLE', 'WA', '98115'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST031', 'LIAM', 'PLUNKETT', 'P.O. BOX 9835', 5 'SANTA MONICA', 'CA', '12649'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST032', 'MATT', 'PRIOR', 'P.O. BOX 651', 5 'EASTPOINT', 'FL', '32323'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST033', 'BEN', 'STOKES', 'P.O. BOX 971', 5 'BOSTON', 'MA', '02110'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST034', 'STUART', 'BROAD', 'P.O. BOX 18', 5 'CHICAGO', 'IL', '06015'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST035', 'JAMES', 'ANDERSON', 'P.O. BOX 8564', 5 'BURBANK', 'CA', '91510'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST036', 'ALVIRO', 'PETERSON', 'P.O. BOX 137', 5 'CHEYENNE', 'WY', '82003'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST037', 'DEAN', 'ELGAR', 'P.O. BOX 66', 5 'TALLAHASSEE', 'FL', '12548'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST038', 'DALE', 'STEYN', 'P.O. BOX 851', 5 'SEATTLE', 'WA', '98115'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST039', 'PAUL', 'DUMINY', '82 DIRT ROAD', 5 'ALBANY', 'NY', '12211'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST040', 'MORNE', 'MORKEL', '9851231 LONG ROAD', 5 'BURBANK', 'CA', '12356'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST041', 'MATHEWS', 'ANGELO', '9153 MAIN STREET', 5 'AUSTIN', 'TX', '56897'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST042', 'JAMES', 'ERANGA', '357 WHITE EAGLE AVE', 5 'CLERMONT', 'FL', '34711'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST043', 'CAMERON', 'WHITE', 'P.O. BOX 677', 5 'MIAMI', 'FL', '33111'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST044', 'PHILIPS', 'HUGHES', 'P.O. BOX 335', 5 'TRENTON', 'NJ', '08607'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST045', 'CHRIS', 'LYNN', 'P.O. BOX 2947', 5 'CODY', 'WY', '82414'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST046', 'CALLUM', 'FERGUSON', 'P.O. BOX 18', 5 'CHICAGO', 'IL', '06015'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST047', 'MITCHELL', 'MARSH', 'P.O. BOX 137', 5 'CHEYENNE', 'WY', '82003'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST048', 'CAMERON', 'BOYCE', '1008 GRAND AVENUE', 5 'MACON', 'GA', '12546'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST049', 'KANE', 'RICHARDSON', 'P.O. BOX 851', 5 'SEATTLE', 'WA', '98115'); 1 row created. SQL> Insert into CUSTOMERS 2 (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP) 3 Values 4 ('CUST050', 'ASHKAR', 'PATEL', '69821 SOUTH AVENUE', 5 'BOISE', 'ID', '23568'); 1 row created. SQL> COMMIT; Commit complete. SQL> SQL> SQL> /*3) Add 25 vehicles so that you now have 50 total.*/ SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN026', 'OS001', 'TRADE001', 'SEDAN', 'PHAETON', 5 'NISSAN', 'JAPAN', '100000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN027', 'OS001', 'TRADE001', 'SEDAN', 'SENTRE', 5 'NISSAN', 'JAPAN', '5000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN028', 'OS001', 'TRADE001', 'SEDAN', 'CUBE', 5 'NISSAN', 'JAPAN', '26000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN029', 'OS001', 'TRADE001', 'SUV', 'MURANO', 5 'NISSAN', 'JAPAN', '50000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN030', 'OS001', 'TRADE001', 'SALOON', 'COPE', 5 'NISSAN', 'JAPAN', '45000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN031', 'OS001', 'TRADE001', 'SUV', 'ARMADA', 5 'NISSAN', 'JAPAN', '10000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN032', 'OS001', 'TRADE001', 'SUV', 'ROUGE', 5 'NISSAN', 'JAPAN', '15000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN033', 'OS001', 'TRADE001', 'SUV', 'JUKE', 5 'NISSAN', 'JAPAN', '20000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN034', 'OS001', 'TRADE001', 'TRUCK', 'QUEST', 5 'NISSAN', 'JAPAN', '10000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN035', 'OS001', 'TRADE001', 'SUV', 'LAND CRUISER', 5 'TOYOTA', 'JAPAN', '25000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN036', 'OS001', 'TRADE001', 'SUV', 'RAV4', 5 'TOYOTA', 'JAPAN', '10000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN037', 'OS001', 'TRADE001', 'SALOON', 'CAMRY', 5 'TOYOTA', 'JAPAN', '25000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN038', 'OS001', 'TRADE001', 'TRUCK', 'TENDRA', 5 'TOYOTA', 'JAPAN', '26000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN039', 'OS001', 'TRADE001', 'HATCHBACK', 'YARIS', 5 'TOYOTA', 'JAPAN', '35000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN040', 'OS001', 'TRADE001', 'SUV', 'CR-V', 5 'HONDA', 'JAPAN', '30000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN041', 'OS001', 'TRADE001', 'HATCHBACK', 'FIT', 5 'HONDA', 'JAPAN', '18000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN042', 'OS001', 'TRADE001', 'HYBRID', 'CR-Z', 5 'HONDA', 'JAPAN', '12000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN043', 'OS001', 'TRADE001', 'SEDAN', 'INSIGHT', 5 'HONDA', 'JAPAN', '14000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN044', 'OS001', 'TRADE001', 'SEDAN', 'TERRAIN', 5 'GM', 'USA', '16000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN045', 'OS001', 'TRADE001', 'SUV', 'YUKON', 5 'GM', 'USA', '12000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN046', 'OS001', 'TRADE001', 'TRUCK', 'SIERRA', 5 'GM', 'USA', '60000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN047', 'OS001', 'TRADE001', 'SEDAN', 'RIO', 5 'KIA', 'JAPAN', '50000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN048', 'OS001', 'TRADE001', 'HATCHBACK', 'VENGA', 5 'KIA', 'JAPAN', '25000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN049', 'OS001', 'TRADE001', 'SUV', 'SOUL', 5 'KIA', 'JAPAN', '20000'); 1 row created. SQL> Insert into VEHICLES 2 (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST) 3 Values 4 ('VIN050', 'OS001', 'TRADE001', 'SEDAN', 'OPTMA', 5 'KIA', 'JAPAN', '15000'); 1 row created. SQL> COMMIT; Commit complete. SQL> SQL> SQL> /*4) Add 200 sales so that you now have 250 total.*/ SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE051', 'CUST025', 'VIN024', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 200, 6364); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE052', 'CUST025', 'VIN025', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 16601); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE053', 'CUST024', 'VIN026', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 15318); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE054', 'CUST026', 'VIN026', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 23762); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE055', 'CUST027', 'VIN024', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 10703); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE056', 'CUST026', 'VIN025', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 21377); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE057', 'CUST027', 'VIN025', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 6571); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE058', 'CUST028', 'VIN027', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5500, 18906); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE059', 'CUST027', 'VIN028', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6500, 16429); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE060', 'CUST029', 'VIN029', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1522, 21957); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE061', 'CUST028', 'VIN028', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 22345); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE062', 'CUST029', 'VIN027', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8500, 17250); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE063', 'CUST030', 'VIN029', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9500, 10961); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE064', 'CUST030', 'VIN030', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7500, 14158); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE065', 'CUST031', 'VIN030', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7000, 24385); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE066', 'CUST031', 'VIN029', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8000, 19714); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE067', 'CUST032', 'VIN031', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9000, 11001); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE068', 'CUST033', 'VIN031', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 15645); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE069', 'CUST032', 'VIN030', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 10888); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE070', 'CUST033', 'VIN032', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 14118); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE071', 'CUST034', 'VIN032', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 13674); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE072', 'CUST034', 'VIN033', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 8550); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE073', 'CUST035', 'VIN032', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 17837); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE074', 'CUST035', 'VIN034', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6300, 10472); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE075', 'CUST034', 'VIN035', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5300, 6624); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE076', 'CUST036', 'VIN034', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4300, 7734); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE077', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3300, 11465); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE078', 'CUST035', 'VIN034', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1300, 21276); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE079', 'CUST036', 'VIN036', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2100, 17319); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE080', 'CUST037', 'VIN036', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3100, 5274); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE081', 'CUST037', 'VIN037', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4100, 14524); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE082', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5100, 20954); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE083', 'CUST037', 'VIN038', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6100, 22907); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE084', 'CUST038', 'VIN037', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4400, 20445); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE085', 'CUST039', 'VIN037', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5400, 21843); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE086', 'CUST038', 'VIN038', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7400, 18426); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE087', 'CUST039', 'VIN038', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6400, 14835); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE088', 'CUST040', 'VIN039', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9400, 12419); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE089', 'CUST039', 'VIN039', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3600, 24139); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE090', 'CUST040', 'VIN040', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2600, 21521); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE091', 'CUST041', 'VIN039', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6600, 19246); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE092', 'CUST044', 'VIN041', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5600, 16388); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE093', 'CUST045', 'VIN042', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4600, 16406); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE094', 'CUST044', 'VIN041', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1600, 11989); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE095', 'CUST045', 'VIN042', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7600, 5075); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE096', 'CUST046', 'VIN046', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4600, 11240); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE097', 'CUST041', 'VIN042', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4500, 17974); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE098', 'CUST047', 'VIN047', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 23769); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE099', 'CUST047', 'VIN046', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 15905); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE100', 'CUST048', 'VIN047', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 13368); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE101', 'CUST002', 'VIN001', 'SP001', 'RUNNING', 5 TO_DATE('07/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8500, 23541); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE102', 'CUST001', 'VIN002', 'SP001', 'RUNNING', 5 TO_DATE('07/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 9263); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE103', 'CUST001', 'VIN001', 'SP002', 'RUNNING', 5 TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 11597); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE104', 'CUST002', 'VIN002', 'SP001', 'RUNNING', 5 TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 15151); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE105', 'CUST002', 'VIN003', 'SP002', 'RUNNING', 5 TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 6547); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE106', 'CUST003', 'VIN002', 'SP003', 'RUNNING', 5 TO_DATE('07/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18880); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE107', 'CUST004', 'VIN004', 'SP002', 'RUNNING', 5 TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 20987); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE108', 'CUST003', 'VIN003', 'SP003', 'RUNNING', 5 TO_DATE('07/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 11670); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE109', 'CUST004', 'VIN005', 'SP003', 'RUNNING', 5 TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 21469); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE110', 'CUST005', 'VIN006', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 21697); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE111', 'CUST005', 'VIN005', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 8447); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE112', 'CUST007', 'VIN004', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 21713); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE113', 'CUST008', 'VIN007', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 49000, 20421); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE114', 'CUST008', 'VIN004', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 13096); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE115', 'CUST007', 'VIN005', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 34000, 11529); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE116', 'CUST007', 'VIN007', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 5689); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE117', 'CUST008', 'VIN006', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 21000, 7560); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE118', 'CUST009', 'VIN008', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 18006); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE119', 'CUST010', 'VIN009', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 14211); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE120', 'CUST009', 'VIN009', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 5824); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE121', 'CUST010', 'VIN010', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3200, 18190); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE122', 'CUST010', 'VIN009', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 23335); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE123', 'CUST011', 'VIN009', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 6723); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE124', 'CUST011', 'VIN010', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 5234); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE125', 'CUST012', 'VIN010', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 23000, 24531); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE126', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 15791); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE127', 'CUST012', 'VIN012', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 19243); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE128', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 23187); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE129', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 18484); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE130', 'CUST015', 'VIN014', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 24312); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE131', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 15302); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE132', 'CUST016', 'VIN014', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 20903); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE133', 'CUST015', 'VIN015', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 13274); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE134', 'CUST016', 'VIN016', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 7614); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE135', 'CUST017', 'VIN015', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 60000, 22657); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE136', 'CUST017', 'VIN017', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 13059); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE137', 'CUST019', 'VIN018', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13000, 18206); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE138', 'CUST017', 'VIN016', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 23454); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE139', 'CUST019', 'VIN017', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 22502); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE140', 'CUST020', 'VIN018', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 13062); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE141', 'CUST021', 'VIN019', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 7501); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE142', 'CUST022', 'VIN019', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 15580); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE143', 'CUST020', 'VIN020', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 23936); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE144', 'CUST021', 'VIN021', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 18183); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE145', 'CUST022', 'VIN020', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 20996); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE146', 'CUST023', 'VIN022', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 9539); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE147', 'CUST023', 'VIN023', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 22808); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE148', 'CUST024', 'VIN024', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18294); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE149', 'CUST024', 'VIN025', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 19533); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE150', 'CUST025', 'VIN024', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 13464); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE151', 'CUST025', 'VIN025', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 7999); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE152', 'CUST024', 'VIN026', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 21912); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE153', 'CUST026', 'VIN026', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 7481); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE154', 'CUST027', 'VIN024', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 22602); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE155', 'CUST026', 'VIN025', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 16344); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE156', 'CUST027', 'VIN025', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 5386); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE157', 'CUST028', 'VIN027', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 5692); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE158', 'CUST027', 'VIN028', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 5802); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE159', 'CUST029', 'VIN029', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 7146); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE160', 'CUST028', 'VIN028', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 9460); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE161', 'CUST029', 'VIN027', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 6159); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE162', 'CUST030', 'VIN029', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 16473); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE163', 'CUST030', 'VIN030', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 19067); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE164', 'CUST031', 'VIN030', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 13630); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE165', 'CUST031', 'VIN029', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4500, 5083); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE166', 'CUST032', 'VIN031', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 19795); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE167', 'CUST033', 'VIN031', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 21398); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE168', 'CUST032', 'VIN030', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9000, 7629); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE169', 'CUST033', 'VIN032', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8000, 6333); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE170', 'CUST034', 'VIN032', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7000, 23925); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE171', 'CUST034', 'VIN033', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 20224); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE172', 'CUST035', 'VIN032', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 20173); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE173', 'CUST035', 'VIN034', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 23363); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE174', 'CUST034', 'VIN035', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 8114); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE175', 'CUST036', 'VIN034', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18174); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE176', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 22890); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE177', 'CUST035', 'VIN034', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 14238); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE178', 'CUST036', 'VIN036', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 23827); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE179', 'CUST037', 'VIN036', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 9027); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE180', 'CUST037', 'VIN037', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 14941); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE181', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 13203); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE182', 'CUST037', 'VIN038', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 20723); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE183', 'CUST038', 'VIN037', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 60000, 23447); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE184', 'CUST039', 'VIN037', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7000, 12656); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE185', 'CUST038', 'VIN038', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 80000, 24007); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE186', 'CUST039', 'VIN038', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 70000, 21444); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE187', 'CUST040', 'VIN039', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 80000, 13274); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE188', 'CUST039', 'VIN039', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 90000, 15280); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE189', 'CUST040', 'VIN040', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 8838); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE190', 'CUST041', 'VIN039', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 12597); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE191', 'CUST044', 'VIN041', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 24855); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE192', 'CUST045', 'VIN042', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4500, 18267); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE193', 'CUST044', 'VIN041', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 6192); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE194', 'CUST045', 'VIN042', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6500, 16504); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE195', 'CUST046', 'VIN046', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5500, 20305); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE196', 'CUST041', 'VIN042', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 14290); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE197', 'CUST047', 'VIN047', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 15556); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE198', 'CUST047', 'VIN046', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18211); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE199', 'CUST048', 'VIN047', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 13969); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE200', 'CUST001', 'VIN002', 'SP001', 'RUNNING', 5 TO_DATE('07/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 18036); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE201', 'CUST001', 'VIN001', 'SP002', 'RUNNING', 5 TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 8936); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE202', 'CUST002', 'VIN002', 'SP001', 'RUNNING', 5 TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 7917); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE203', 'CUST002', 'VIN003', 'SP002', 'RUNNING', 5 TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 14502); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE204', 'CUST003', 'VIN002', 'SP003', 'RUNNING', 5 TO_DATE('07/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 14514); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE205', 'CUST004', 'VIN004', 'SP002', 'RUNNING', 5 TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 7236); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE206', 'CUST003', 'VIN003', 'SP003', 'RUNNING', 5 TO_DATE('07/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 17030); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE207', 'CUST004', 'VIN005', 'SP003', 'RUNNING', 5 TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 18338); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE208', 'CUST005', 'VIN006', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 5482); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE209', 'CUST005', 'VIN005', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 23797); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE210', 'CUST007', 'VIN004', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 11241); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE211', 'CUST008', 'VIN007', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 49000, 17228); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE212', 'CUST008', 'VIN004', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 19366); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE213', 'CUST007', 'VIN005', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 34000, 17525); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE214', 'CUST007', 'VIN007', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 19328); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE215', 'CUST008', 'VIN006', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 21000, 15481); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE216', 'CUST009', 'VIN008', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 11934); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE217', 'CUST010', 'VIN009', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 7046); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE218', 'CUST009', 'VIN009', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 13289); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE219', 'CUST010', 'VIN010', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3200, 17287); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE220', 'CUST010', 'VIN009', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 12025); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE221', 'CUST011', 'VIN009', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 13742); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE222', 'CUST011', 'VIN010', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 21489); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE223', 'CUST012', 'VIN010', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 23000, 22519); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE224', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 18674); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE225', 'CUST012', 'VIN012', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 18346); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE226', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 7586); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE227', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 12002); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE228', 'CUST015', 'VIN014', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 7893); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE229', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 15131); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE230', 'CUST016', 'VIN014', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 21825); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE231', 'CUST015', 'VIN015', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 13496); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE232', 'CUST016', 'VIN016', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 11385); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE233', 'CUST017', 'VIN015', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 60000, 13794); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE234', 'CUST017', 'VIN017', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 22395); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE235', 'CUST019', 'VIN018', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13000, 5156); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE236', 'CUST017', 'VIN016', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 19371); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE237', 'CUST019', 'VIN017', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 7738); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE238', 'CUST020', 'VIN018', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 20023); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE239', 'CUST021', 'VIN019', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 24432); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE240', 'CUST022', 'VIN019', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 15964); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE241', 'CUST020', 'VIN020', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 8302); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE242', 'CUST021', 'VIN021', 'SP003', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 19941); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE243', 'CUST022', 'VIN020', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 11003); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE244', 'CUST023', 'VIN022', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 10781); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE245', 'CUST023', 'VIN023', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 7244); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE246', 'CUST024', 'VIN024', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 6671); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE247', 'CUST024', 'VIN025', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 23233); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE248', 'CUST025', 'VIN024', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 7617); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE249', 'CUST025', 'VIN025', 'SP002', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 12681); 1 row created. SQL> Insert into SALES 2 (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE) 3 Values 4 ('SALE250', 'CUST026', 'VIN026', 'SP001', 'RUNNING', 5 TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 22437); 1 row created. SQL> COMMIT; Commit complete. SQL> SQL> set linesize 150 pagesize 100 SQL> SQL> /*5) Via a single SELECT query display the total count of sales, and the lowest, average, and highest SALES price.*/ SQL> SELECT COUNT (*) AS "COUNT OF SALES", 2 AVG (WHOLESALE_COST) AS "AVERAGE SALES", 3 MIN (WHOLESALE_COST) AS "LOWEST SALES", 4 MAX (WHOLESALE_COST) AS "HIGHEST SALES" 5 FROM SALES s INNER JOIN VEHICLES v ON S.VIN = v.vin; COUNT OF SALES AVERAGE SALES LOWEST SALES HIGHEST SALES -------------- ------------- --------------- --------------- 250 27076 10000 8000 SQL> SQL> /*6) Via a single SELECT query display all CUSTOMERS IDs, names, and zip codes of CUSTOMERSs having purchased 5 or more vehicles.*/ SQL> SELECT S.CUST_ID, C.FIRST_NAME, C.ZIP 2 FROM SALES S INNER JOIN CUSTOMERS C ON S.CUST_ID = C.CUST_ID 3 GROUP BY S.CUST_ID, C.FIRST_NAME, C.ZIP 4 HAVING COUNT (*) >= 5; CUST_ID FIRST_NAME ZIP ---------- --------------- ----- CUST014 TRICIA 32306 CUST019 AMINA 32323 CUST012 ALTHEA 12211 CUST013 VERONICA 98115 CUST016 GISSELLE 91510 CUST024 CRUZ 06985 CUST015 RYAN 82003 CUST017 BRANDA 60606 CUST020 TRICA 12649 CUST026 ALASTAIR 82414 CUST035 JAMES 91510 CUST002 GRAVIN 78710 CUST005 WENDY 31206 CUST021 DAUM 98115 CUST023 LEE 65892 CUST025 LUCAS 82414 CUST034 STUART 06015 CUST039 PAUL 12211 CUST001 PAUL 83707 CUST008 HARRY 49006 CUST036 ALVIRO 82003 CUST003 MARK 30314 CUST004 STACY 34711 CUST007 BERT 33111 CUST011 LOANDA 82414 CUST027 SAM 06985 CUST037 DEAN 12548 CUST009 BRANDON 08607 CUST010 HARRY 07962 CUST022 SCHELL 35353 30 rows selected. SQL> SQL> /*7) Via a single SELECT query display the institution and loan type of the financing plan used for the most sales.*/ SQL> SELECT INSTITUTION, LOAN_TYPE 2 FROM FINANCING_PLANS 3 WHERE plan_id = (SELECT x.PLAN_ID 4 FROM ( SELECT sf.PLAN_ID, 5 COUNT (*) AS plan_count, 6 RANK () OVER (ORDER BY COUNT (*) DESC) 7 AS RANK 8 FROM SALES s 9 INNER JOIN 10 SALE_FINANCINGS sf 11 ON S.SALE_ID = SF.SALE_ID 12 GROUP BY sf.PLAN_ID) x 13 WHERE x.RANK = 1); INSTITUTION LOAN_TYPE ------------ ------------ BANK CONSUMER SQL> SQL> SQL> /*8) Via a single SELECT query display the vehicle make involved in the most sales and all CUSTOMERSs having purchased a vehicle of that make.*/ SQL> SELECT DISTINCT v.make, 2 c.cust_id, 3 C.FIRST_NAME, 4 C.LAST_NAME, 5 C.ZIP 6 FROM CUSTOMERS c 7 INNER JOIN SALES s 8 ON S.CUST_ID = C.CUST_ID 9 INNER JOIN VEHICLES v 10 ON S.VIN = v.vin 11 WHERE V.MAKE = (SELECT x.make 12 FROM ( SELECT v.make, 13 COUNT (*) AS veh_count, 14 RANK () OVER (ORDER BY COUNT (*) DESC) 15 AS RANK 16 FROM SALES s 17 INNER JOIN 18 VEHICLES v 19 ON S.VIN = v.vin 20 GROUP BY v.make) x 21 WHERE x.RANK = 1); MAKE CUST_ID FIRST_NAME LAST_NAME ZIP --------------- ---------- --------------- --------------- ----- NISSAN CUST032 MATT PRIOR 32323 NISSAN CUST015 RYAN BISHOP 82003 NISSAN CUST035 JAMES ANDERSON 91510 NISSAN CUST036 ALVIRO PETERSON 82003 NISSAN CUST016 GISSELLE ALLEYNE 91510 NISSAN CUST024 CRUZ MESHIA 06985 NISSAN CUST026 ALASTAIR COOK 82414 NISSAN CUST030 JOE ROOT 98115 NISSAN CUST034 STUART BROAD 06015 NISSAN CUST017 BRANDA CLARKE 60606 NISSAN CUST029 IAN BELL 35353 NISSAN CUST019 AMINA GEORGE 32323 NISSAN CUST028 GRAY JAKE 65892 NISSAN CUST027 SAM ROBSON 06985 NISSAN CUST031 LIAM PLUNKETT 12649 NISSAN CUST033 BEN STOKES 02110 16 rows selected. SQL> SQL> SQL> /*9) Produce a detailed and formatted report showing the CUSTOMERS IDs, names, and zipcodes along with makes and models sold with summarized CUSTOMERS counts and make and model counts.*/ SQL> SELECT c.cust_id, 2 C.FIRST_NAME, 3 C.LAST_NAME, 4 C.ZIP, 5 v.make, 6 V.MODEL, 7 COUNT (c.cust_id) AS "CUSTOMERS COUNT", 8 COUNT (v.make) AS "MAKE COUNT", 9 COUNT (v.model) AS "MODEL COUNT" 10 FROM CUSTOMERS c 11 INNER JOIN SALES s 12 ON S.CUST_ID = C.CUST_ID 13 INNER JOIN VEHICLES v 14 ON S.VIN = v.vin 15 GROUP BY c.cust_id, 16 C.FIRST_NAME, 17 C.LAST_NAME, 18 C.ZIP, 19 v.make, 20 V.MODEL 21 ORDER BY c.cust_id; CUST_ID FIRST_NAME LAST_NAME ZIP MAKE MODEL CUSTOMERS COUNT MAKE COUNT MODEL COUNT ---------- --------------- --------------- ----- --------------- --------------- --------------- ---------- ----------- CUST001 PAUL MULIN 83707 MITSUBISHI LANCER 4 4 4 CUST001 PAUL MULIN 83707 TOYOTA COROLLA 3 3 3 CUST002 GRAVIN LEWIS 78710 ACURA TSX 3 3 3 CUST002 GRAVIN LEWIS 78710 MITSUBISHI LANCER 2 2 2 CUST002 GRAVIN LEWIS 78710 TOYOTA COROLLA 3 3 3 CUST003 MARK MULLER 30314 ACURA TSX 3 3 3 CUST003 MARK MULLER 30314 TOYOTA COROLLA 3 3 3 CUST004 STACY BARBER 34711 HONDA CIVIC 3 3 3 CUST004 STACY BARBER 34711 MAZDA MIATA 3 3 3 CUST005 WENDY BOVEL 31206 HONDA CIVIC 3 3 3 CUST005 WENDY BOVEL 31206 LINCOLN MKZ 3 3 3 CUST007 BERT GEORGE 33111 CHEVROLET IMPALA 3 3 3 CUST007 BERT GEORGE 33111 HONDA CIVIC 3 3 3 CUST007 BERT GEORGE 33111 MAZDA MIATA 3 3 3 CUST008 HARRY PAUL 49006 CHEVROLET IMPALA 3 3 3 CUST008 HARRY PAUL 49006 LINCOLN MKZ 3 3 3 CUST008 HARRY PAUL 49006 MAZDA MIATA 3 3 3 CUST009 BRANDON EARLHEART 08607 GM CTS CADILLAC 3 3 3 CUST009 BRANDON EARLHEART 08607 HONDA ACCORD 3 3 3 CUST010 HARRY PORTER 07962 HONDA ACCORD 6 6 6 CUST010 HARRY PORTER 07962 KIA OPTIMA 3 3 3 CUST011 LOANDA PAUL 82414 HONDA ACCORD 3 3 3 CUST011 LOANDA PAUL 82414 KIA OPTIMA 3 3 3 CUST012 ALTHEA ORR 12211 KIA OPTIMA 3 3 3 CUST012 ALTHEA ORR 12211 SUZUKI SX4 3 3 3 CUST013 VERONICA SKEETE 98115 SUBARU IMPREZA 6 6 6 CUST014 TRICIA FERGUSON 32306 TOYOTA AVALON 6 6 6 CUST015 RYAN BISHOP 82003 NISSAN INFINITI G 3 3 3 CUST015 RYAN BISHOP 82003 NISSAN MAXIMA 3 3 3 CUST016 GISSELLE ALLEYNE 91510 NISSAN INFINITI G 3 3 3 CUST016 GISSELLE ALLEYNE 91510 NISSAN TITAN 3 3 3 CUST017 BRANDA CLARKE 60606 NISSAN MAXIMA 3 3 3 CUST017 BRANDA CLARKE 60606 NISSAN SENTARA 3 3 3 CUST017 BRANDA CLARKE 60606 NISSAN TITAN 3 3 3 CUST019 AMINA GEORGE 32323 MAZDA MAZDA 6 3 3 3 CUST019 AMINA GEORGE 32323 NISSAN SENTARA 3 3 3 CUST020 TRICA CAMPBELL 12649 MAZDA MAZDA 3 3 3 3 CUST020 TRICA CAMPBELL 12649 MAZDA MAZDA 6 3 3 3 CUST021 DAUM MICHELL 98115 KIA FORTE 3 3 3 CUST021 DAUM MICHELL 98115 MAZDA RX-7 3 3 3 CUST022 SCHELL STEVE 35353 MAZDA MAZDA 3 3 3 3 CUST022 SCHELL STEVE 35353 MAZDA RX-7 3 3 3 CUST023 LEE JASMINE 65892 KIA CADENZA 3 3 3 CUST023 LEE JASMINE 65892 KIA KM420 3 3 3 CUST024 CRUZ MESHIA 06985 GM HUMMER 3 3 3 CUST024 CRUZ MESHIA 06985 NISSAN PHAETON 2 2 2 CUST024 CRUZ MESHIA 06985 ROLLS-ROYCE PHANTOM 3 3 3 CUST025 LUCAS JAKE 82414 GM HUMMER 3 3 3 CUST025 LUCAS JAKE 82414 ROLLS-ROYCE PHANTOM 3 3 3 CUST026 ALASTAIR COOK 82414 GM HUMMER 2 2 2 CUST026 ALASTAIR COOK 82414 NISSAN PHAETON 3 3 3 CUST027 SAM ROBSON 06985 GM HUMMER 2 2 2 CUST027 SAM ROBSON 06985 NISSAN CUBE 2 2 2 CUST027 SAM ROBSON 06985 ROLLS-ROYCE PHANTOM 2 2 2 CUST028 GRAY JAKE 65892 NISSAN CUBE 2 2 2 CUST028 GRAY JAKE 65892 NISSAN SENTRE 2 2 2 CUST029 IAN BELL 35353 NISSAN MURANO 2 2 2 CUST029 IAN BELL 35353 NISSAN SENTRE 2 2 2 CUST030 JOE ROOT 98115 NISSAN COPE 2 2 2 CUST030 JOE ROOT 98115 NISSAN MURANO 2 2 2 CUST031 LIAM PLUNKETT 12649 NISSAN COPE 2 2 2 CUST031 LIAM PLUNKETT 12649 NISSAN MURANO 2 2 2 CUST032 MATT PRIOR 32323 NISSAN ARMADA 2 2 2 CUST032 MATT PRIOR 32323 NISSAN COPE 2 2 2 CUST033 BEN STOKES 02110 NISSAN ARMADA 2 2 2 CUST033 BEN STOKES 02110 NISSAN ROUGE 2 2 2 CUST034 STUART BROAD 06015 NISSAN JUKE 2 2 2 CUST034 STUART BROAD 06015 NISSAN ROUGE 2 2 2 CUST034 STUART BROAD 06015 TOYOTA LAND CRUISER 2 2 2 CUST035 JAMES ANDERSON 91510 NISSAN QUEST 4 4 4 CUST035 JAMES ANDERSON 91510 NISSAN ROUGE 2 2 2 CUST036 ALVIRO PETERSON 82003 NISSAN QUEST 2 2 2 CUST036 ALVIRO PETERSON 82003 TOYOTA LAND CRUISER 4 4 4 CUST036 ALVIRO PETERSON 82003 TOYOTA RAV4 2 2 2 CUST037 DEAN ELGAR 12548 TOYOTA CAMRY 2 2 2 CUST037 DEAN ELGAR 12548 TOYOTA RAV4 2 2 2 CUST037 DEAN ELGAR 12548 TOYOTA TENDRA 2 2 2 CUST038 DALE STEYN 98115 TOYOTA CAMRY 2 2 2 CUST038 DALE STEYN 98115 TOYOTA TENDRA 2 2 2 CUST039 PAUL DUMINY 12211 TOYOTA CAMRY 2 2 2 CUST039 PAUL DUMINY 12211 TOYOTA TENDRA 2 2 2 CUST039 PAUL DUMINY 12211 TOYOTA YARIS 2 2 2 CUST040 MORNE MORKEL 12356 HONDA CR-V 2 2 2 CUST040 MORNE MORKEL 12356 TOYOTA YARIS 2 2 2 CUST041 MATHEWS ANGELO 56897 HONDA CR-Z 2 2 2 CUST041 MATHEWS ANGELO 56897 TOYOTA YARIS 2 2 2 CUST044 PHILIPS HUGHES 08607 HONDA FIT 4 4 4 CUST045 CHRIS LYNN 82414 HONDA CR-Z 4 4 4 CUST046 CALLUM FERGUSON 06015 GM SIERRA 2 2 2 CUST047 MITCHELL MARSH 82003 GM SIERRA 2 2 2 CUST047 MITCHELL MARSH 82003 KIA RIO 2 2 2 CUST048 CAMERON BOYCE 12546 KIA RIO 2 2 2 92 rows selected. SQL> SQL> SPOOL OFF