Insert into salesaleid vin custid salespersonid

This preview shows page 14 - 16 out of 26 pages.

insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('127', '37', '7', 'a1', '0', '13-JAN-18', '67900', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('128', '38', '10', 'b1', '0', '20-JAN-18', '40250', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('129', '39', '9', 'a1', '0', '16-FEB-18', '27705', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('130', '40', '8', 'c1', '0', '15-JAN-18', '31795', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('131', '41', '1', 'a1', '20000', '21-JAN- 18', '22000.99', 'Used'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('132', '42', '2', 'b1', '0', '15-OCT-18', '191000', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('133', '43', '5', 'a1', '62000', '25-JAN- 18', '12500', 'Used'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('134', '44', '4', 'a1', '0', '30-JAN-18', '33000', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('135', '45', '6', 'k1', '0', '10-NOV-18', '157296', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('136', '46', '3', 'f1', '0', '10-DEC-18', '17950', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('137', '47', '7', 'a1', '0', '23-NOV-18', '67900', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('138', '48', '10', 'b1', '0', '02-OCT-18', '40250', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('139', '49', '9', 'a1', '0', '06-MAR-18', '27705', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('140', '50', '8', 'c1', '0', '14-OCT-18', '31795', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('141', '01', '1', 'a1', '20000', '12-JAN- 18', '22000.99', 'Used'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('142', '02', '2', 'b1', '0', '10-OCT-18', '191000', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('143', '03', '5', 'a1', '62000', '15-JAN- 18', '12500', 'Used'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('144', '04', '4', 'a1', '0', '31-JAN-18', '33000', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('145', '05', '6', 'k1', '0', '11-JAN-18', '157296', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('146', '06', '3', 'f1', '0', '01-NOV-18', '17950', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate,
grossSaleprice, vehiclestatus) values('147', '07', '7', 'a1', '0', '30-OCT-18', '67900', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('148', '08', '10', 'b1', '0', '20-JAN-18', '40250', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate, grossSaleprice, vehiclestatus) values('149', '09', '9', 'a1', '0', '06-DEC-18', '27705', 'New'); insert into sale(sale_id, vin, cust_id, salesperson_id, mileage, sdate,

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture