SET SERVEROUTPUT ON FORMAT WRAPPED
SPOOL E:\Homework3Spool.txt

/*2) Add 25 CUSTOMERSs so that you now have 50 total.*/
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST026', 'ALASTAIR', 'COOK', 'P.O. BOX 2947', 
    'CODY', 'WY', '82414');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST027', 'SAM', 'ROBSON', 'P.O. BOX 851', 
    'CHICAGO', 'IL', '06985');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST028', 'GRAY', 'JAKE', 'P.O. BOX 983', 
    'SANTA MONICA', 'CA', '65892');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST029', 'IAN', 'BELL', 'P.O. BOX 650', 
    'EASTPOINT', 'FL', '35353');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST030', 'JOE', 'ROOT', 'P.O. BOX 150', 
    'SEATTLE', 'WA', '98115');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST031', 'LIAM', 'PLUNKETT', 'P.O. BOX 9835', 
    'SANTA MONICA', 'CA', '12649');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST032', 'MATT', 'PRIOR', 'P.O. BOX 651', 
    'EASTPOINT', 'FL', '32323');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST033', 'BEN', 'STOKES', 'P.O. BOX 971', 
    'BOSTON', 'MA', '02110');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST034', 'STUART', 'BROAD', 'P.O. BOX 18', 
    'CHICAGO', 'IL', '06015');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST035', 'JAMES', 'ANDERSON', 'P.O. BOX 8564', 
    'BURBANK', 'CA', '91510');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST036', 'ALVIRO', 'PETERSON', 'P.O. BOX 137', 
    'CHEYENNE', 'WY', '82003');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST037', 'DEAN', 'ELGAR', 'P.O. BOX 66', 
    'TALLAHASSEE', 'FL', '12548');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST038', 'DALE', 'STEYN', 'P.O. BOX 851', 
    'SEATTLE', 'WA', '98115');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST039', 'PAUL', 'DUMINY', '82 DIRT ROAD', 
    'ALBANY', 'NY', '12211');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST040', 'MORNE', 'MORKEL', '9851231 LONG ROAD', 
    'BURBANK', 'CA', '12356');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST041', 'MATHEWS', 'ANGELO', '9153 MAIN STREET', 
    'AUSTIN', 'TX', '56897');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST042', 'JAMES', 'ERANGA', '357 WHITE EAGLE AVE', 
    'CLERMONT', 'FL', '34711');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST043', 'CAMERON', 'WHITE', 'P.O. BOX 677', 
    'MIAMI', 'FL', '33111');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST044', 'PHILIPS', 'HUGHES', 'P.O. BOX 335', 
    'TRENTON', 'NJ', '08607');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST045', 'CHRIS', 'LYNN', 'P.O. BOX 2947', 
    'CODY', 'WY', '82414');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST046', 'CALLUM', 'FERGUSON', 'P.O. BOX 18', 
    'CHICAGO', 'IL', '06015');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST047', 'MITCHELL', 'MARSH', 'P.O. BOX 137', 
    'CHEYENNE', 'WY', '82003');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST048', 'CAMERON', 'BOYCE', '1008 GRAND AVENUE', 
    'MACON', 'GA', '12546');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST049', 'KANE', 'RICHARDSON', 'P.O. BOX 851', 
    'SEATTLE', 'WA', '98115');
Insert into CUSTOMERS
   (CUST_ID, FIRST_NAME, LAST_NAME, STREET_ADDRESS, CITY, STATE, ZIP)
 Values
   ('CUST050', 'ASHKAR', 'PATEL', '69821 SOUTH AVENUE', 
    'BOISE', 'ID', '23568');
COMMIT;


/*3) Add 25 vehicles so that you now have 50 total.*/
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN026', 'OS001', 'TRADE001', 'SEDAN', 'PHAETON', 
    'NISSAN', 'JAPAN', '100000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN027', 'OS001', 'TRADE001', 'SEDAN', 'SENTRE', 
    'NISSAN', 'JAPAN', '5000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN028', 'OS001', 'TRADE001', 'SEDAN', 'CUBE', 
    'NISSAN', 'JAPAN', '26000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN029', 'OS001', 'TRADE001', 'SUV', 'MURANO', 
    'NISSAN', 'JAPAN', '50000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN030', 'OS001', 'TRADE001', 'SALOON', 'COPE', 
    'NISSAN', 'JAPAN', '45000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN031', 'OS001', 'TRADE001', 'SUV', 'ARMADA', 
    'NISSAN', 'JAPAN', '10000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN032', 'OS001', 'TRADE001', 'SUV', 'ROUGE', 
    'NISSAN', 'JAPAN', '15000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN033', 'OS001', 'TRADE001', 'SUV', 'JUKE', 
    'NISSAN', 'JAPAN', '20000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN034', 'OS001', 'TRADE001', 'TRUCK', 'QUEST', 
    'NISSAN', 'JAPAN', '10000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN035', 'OS001', 'TRADE001', 'SUV', 'LAND CRUISER', 
    'TOYOTA', 'JAPAN', '25000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN036', 'OS001', 'TRADE001', 'SUV', 'RAV4', 
    'TOYOTA', 'JAPAN', '10000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN037', 'OS001', 'TRADE001', 'SALOON', 'CAMRY', 
    'TOYOTA', 'JAPAN', '25000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN038', 'OS001', 'TRADE001', 'TRUCK', 'TENDRA', 
    'TOYOTA', 'JAPAN', '26000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN039', 'OS001', 'TRADE001', 'HATCHBACK', 'YARIS', 
    'TOYOTA', 'JAPAN', '35000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN040', 'OS001', 'TRADE001', 'SUV', 'CR-V', 
    'HONDA', 'JAPAN', '30000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN041', 'OS001', 'TRADE001', 'HATCHBACK', 'FIT', 
    'HONDA', 'JAPAN', '18000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN042', 'OS001', 'TRADE001', 'HYBRID', 'CR-Z', 
    'HONDA', 'JAPAN', '12000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN043', 'OS001', 'TRADE001', 'SEDAN', 'INSIGHT', 
    'HONDA', 'JAPAN', '14000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN044', 'OS001', 'TRADE001', 'SEDAN', 'TERRAIN', 
    'GM', 'USA', '16000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN045', 'OS001', 'TRADE001', 'SUV', 'YUKON', 
    'GM', 'USA', '12000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN046', 'OS001', 'TRADE001', 'TRUCK', 'SIERRA', 
    'GM', 'USA', '60000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN047', 'OS001', 'TRADE001', 'SEDAN', 'RIO', 
    'KIA', 'JAPAN', '50000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN048', 'OS001', 'TRADE001', 'HATCHBACK', 'VENGA', 
    'KIA', 'JAPAN', '25000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN049', 'OS001', 'TRADE001', 'SUV', 'SOUL', 
    'KIA', 'JAPAN', '20000');
Insert into VEHICLES
   (VIN, OS_ID, TRADE_ID, TYPE, MODEL, MAKE, WHERE_FROM, WHOLESALE_COST)
 Values
   ('VIN050', 'OS001', 'TRADE001', 'SEDAN', 'OPTMA', 
    'KIA', 'JAPAN', '15000');
COMMIT;


/*4) Add 200 sales so that you now have 250 total.*/
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE051', 'CUST025', 'VIN024', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 200, 6364);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE052', 'CUST025', 'VIN025', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 16601);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE053', 'CUST024', 'VIN026', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 15318);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE054', 'CUST026', 'VIN026', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 23762);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE055', 'CUST027', 'VIN024', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 10703);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE056', 'CUST026', 'VIN025', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 21377);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE057', 'CUST027', 'VIN025', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 6571);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE058', 'CUST028', 'VIN027', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5500, 18906);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE059', 'CUST027', 'VIN028', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6500, 16429);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE060', 'CUST029', 'VIN029', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1522, 21957);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE061', 'CUST028', 'VIN028', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 22345);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE062', 'CUST029', 'VIN027', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8500, 17250);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE063', 'CUST030', 'VIN029', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9500, 10961);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE064', 'CUST030', 'VIN030', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7500, 14158);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE065', 'CUST031', 'VIN030', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7000, 24385);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE066', 'CUST031', 'VIN029', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8000, 19714);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE067', 'CUST032', 'VIN031', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9000, 11001);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE068', 'CUST033', 'VIN031', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 15645);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE069', 'CUST032', 'VIN030', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 10888);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE070', 'CUST033', 'VIN032', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 14118);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE071', 'CUST034', 'VIN032', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 13674);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE072', 'CUST034', 'VIN033', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 8550);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE073', 'CUST035', 'VIN032', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 17837);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE074', 'CUST035', 'VIN034', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6300, 10472);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE075', 'CUST034', 'VIN035', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5300, 6624);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE076', 'CUST036', 'VIN034', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4300, 7734);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE077', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3300, 11465);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE078', 'CUST035', 'VIN034', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1300, 21276);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE079', 'CUST036', 'VIN036', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2100, 17319);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE080', 'CUST037', 'VIN036', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3100, 5274);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE081', 'CUST037', 'VIN037', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4100, 14524);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE082', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5100, 20954);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE083', 'CUST037', 'VIN038', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6100, 22907);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE084', 'CUST038', 'VIN037', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4400, 20445);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE085', 'CUST039', 'VIN037', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5400, 21843);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE086', 'CUST038', 'VIN038', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7400, 18426);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE087', 'CUST039', 'VIN038', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6400, 14835);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE088', 'CUST040', 'VIN039', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9400, 12419);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE089', 'CUST039', 'VIN039', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3600, 24139);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE090', 'CUST040', 'VIN040', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2600, 21521);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE091', 'CUST041', 'VIN039', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6600, 19246);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE092', 'CUST044', 'VIN041', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5600, 16388);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE093', 'CUST045', 'VIN042', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4600, 16406);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE094', 'CUST044', 'VIN041', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1600, 11989);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE095', 'CUST045', 'VIN042', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7600, 5075);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE096', 'CUST046', 'VIN046', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4600, 11240);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE097', 'CUST041', 'VIN042', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4500, 17974);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE098', 'CUST047', 'VIN047', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 23769);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE099', 'CUST047', 'VIN046', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 15905);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE100', 'CUST048', 'VIN047', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 13368);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE101', 'CUST002', 'VIN001', 'SP001', 'RUNNING', 
    TO_DATE('07/16/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8500, 23541);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE102', 'CUST001', 'VIN002', 'SP001', 'RUNNING', 
    TO_DATE('07/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 9263);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE103', 'CUST001', 'VIN001', 'SP002', 'RUNNING', 
    TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 11597);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE104', 'CUST002', 'VIN002', 'SP001', 'RUNNING', 
    TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 15151);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE105', 'CUST002', 'VIN003', 'SP002', 'RUNNING', 
    TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 6547);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE106', 'CUST003', 'VIN002', 'SP003', 'RUNNING', 
    TO_DATE('07/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18880);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE107', 'CUST004', 'VIN004', 'SP002', 'RUNNING', 
    TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 20987);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE108', 'CUST003', 'VIN003', 'SP003', 'RUNNING', 
    TO_DATE('07/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 11670);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE109', 'CUST004', 'VIN005', 'SP003', 'RUNNING', 
    TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 21469);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE110', 'CUST005', 'VIN006', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 21697);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE111', 'CUST005', 'VIN005', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 8447);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE112', 'CUST007', 'VIN004', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 21713);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE113', 'CUST008', 'VIN007', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 49000, 20421);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE114', 'CUST008', 'VIN004', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 13096);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE115', 'CUST007', 'VIN005', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 34000, 11529);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE116', 'CUST007', 'VIN007', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 5689);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE117', 'CUST008', 'VIN006', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 21000, 7560);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE118', 'CUST009', 'VIN008', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 18006);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE119', 'CUST010', 'VIN009', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 14211);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE120', 'CUST009', 'VIN009', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 5824);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE121', 'CUST010', 'VIN010', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3200, 18190);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE122', 'CUST010', 'VIN009', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 23335);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE123', 'CUST011', 'VIN009', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 6723);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE124', 'CUST011', 'VIN010', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 5234);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE125', 'CUST012', 'VIN010', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 23000, 24531);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE126', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 15791);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE127', 'CUST012', 'VIN012', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 19243);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE128', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 23187);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE129', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 18484);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE130', 'CUST015', 'VIN014', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 24312);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE131', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 15302);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE132', 'CUST016', 'VIN014', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 20903);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE133', 'CUST015', 'VIN015', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 13274);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE134', 'CUST016', 'VIN016', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 7614);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE135', 'CUST017', 'VIN015', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 60000, 22657);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE136', 'CUST017', 'VIN017', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 13059);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE137', 'CUST019', 'VIN018', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13000, 18206);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE138', 'CUST017', 'VIN016', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 23454);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE139', 'CUST019', 'VIN017', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 22502);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE140', 'CUST020', 'VIN018', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 13062);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE141', 'CUST021', 'VIN019', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 7501);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE142', 'CUST022', 'VIN019', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 15580);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE143', 'CUST020', 'VIN020', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 23936);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE144', 'CUST021', 'VIN021', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 18183);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE145', 'CUST022', 'VIN020', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 20996);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE146', 'CUST023', 'VIN022', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 9539);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE147', 'CUST023', 'VIN023', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 22808);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE148', 'CUST024', 'VIN024', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18294);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE149', 'CUST024', 'VIN025', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 19533);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE150', 'CUST025', 'VIN024', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 13464);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE151', 'CUST025', 'VIN025', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 7999);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE152', 'CUST024', 'VIN026', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 21912);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE153', 'CUST026', 'VIN026', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 7481);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE154', 'CUST027', 'VIN024', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 22602);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE155', 'CUST026', 'VIN025', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 16344);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE156', 'CUST027', 'VIN025', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 5386);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE157', 'CUST028', 'VIN027', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 5692);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE158', 'CUST027', 'VIN028', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 5802);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE159', 'CUST029', 'VIN029', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 7146);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE160', 'CUST028', 'VIN028', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 9460);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE161', 'CUST029', 'VIN027', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 6159);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE162', 'CUST030', 'VIN029', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 16473);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE163', 'CUST030', 'VIN030', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 19067);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE164', 'CUST031', 'VIN030', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 13630);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE165', 'CUST031', 'VIN029', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4500, 5083);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE166', 'CUST032', 'VIN031', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 19795);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE167', 'CUST033', 'VIN031', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 21398);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE168', 'CUST032', 'VIN030', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9000, 7629);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE169', 'CUST033', 'VIN032', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8000, 6333);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE170', 'CUST034', 'VIN032', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7000, 23925);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE171', 'CUST034', 'VIN033', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 20224);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE172', 'CUST035', 'VIN032', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 20173);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE173', 'CUST035', 'VIN034', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 23363);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE174', 'CUST034', 'VIN035', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 8114);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE175', 'CUST036', 'VIN034', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18174);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE176', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 22890);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE177', 'CUST035', 'VIN034', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 14238);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE178', 'CUST036', 'VIN036', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 23827);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE179', 'CUST037', 'VIN036', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 9027);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE180', 'CUST037', 'VIN037', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 14941);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE181', 'CUST036', 'VIN035', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 13203);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE182', 'CUST037', 'VIN038', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 20723);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE183', 'CUST038', 'VIN037', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 60000, 23447);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE184', 'CUST039', 'VIN037', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7000, 12656);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE185', 'CUST038', 'VIN038', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 80000, 24007);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE186', 'CUST039', 'VIN038', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 70000, 21444);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE187', 'CUST040', 'VIN039', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 80000, 13274);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE188', 'CUST039', 'VIN039', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 90000, 15280);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE189', 'CUST040', 'VIN040', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 8838);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE190', 'CUST041', 'VIN039', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 12597);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE191', 'CUST044', 'VIN041', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 24855);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE192', 'CUST045', 'VIN042', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4500, 18267);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE193', 'CUST044', 'VIN041', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 6192);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE194', 'CUST045', 'VIN042', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6500, 16504);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE195', 'CUST046', 'VIN046', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5500, 20305);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE196', 'CUST041', 'VIN042', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 14290);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE197', 'CUST047', 'VIN047', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 15556);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE198', 'CUST047', 'VIN046', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 18211);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE199', 'CUST048', 'VIN047', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 13969);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE200', 'CUST001', 'VIN002', 'SP001', 'RUNNING', 
    TO_DATE('07/15/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 18036);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE201', 'CUST001', 'VIN001', 'SP002', 'RUNNING', 
    TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 8936);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE202', 'CUST002', 'VIN002', 'SP001', 'RUNNING', 
    TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4000, 7917);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE203', 'CUST002', 'VIN003', 'SP002', 'RUNNING', 
    TO_DATE('07/10/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 14502);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE204', 'CUST003', 'VIN002', 'SP003', 'RUNNING', 
    TO_DATE('07/12/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 14514);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE205', 'CUST004', 'VIN004', 'SP002', 'RUNNING', 
    TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3500, 7236);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE206', 'CUST003', 'VIN003', 'SP003', 'RUNNING', 
    TO_DATE('07/19/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 17030);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE207', 'CUST004', 'VIN005', 'SP003', 'RUNNING', 
    TO_DATE('07/01/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 18338);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE208', 'CUST005', 'VIN006', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 5482);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE209', 'CUST005', 'VIN005', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 23797);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE210', 'CUST007', 'VIN004', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 45000, 11241);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE211', 'CUST008', 'VIN007', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 49000, 17228);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE212', 'CUST008', 'VIN004', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 19366);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE213', 'CUST007', 'VIN005', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 34000, 17525);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE214', 'CUST007', 'VIN007', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000, 19328);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE215', 'CUST008', 'VIN006', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 21000, 15481);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE216', 'CUST009', 'VIN008', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 11934);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE217', 'CUST010', 'VIN009', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 7046);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE218', 'CUST009', 'VIN009', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 13289);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE219', 'CUST010', 'VIN010', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3200, 17287);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE220', 'CUST010', 'VIN009', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 12025);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE221', 'CUST011', 'VIN009', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 13742);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE222', 'CUST011', 'VIN010', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 21489);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE223', 'CUST012', 'VIN010', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 23000, 22519);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE224', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12000, 18674);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE225', 'CUST012', 'VIN012', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 18346);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE226', 'CUST013', 'VIN011', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6000, 7586);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE227', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 12002);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE228', 'CUST015', 'VIN014', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 7893);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE229', 'CUST014', 'VIN013', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 15131);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE230', 'CUST016', 'VIN014', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 21825);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE231', 'CUST015', 'VIN015', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 13496);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE232', 'CUST016', 'VIN016', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10000, 11385);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE233', 'CUST017', 'VIN015', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 60000, 13794);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE234', 'CUST017', 'VIN017', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 22395);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE235', 'CUST019', 'VIN018', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13000, 5156);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE236', 'CUST017', 'VIN016', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 19371);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE237', 'CUST019', 'VIN017', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 7738);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE238', 'CUST020', 'VIN018', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 25000, 20023);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE239', 'CUST021', 'VIN019', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 24432);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE240', 'CUST022', 'VIN019', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 15964);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE241', 'CUST020', 'VIN020', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15000, 8302);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE242', 'CUST021', 'VIN021', 'SP003', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 20000, 19941);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE243', 'CUST022', 'VIN020', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 30000, 11003);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE244', 'CUST023', 'VIN022', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 40000, 10781);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE245', 'CUST023', 'VIN023', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 50000, 7244);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE246', 'CUST024', 'VIN024', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2000, 6671);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE247', 'CUST024', 'VIN025', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1000, 23233);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE248', 'CUST025', 'VIN024', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2500, 7617);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE249', 'CUST025', 'VIN025', 'SP002', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1500, 12681);
Insert into SALES
   (SALE_ID, CUST_ID, VIN, SALESPERSON_ID, VEHICLE_STATUS, SALE_DATE, MILEAGE, GROSS_SALE_PRICE)
 Values
   ('SALE250', 'CUST026', 'VIN026', 'SP001', 'RUNNING', 
    TO_DATE('07/20/2014 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3000, 22437);
COMMIT;

set linesize 150 pagesize 100

/*5) Via a single SELECT query display the total count of sales, and the lowest, average, and highest SALES price.*/
SELECT COUNT (*) AS "COUNT OF SALES",
       AVG (WHOLESALE_COST) AS "AVERAGE SALES",
       MIN (WHOLESALE_COST) AS "LOWEST SALES",
       MAX (WHOLESALE_COST) AS "HIGHEST SALES"
  FROM SALES s INNER JOIN VEHICLES v ON S.VIN = v.vin;

/*6) Via a single SELECT query display all CUSTOMERS IDs, names, and zip codes of CUSTOMERSs having purchased 5 or more vehicles.*/
SELECT S.CUST_ID, C.FIRST_NAME, C.ZIP
    FROM SALES S INNER JOIN CUSTOMERS C ON S.CUST_ID = C.CUST_ID
GROUP BY S.CUST_ID, C.FIRST_NAME, C.ZIP
  HAVING COUNT (*) >= 5;

/*7) Via a single SELECT query display the institution and loan type of the financing plan used for the most sales.*/
SELECT INSTITUTION, LOAN_TYPE
  FROM FINANCING_PLANS
 WHERE plan_id = (SELECT x.PLAN_ID
                    FROM (  SELECT sf.PLAN_ID,
                                   COUNT (*) AS plan_count,
                                   RANK () OVER (ORDER BY COUNT (*) DESC)
                                      AS RANK
                              FROM    SALES s
                                   INNER JOIN
                                      SALE_FINANCINGS sf
                                   ON S.SALE_ID = SF.SALE_ID
                          GROUP BY sf.PLAN_ID) x
                   WHERE x.RANK = 1);


/*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.*/
SELECT DISTINCT v.make,
                c.cust_id,
                C.FIRST_NAME,
                C.LAST_NAME,
                C.ZIP
  FROM CUSTOMERS c
       INNER JOIN SALES s
          ON S.CUST_ID = C.CUST_ID
       INNER JOIN VEHICLES v
          ON S.VIN = v.vin
 WHERE V.MAKE = (SELECT x.make
                   FROM (  SELECT v.make,
                                  COUNT (*) AS veh_count,
                                  RANK () OVER (ORDER BY COUNT (*) DESC)
                                     AS RANK
                             FROM    SALES s
                                  INNER JOIN
                                     VEHICLES v
                                  ON S.VIN = v.vin
                         GROUP BY v.make) x
                  WHERE x.RANK = 1);


/*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.*/
SELECT c.cust_id,
         C.FIRST_NAME,
         C.LAST_NAME,
         C.ZIP,
         v.make,
         V.MODEL,
         COUNT (c.cust_id) AS "CUSTOMERS COUNT",
         COUNT (v.make) AS "MAKE COUNT",
         COUNT (v.model) AS "MODEL COUNT"
    FROM CUSTOMERS c
         INNER JOIN SALES s
            ON S.CUST_ID = C.CUST_ID
         INNER JOIN VEHICLES v
            ON S.VIN = v.vin
GROUP BY c.cust_id,
         C.FIRST_NAME,
         C.LAST_NAME,
         C.ZIP,
         v.make,
         V.MODEL
ORDER BY c.cust_id;

SPOOL OFF