ALTER TABLE JOB DROP PRIMARY KEY CASCADE;
DROP TABLE JOB CASCADE CONSTRAINTS;

CREATE TABLE JOB
(
  JOB_ID    NUMBER(3)                           NOT NULL,
  FUNCTION  VARCHAR2(30 BYTE)                       NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE JOB IS 'All valid job categories for personnel information.';

COMMENT ON COLUMN JOB.JOB_ID IS 'Unique 3-digit code for job function and title.';

COMMENT ON COLUMN JOB.FUNCTION IS 'Generic function class of job.';


ALTER TABLE LOCATION DROP PRIMARY KEY CASCADE;
DROP TABLE LOCATION CASCADE CONSTRAINTS;

CREATE TABLE LOCATION
(
  LOCATION_ID     NUMBER(3)                     NOT NULL,
  REGIONAL_GROUP  VARCHAR2(20 BYTE)                 NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE LOCATION IS 'Location information for all U.S. departments and warehouses.';

COMMENT ON COLUMN LOCATION.LOCATION_ID IS 'Central location corporate location code.';

COMMENT ON COLUMN LOCATION.REGIONAL_GROUP IS 'Metropolitan center closest to location.';


ALTER TABLE PRODUCT DROP PRIMARY KEY CASCADE;
DROP TABLE PRODUCT CASCADE CONSTRAINTS;

CREATE TABLE PRODUCT
(
  PRODUCT_ID   NUMBER(6)                        NOT NULL,
  DESCRIPTION  VARCHAR2(30 BYTE)                    NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE PRODUCT IS 'Products in catalog.  Pricing information can be found in table PRICE.';

COMMENT ON COLUMN PRODUCT.PRODUCT_ID IS 'Unique 6 digit number assigned to all products.  Number generated by sequence PRODUCT_ID.';

COMMENT ON COLUMN PRODUCT.DESCRIPTION IS 'Full product name (up to 30 characters).  Storing product names in all caps is recommended but not required.';


ALTER TABLE SALARY_GRADE DROP PRIMARY KEY CASCADE;
DROP TABLE SALARY_GRADE CASCADE CONSTRAINTS;

CREATE TABLE SALARY_GRADE
(
  GRADE_ID     NUMBER(3)                        NOT NULL,
  LOWER_BOUND  NUMBER(7,2)                          NULL,
  UPPER_BOUND  NUMBER(7,2)                          NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE SALARY_GRADE IS 'Salary grade levels.  Used to classify monthly salary information in U.S. dollars, as found in EMP.SAL.';

COMMENT ON COLUMN SALARY_GRADE.GRADE_ID IS 'Number used to grade salaries.  Higher salary grade numbers denote higher salaries.';

COMMENT ON COLUMN SALARY_GRADE.LOWER_BOUND IS 'The lowest monthly salary (rounded to the nearest U.S. dollar) that applies to a particular salary grade. (i.e. the condition ROUND(EMP.SAL) >= LOWER_BOUND must be met.)';

COMMENT ON COLUMN SALARY_GRADE.UPPER_BOUND IS 'The highest monthly salary (rounded to the nearest U.S. dollar) that applies to a particular salary grade. (i.e. the condition ROUND(EMP.SAL) <= UPPER_BOUND must be met.)';


CREATE UNIQUE INDEX I_JOB$JOB_ID ON JOB
(JOB_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX I_LOCATION$LOCATION_ID ON LOCATION
(LOCATION_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX I_PRODUCT$PRODUCT_ID ON PRODUCT
(PRODUCT_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX I_SALARY_GRADE$GRADE_ID ON SALARY_GRADE
(GRADE_ID)
LOGGING
NOPARALLEL;


ALTER TABLE DEPARTMENT DROP PRIMARY KEY CASCADE;
DROP TABLE DEPARTMENT CASCADE CONSTRAINTS;

CREATE TABLE DEPARTMENT
(
  DEPARTMENT_ID  NUMBER(2)                      NOT NULL,
  NAME           VARCHAR2(14 BYTE)                  NULL,
  LOCATION_ID    NUMBER(3)                          NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE DEPARTMENT IS 'Department information for all U.S. operations.';

COMMENT ON COLUMN DEPARTMENT.DEPARTMENT_ID IS 'Department number: Unique 2-digit department number assigned to each department.';

COMMENT ON COLUMN DEPARTMENT.NAME IS 'Department name: Only the first 14 characters of a department name can be stored in the database.  Storing names in all caps is recommended but not required.';

COMMENT ON COLUMN DEPARTMENT.LOCATION_ID IS 'Department location: The code for where the department''s central office is located.  (LOCATION)';


ALTER TABLE EMPLOYEE DROP PRIMARY KEY CASCADE;
DROP TABLE EMPLOYEE CASCADE CONSTRAINTS;

CREATE TABLE EMPLOYEE
(
  EMPLOYEE_ID     NUMBER(4)                     NOT NULL,
  LAST_NAME       VARCHAR2(15 BYTE)                 NULL,
  FIRST_NAME      VARCHAR2(15 BYTE)                 NULL,
  MIDDLE_INITIAL  VARCHAR2(1 BYTE)                  NULL,
  JOB_ID          NUMBER(3)                         NULL,
  MANAGER_ID      NUMBER(4)                         NULL,
  HIRE_DATE       DATE                              NULL,
  SALARY          NUMBER(7,2)                       NULL,
  COMMISSION      NUMBER(7,2)                       NULL,
  DEPARTMENT_ID   NUMBER(2)                         NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE EMPLOYEE IS 'General information on all corporate employees.';

COMMENT ON COLUMN EMPLOYEE.EMPLOYEE_ID IS 'Employee Number: Unique 4-digit identification number assigned to every employee.';

COMMENT ON COLUMN EMPLOYEE.LAST_NAME IS 'Last name of employee.  Stored in all caps.';

COMMENT ON COLUMN EMPLOYEE.FIRST_NAME IS 'First name of employee.  Stored in all caps.';

COMMENT ON COLUMN EMPLOYEE.MIDDLE_INITIAL IS 'Middle initial (one character only).  Stored in all caps.';

COMMENT ON COLUMN EMPLOYEE.JOB_ID IS 'Job identification number.  See JOB for descriptions.';

COMMENT ON COLUMN EMPLOYEE.MANAGER_ID IS 'Manager: The employee number of this employee''s manager.  If employee has no manager, value should be NULL.';

COMMENT ON COLUMN EMPLOYEE.HIRE_DATE IS 'Date the employee was HIRED, not necessarily the day the employee STARTED.';

COMMENT ON COLUMN EMPLOYEE.SALARY IS 'Monthly salary for the employee in U.S. dollars.  Salary grade information can be found in the table SALARY_GRADE.';

COMMENT ON COLUMN EMPLOYEE.COMMISSION IS 'Commission (in U.S. dollars) earned last month.  This field should be NULL for non-commissioned employees.';

COMMENT ON COLUMN EMPLOYEE.DEPARTMENT_ID IS 'Employee''s department number.  Further department information is available in the table DEPT.';


ALTER TABLE PRICE DROP PRIMARY KEY CASCADE;
DROP TABLE PRICE CASCADE CONSTRAINTS;

CREATE TABLE PRICE
(
  PRODUCT_ID  NUMBER(6)                         NOT NULL,
  LIST_PRICE  NUMBER(8,2)                           NULL,
  MIN_PRICE   NUMBER(8,2)                           NULL,
  START_DATE  DATE                              NOT NULL,
  END_DATE    DATE                                  NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE PRICE IS 'Prices (both standard and minimum) of products.  Database tracks both effective dates and expiration dates for prices.';

COMMENT ON COLUMN PRICE.PRODUCT_ID IS 'Product number to which price applies.  Product name found in table PRICE.';

COMMENT ON COLUMN PRICE.LIST_PRICE IS 'Undiscounted price (in U.S. dollars).';

COMMENT ON COLUMN PRICE.MIN_PRICE IS 'Lowest price (in U.S. dollars) that can be offered.';

COMMENT ON COLUMN PRICE.START_DATE IS 'Date which standard and minimum prices go into effect.';

COMMENT ON COLUMN PRICE.END_DATE IS 'Date which standard and minimum price expire.  This value can be left NULL.';


CREATE UNIQUE INDEX I_DEPARTMENT$DEPARTMENT_ID ON DEPARTMENT
(DEPARTMENT_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX I_EMPLOYEE$EMPLOYEE_ID ON EMPLOYEE
(EMPLOYEE_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX I_PRICE ON PRICE
(PRODUCT_ID, START_DATE)
LOGGING
NOPARALLEL;


ALTER TABLE CUSTOMER DROP PRIMARY KEY CASCADE;
DROP TABLE CUSTOMER CASCADE CONSTRAINTS;

CREATE TABLE CUSTOMER
(
  CUSTOMER_ID     NUMBER(6)                     NOT NULL,
  NAME            VARCHAR2(45 BYTE)                 NULL,
  ADDRESS         VARCHAR2(40 BYTE)                 NULL,
  CITY            VARCHAR2(30 BYTE)                 NULL,
  STATE           VARCHAR2(2 BYTE)                  NULL,
  ZIP_CODE        VARCHAR2(9 BYTE)                  NULL,
  AREA_CODE       NUMBER(3)                         NULL,
  PHONE_NUMBER    NUMBER(7)                         NULL,
  SALESPERSON_ID  NUMBER(4)                         NULL,
  CREDIT_LIMIT    NUMBER(9,2)                       NULL,
  COMMENTS        LONG                              NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE CUSTOMER IS 'Information on all U.S. customers and prospective customers.';

COMMENT ON COLUMN CUSTOMER.CUSTOMER_ID IS 'Unique 6 digit number assigned to all customers.  Number generated by the sequence CUSTOMER_ID.';

COMMENT ON COLUMN CUSTOMER.NAME IS 'Full store name of every customer (up to 45 characters).  Storing names in all caps is recommended but not required.';

COMMENT ON COLUMN CUSTOMER.ADDRESS IS 'Street address of customer.  CITY, STATE, and ZIP_CODE make up the rest of the address.';

COMMENT ON COLUMN CUSTOMER.CITY IS 'City name for address of customer.  Storing city names in all caps is recommended, but not required.';

COMMENT ON COLUMN CUSTOMER.STATE IS 'Two letter abbreviation for state name for address of customer.  Must be entered in all caps.';

COMMENT ON COLUMN CUSTOMER.ZIP_CODE IS 'Zip code of customer.  Supports both 5 and 9 digit zip codes.  Dashes should be omitted from 9 digit zips.';

COMMENT ON COLUMN CUSTOMER.AREA_CODE IS 'Area code of phone number for customer.';

COMMENT ON COLUMN CUSTOMER.PHONE_NUMBER IS 'Phone number of customer.  This field does not supports letters and spaces for mnemonics (7 numeric digits only).';

COMMENT ON COLUMN CUSTOMER.SALESPERSON_ID IS 'Employee number of sales representative handling customer''s account.  Employee information can be found in the EMPLOYEE table.';

COMMENT ON COLUMN CUSTOMER.CREDIT_LIMIT IS 'Credit limit of customer or prospective customer in U.S. dollars.';

COMMENT ON COLUMN CUSTOMER.COMMENTS IS 'Field can be used flexibly.  Suggestions for use include lists of action items or special considerations when dealing with the particular customer.';


ALTER TABLE SALES_ORDER DROP PRIMARY KEY CASCADE;
DROP TABLE SALES_ORDER CASCADE CONSTRAINTS;

CREATE TABLE SALES_ORDER
(
  ORDER_ID     NUMBER(4)                        NOT NULL,
  ORDER_DATE   DATE                                 NULL,
  CUSTOMER_ID  NUMBER(6)                            NULL,
  SHIP_DATE    DATE                                 NULL,
  TOTAL        NUMBER(8,2)                          NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE SALES_ORDER IS 'Sales order for a customer.  Items in the order can be found in the table ITEM.';

COMMENT ON COLUMN SALES_ORDER.ORDER_ID IS 'Unique 4 digit number assigned to all orders.  Number generated by sequence ORDER_ID.';

COMMENT ON COLUMN SALES_ORDER.ORDER_DATE IS 'Date sales order logged (not necessarily when order was fulfilled.)';

COMMENT ON COLUMN SALES_ORDER.CUSTOMER_ID IS 'Customer ordering the goods.  Further information can be found in the table CUSTOMER.';

COMMENT ON COLUMN SALES_ORDER.SHIP_DATE IS 'Date order fulfilled and invoice sent (not necessarily date payment received).';

COMMENT ON COLUMN SALES_ORDER.TOTAL IS 'Total of all items totals in the order.  (i.e. the value of TOTAL for order N should contain: SELECT SUM(TOTAL) FROM ITEM WHERE ORDER_ID=N)';


CREATE UNIQUE INDEX I_CUSTOMER$CUSTOMER_ID ON CUSTOMER
(CUSTOMER_ID)
LOGGING
NOPARALLEL;


CREATE UNIQUE INDEX I_SALES_ORDER$ORDER_ID ON SALES_ORDER
(ORDER_ID)
LOGGING
NOPARALLEL;


ALTER TABLE ITEM DROP PRIMARY KEY CASCADE;
DROP TABLE ITEM CASCADE CONSTRAINTS;

CREATE TABLE ITEM
(
  ORDER_ID      NUMBER(4)                       NOT NULL,
  ITEM_ID       NUMBER(4)                       NOT NULL,
  PRODUCT_ID    NUMBER(6)                           NULL,
  ACTUAL_PRICE  NUMBER(8,2)                         NULL,
  QUANTITY      NUMBER(8)                           NULL,
  TOTAL         NUMBER(8,2)                         NULL
)
LOGGING 
NOCACHE
NOPARALLEL;

COMMENT ON TABLE ITEM IS 'Items listed in sales orders.  Product information can be found in table PRODUCT.  Sales order information can be found in table SALES_ORDER.';

COMMENT ON COLUMN ITEM.ORDER_ID IS 'Sales order in which this item appears.  Sales order information can be found in table SALES_ORDER.';

COMMENT ON COLUMN ITEM.ITEM_ID IS 'Number of item within the sales order.';

COMMENT ON COLUMN ITEM.PRODUCT_ID IS 'Number of product (described in PRODUCT) that pertains to the line item.';

COMMENT ON COLUMN ITEM.ACTUAL_PRICE IS 'Price to be paid by the customer in U.S. dollars.  The standard price is PRICE.STANDARD_PRICE, but in some instances, discounts are given to as low as PRICE.MINIMUM_PRICE.';

COMMENT ON COLUMN ITEM.QUANTITY IS 'The amount of product to be ordered in this line item.';

COMMENT ON COLUMN ITEM.TOTAL IS 'The total price (in U.S. dollars) of this line item.  TOTAL = ACTUAL_PRICE * QUANTITY.';


CREATE UNIQUE INDEX I_ITEM ON ITEM
(ORDER_ID, ITEM_ID)
LOGGING
NOPARALLEL;


ALTER TABLE JOB ADD (
  CHECK (FUNCTION IS NOT NULL));

ALTER TABLE JOB ADD (
  PRIMARY KEY (JOB_ID));


ALTER TABLE LOCATION ADD (
  PRIMARY KEY (LOCATION_ID));


ALTER TABLE PRODUCT ADD (
  PRIMARY KEY (PRODUCT_ID));


ALTER TABLE SALARY_GRADE ADD (
  CHECK ((LOWER_BOUND IS NULL AND UPPER_BOUND IS NOT NULL) OR (LOWER_BOUND IS NOT NULL AND UPPER_BOUND IS NULL) OR (LOWER_BOUND <= UPPER_BOUND)));

ALTER TABLE SALARY_GRADE ADD (
  PRIMARY KEY (GRADE_ID));


ALTER TABLE DEPARTMENT ADD (
  PRIMARY KEY (DEPARTMENT_ID));


ALTER TABLE EMPLOYEE ADD (
  CHECK (DEPARTMENT_ID IS NOT NULL));

ALTER TABLE EMPLOYEE ADD (
  PRIMARY KEY (EMPLOYEE_ID));


ALTER TABLE PRICE ADD (
  CHECK (LIST_PRICE IS NULL OR MIN_PRICE IS NULL OR MIN_PRICE <= LIST_PRICE));

ALTER TABLE PRICE ADD (
  CHECK (END_DATE IS NULL OR START_DATE <= END_DATE));

ALTER TABLE PRICE ADD (
  PRIMARY KEY (PRODUCT_ID, START_DATE));


ALTER TABLE CUSTOMER ADD (
  CHECK (SALESPERSON_ID IS NOT NULL));

ALTER TABLE CUSTOMER ADD (
  CHECK (CUSTOMER_ID > 0));

ALTER TABLE CUSTOMER ADD (
  CHECK (STATE = UPPER(STATE)));

ALTER TABLE CUSTOMER ADD (
  CHECK (LENGTH(NVL(ZIP_CODE, '99999')) IN (5, 9)));

ALTER TABLE CUSTOMER ADD (
  PRIMARY KEY (CUSTOMER_ID));


ALTER TABLE SALES_ORDER ADD (
  CHECK (CUSTOMER_ID IS NOT NULL));

ALTER TABLE SALES_ORDER ADD (
  CHECK (TOTAL >= 0));

ALTER TABLE SALES_ORDER ADD (
  PRIMARY KEY (ORDER_ID));


ALTER TABLE ITEM ADD (
  PRIMARY KEY (ORDER_ID, ITEM_ID));


ALTER TABLE DEPARTMENT ADD (
  FOREIGN KEY (LOCATION_ID) 
    REFERENCES LOCATION (LOCATION_ID));


ALTER TABLE EMPLOYEE ADD (
  FOREIGN KEY (JOB_ID) 
    REFERENCES JOB (JOB_ID));

ALTER TABLE EMPLOYEE ADD (
  FOREIGN KEY (MANAGER_ID) 
    REFERENCES EMPLOYEE (EMPLOYEE_ID));

ALTER TABLE EMPLOYEE ADD (
  FOREIGN KEY (DEPARTMENT_ID) 
    REFERENCES DEPARTMENT (DEPARTMENT_ID));


ALTER TABLE PRICE ADD (
  FOREIGN KEY (PRODUCT_ID) 
    REFERENCES PRODUCT (PRODUCT_ID));


ALTER TABLE CUSTOMER ADD (
  FOREIGN KEY (SALESPERSON_ID) 
    REFERENCES EMPLOYEE (EMPLOYEE_ID));


ALTER TABLE SALES_ORDER ADD (
  FOREIGN KEY (CUSTOMER_ID) 
    REFERENCES CUSTOMER (CUSTOMER_ID));


ALTER TABLE ITEM ADD (
  FOREIGN KEY (ORDER_ID) 
    REFERENCES SALES_ORDER (ORDER_ID));

ALTER TABLE ITEM ADD (
  FOREIGN KEY (PRODUCT_ID) 
    REFERENCES PRODUCT (PRODUCT_ID));


GRANT SELECT ON  SALES_ORDER TO PUBLIC;

GRANT SELECT ON  SALARY_GRADE TO PUBLIC;

GRANT SELECT ON  PRODUCT TO PUBLIC;

GRANT SELECT ON  PRICE TO PUBLIC;

GRANT SELECT ON  LOCATION TO PUBLIC;

GRANT SELECT ON  JOB TO PUBLIC;

GRANT SELECT ON  ITEM TO PUBLIC;

GRANT SELECT ON  EMPLOYEE TO PUBLIC;

GRANT SELECT ON  DEPARTMENT TO PUBLIC;

GRANT SELECT ON  CUSTOMER TO PUBLIC;


INSERT INTO SALARY_GRADE ( GRADE_ID, LOWER_BOUND, UPPER_BOUND ) VALUES ( 
1, 700, 1200); 
INSERT INTO SALARY_GRADE ( GRADE_ID, LOWER_BOUND, UPPER_BOUND ) VALUES ( 
2, 1201, 1400); 
INSERT INTO SALARY_GRADE ( GRADE_ID, LOWER_BOUND, UPPER_BOUND ) VALUES ( 
3, 1401, 2000); 
INSERT INTO SALARY_GRADE ( GRADE_ID, LOWER_BOUND, UPPER_BOUND ) VALUES ( 
4, 2001, 3000); 
INSERT INTO SALARY_GRADE ( GRADE_ID, LOWER_BOUND, UPPER_BOUND ) VALUES ( 
5, 3001, 9999); 
COMMIT;



INSERT INTO LOCATION ( LOCATION_ID, REGIONAL_GROUP ) VALUES ( 
122, 'NEW YORK'); 
INSERT INTO LOCATION ( LOCATION_ID, REGIONAL_GROUP ) VALUES ( 
124, 'DALLAS'); 
INSERT INTO LOCATION ( LOCATION_ID, REGIONAL_GROUP ) VALUES ( 
123, 'CHICAGO'); 
INSERT INTO LOCATION ( LOCATION_ID, REGIONAL_GROUP ) VALUES ( 
167, 'BOSTON'); 
COMMIT;





INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
10, 'ACCOUNTING', 122); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
20, 'RESEARCH', 124); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
30, 'SALES', 123); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
40, 'OPERATIONS', 167); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
12, 'RESEARCH', 122); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
13, 'SALES', 122); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
14, 'OPERATIONS', 122); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
23, 'SALES', 124); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
24, 'OPERATIONS', 124); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
34, 'OPERATIONS', 123); 
INSERT INTO DEPARTMENT ( DEPARTMENT_ID, NAME, LOCATION_ID ) VALUES ( 
43, 'SALES', 167); 
COMMIT;




INSERT INTO JOB ( JOB_ID, FUNCTION ) VALUES ( 
667, 'CLERK'); 
INSERT INTO JOB ( JOB_ID, FUNCTION ) VALUES ( 
668, 'STAFF'); 
INSERT INTO JOB ( JOB_ID, FUNCTION ) VALUES ( 
669, 'ANALYST'); 
INSERT INTO JOB ( JOB_ID, FUNCTION ) VALUES ( 
670, 'SALESPERSON'); 
INSERT INTO JOB ( JOB_ID, FUNCTION ) VALUES ( 
671, 'MANAGER'); 
INSERT INTO JOB ( JOB_ID, FUNCTION ) VALUES ( 
672, 'PRESIDENT'); 
COMMIT;



INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7839, 'KING', 'FRANCIS', 'A', 672, NULL,  TO_Date( '11/17/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 5000, NULL, 10); 


INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7505, 'DOYLE', 'JEAN', 'K', 671, 7839,  TO_Date( '04/04/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2850, NULL, 13); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7506, 'DENNIS', 'LYNN', 'S', 671, 7839,  TO_Date( '05/15/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2750, NULL, 23); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7507, 'BAKER', 'LESLIE', 'D', 671, 7839,  TO_Date( '06/10/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2200, NULL, 14); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7566, 'JONES', 'TERRY', 'M', 671, 7839,  TO_Date( '04/02/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2975, NULL, 20); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7569, 'ALBERTS', 'CHRIS', 'L', 671, 7839,  TO_Date( '04/06/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3000, NULL, 12); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7698, 'BLAKE', 'MARION', 'S', 671, 7839,  TO_Date( '05/01/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2850, NULL, 30); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7782, 'CLARK', 'CAROL', 'F', 671, 7839,  TO_Date( '06/09/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2450, NULL, 10); 



INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7499, 'ALLEN', 'KEVIN', 'J', 670, 7698,  TO_Date( '02/20/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1600, 300, 30); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7521, 'WARD', 'CYNTHIA', 'D', 670, 7698,  TO_Date( '02/22/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, 500, 30); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7555, 'PETERS', 'DANIEL', 'T', 670, 7505,  TO_Date( '03/31/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, 300, 13); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7557, 'SHAW', 'KAREN', 'P', 670, 7505,  TO_Date( '04/02/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, 1200, 13); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7560, 'DUNCAN', 'SARAH', 'S', 670, 7506,  TO_Date( '05/31/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, NULL, 23); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7564, 'LANGE', 'GREGORY', 'J', 670, 7506,  TO_Date( '06/01/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, 300, 23); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7600, 'PORTER', 'RAYMOND', 'Y', 670, 7505,  TO_Date( '04/15/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, 900, 13); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7609, 'LEWIS', 'RICHARD', 'M', 668, 7507,  TO_Date( '04/16/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1800, NULL, 24); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7654, 'MARTIN', 'KENNETH', 'J', 670, 7698,  TO_Date( '09/28/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1250, 1400, 30); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7676, 'SOMMERS', 'DENISE', 'D', 668, 7507,  TO_Date( '04/19/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1850, NULL, 34); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7788, 'SCOTT', 'DONALD', 'T', 669, 7566,  TO_Date( '12/09/1986 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3000, NULL, 20); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7789, 'WEST', 'LIVIA', 'N', 670, 7506,  TO_Date( '04/04/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1500, 1000, 23); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7799, 'FISHER', 'MATTHEW', 'G', 669, 7569,  TO_Date( '12/12/1986 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3000, NULL, 12); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7820, 'ROSS', 'PAUL', 'S', 670, 7505,  TO_Date( '06/01/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1300, 800, 43); 

INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7844, 'TURNER', 'MARY', 'A', 670, 7698,  TO_Date( '09/08/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1500, 0, 30); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7900, 'JAMES', 'FRED', 'S', 667, 7698,  TO_Date( '12/03/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 950, NULL, 30); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7902, 'FORD', 'JENNIFER', 'D', 669, 7566,  TO_Date( '12/03/1985 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3000, NULL, 20); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7916, 'ROBERTS', 'GRACE', 'M', 669, 7569,  TO_Date( '01/04/1987 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2875, NULL, 12); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7934, 'MILLER', 'BARBARA', 'M', 667, 7782,  TO_Date( '01/23/1986 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1300, NULL, 10); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7950, 'JENSEN', 'ALICE', 'B', 667, 7505,  TO_Date( '01/15/1987 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 750, NULL, 13); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7954, 'MURRAY', 'JAMES', 'T', 667, 7506,  TO_Date( '01/16/1987 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 750, NULL, 23); 



INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7876, 'ADAMS', 'DIANE', 'G', 667, 7788,  TO_Date( '01/12/1987 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1100, NULL, 20); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7369, 'SMITH', 'JOHN', 'Q', 667, 7902,  TO_Date( '12/17/1984 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 800, NULL, 20); 
INSERT INTO EMPLOYEE ( EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_INITIAL, JOB_ID, MANAGER_ID,
HIRE_DATE, SALARY, COMMISSION, DEPARTMENT_ID ) VALUES ( 
7919, 'DOUGLAS', 'MICHAEL', 'A', 667, 7799,  TO_Date( '01/04/1987 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 800, NULL, 12); 




COMMIT;





INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
100, 'JOCKSPORTS', '345 VIEWRIDGE', 'BELMONT', 'CA', '96711', 415, 5986609, 7844, 5000
, 'Very friendly people to work with -- sales rep likes to be called Mike.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
101, 'TKB SPORT SHOP', '490 BOLI RD.', 'REDWOOD CITY', 'CA', '94061', 415, 3681223
, 7521, 10000, 'Rep called 5/8 about change in order - contact shipping.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
102, 'VOLLYRITE', '9722 HAMILTON', 'BURLINGAME', 'CA', '95133', 415, 6443341, 7654
, 7000, 'Company doing heavy promotion beginning 10/89. Prepare for large orders during winter.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
103, 'JUST TENNIS', 'HILLVIEW MALL', 'BURLINGAME', 'CA', '97544', 415, 6779312, 7521
, 3000, 'Contact rep about new line of tennis rackets.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
104, 'EVERY MOUNTAIN', '574 SURRY RD.', 'CUPERTINO', 'CA', '93301', 408, 9962323, 7499
, 10000, 'Customer with high market share (23%) due to aggressive advertising.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
105, 'K + T SPORTS', '3476 EL PASEO', 'SANTA CLARA', 'CA', '91003', 408, 3769966, 7844
, 5000, 'Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
106, 'SHAPE UP', '908 SEQUOIA', 'PALO ALTO', 'CA', '94301', 415, 3649777, 7521, 6000
, 'Support intensive. Orders small amounts (< 800) of merchandise at a time.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
107, 'WOMENS SPORTS', 'VALCO VILLAGE', 'SUNNYVALE', 'CA', '93301', 408, 9674398, 7499
, 10000, 'First sporting goods store geared exclusively towards women. Unusual promotional style and very willing to take chances towards new products!'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
108, 'NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER', '98 LONE PINE WAY', 'HIBBING'
, 'MN', '55649', 612, 5669123, 7844, 8000, NULL); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
201, 'STADIUM SPORTS', '47 IRVING PL.', 'NEW YORK', 'NY', '10003', 212, 5555335, 7557
, 10000, 'Large general-purpose sports store with an affluent customer base.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
202, 'HOOPS', '2345 ADAMS AVE.', 'LEICESTER', 'MA', '01524', 508, 5557542, 7820, 5000
, 'Specializes in basketball equipment.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
203, 'REBOUND SPORTS', '2 E. 14TH ST.', 'NEW YORK', 'NY', '10009', 212, 5555989, 7557
, 10000, 'Follow up on the promotion proposal.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
204, 'THE POWER FORWARD', '1 KNOTS LANDING', 'DALLAS', 'TX', '75248', 214, 5550505
, 7560, 12000, 'Large floorspace.  Prefers maintaining large amounts of inventory on hand.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
205, 'POINT GUARD', '20 THURSTON ST.', 'YONKERS', 'NY', '10956', 914, 5554766, 7557
, 3000, 'Tremendous potential for an exclusive agreement.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
206, 'THE COLISEUM', '5678 WILBUR PL.', 'SCARSDALE', 'NY', '10583', 914, 5550217, 7557
, 6000, 'Contact rep. about new product lines.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
207, 'FAST BREAK', '1000 HERBERT LN.', 'CONCORD', 'MA', '01742', 508, 5551298, 7820
, 7000, 'Customer requires written price quotes before making purchase requisitions.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
208, 'AL AND BOB''S SPORTS', '260 YORKTOWN CT.', 'AUSTIN', 'TX', '78731', 512, 5557631
, 7560, 4000, 'Very personal purchasing agents -- Sharon and Scott.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
211, 'AT BAT', '234 BEACHEM ST.', 'BROOKLINE', 'MA', '02146', 617, 5557385, 7820, 8000
, 'Have an open purchase order for $3000.  Ship immediately on request.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
212, 'ALL SPORT', '1000 38TH ST.', 'BROOKLYN', 'NY', '11210', 718, 5551739, 7600, 6000
, 'Pursue a contract -- possible candidate for volume purchasing agreements.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
213, 'GOOD SPORT', '400 46TH ST.', 'SUNNYSIDE', 'NY', '11104', 718, 5553771, 7600
, 5000, 'May be moving to a larger location.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
214, 'AL''S PRO SHOP', '45 SPRUCE ST.', 'SPRING', 'TX', '77388', 713, 5555172, 7564
, 8000, 'Target market is serious athletes.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
215, 'BOB''S FAMILY SPORTS', '400 E. 23RD', 'HOUSTON', 'TX', '77026', 713, 5558015
, 7654, 8000, 'Target market is casual and weekend athletes.  Offers a large selection.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
216, 'THE ALL AMERICAN', '547 PRENTICE RD.', 'CHELSEA', 'MA', '02150', 617, 5553047
, 7820, 5000, 'Customer prefers to be called between 10 and 12.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
217, 'HIT, THROW, AND RUN', '333 WOOD COURT', 'GRAPEVINE', 'TX', '76051', 817, 5552352
, 7564, 6000, 'General purpose sports store.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
218, 'THE OUTFIELD', '346 GARDEN BLVD.', 'FLUSHING', 'NY', '11355', 718, 5552131, 7820
, 4000, 'Store does not open until 11am and does not have an answering service.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
221, 'WHEELS AND DEALS', '2 MEMORIAL DRIVE', 'HOUSTON', 'TX', '77007', 713, 5554139
, 7789, 10000, 'Discount bicycle and sporting good store.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
222, 'JUST BIKES', '4000 PARKRIDGE BLVD.', 'DALLAS', 'TX', '75205', 214, 5558735, 7789
, 4000, 'Exclusive bicycle dealer.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
223, 'VELO SPORTS', '23 WHITE ST.', 'MALDEN', 'MA', '02148', 617, 5554983, 7820, 5000
, 'Clerk answers all phone lines.  Ask for Mike.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
224, 'JOE''S BIKE SHOP', '4500 FOX COURT', 'GRAND PRARIE', 'TX', '75051', 214, 5559834
, 7789, 6000, 'Call Joe to make sure last shipment was complete.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
225, 'BOB''S SWIM, CYCLE, AND RUN', '300 HORSECREEK CIRCLE', 'IRVING', 'TX', '75039'
, 214, 5558388, 7789, 7000, 'Store catering to triathletes.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
226, 'CENTURY SHOP', '8 DAGMAR DR.', 'HUNTINGTON', 'NY', '11743', 516, 5553006, 7555
, 4000, 'Customer in the midst of a cost-cutting program.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
227, 'THE TOUR', '2500 GARDNER RD.', 'SOMERVILLE', 'MA', '02144', 617, 5556673, 7820
, 5000, 'Customer referred to us by The All American.'); 
INSERT INTO CUSTOMER ( CUSTOMER_ID, NAME, ADDRESS, CITY, STATE, ZIP_CODE, AREA_CODE, PHONE_NUMBER,
SALESPERSON_ID, CREDIT_LIMIT, COMMENTS ) VALUES ( 
228, 'FITNESS FIRST', '5000 85TH ST.', 'JACKSON HEIGHTS', 'NY', '11372', 718, 5558710
, 7555, 4000, 'Recently acquired another sporting goods store.  Expect higher volume in the future.'); 
COMMIT;



INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
610,  TO_Date( '01/07/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 101,  TO_Date( '01/08/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 101.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
611,  TO_Date( '01/11/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 102,  TO_Date( '01/11/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 45); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
612,  TO_Date( '01/15/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 104,  TO_Date( '01/20/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 5860); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
601,  TO_Date( '05/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 106,  TO_Date( '05/30/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 60.8); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
602,  TO_Date( '06/05/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 102,  TO_Date( '06/20/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 56); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
600,  TO_Date( '05/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 103,  TO_Date( '05/29/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 42); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
604,  TO_Date( '06/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 106,  TO_Date( '06/30/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 642); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
605,  TO_Date( '07/14/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 106,  TO_Date( '07/30/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 8374); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
606,  TO_Date( '07/14/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 100,  TO_Date( '07/30/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
609,  TO_Date( '08/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 100,  TO_Date( '08/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 102.5); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
607,  TO_Date( '07/18/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 104,  TO_Date( '07/18/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 5.6); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
608,  TO_Date( '07/25/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 104,  TO_Date( '07/25/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 35.2); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
603,  TO_Date( '06/05/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 102,  TO_Date( '06/05/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 224); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
620,  TO_Date( '03/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 100,  TO_Date( '03/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 4450); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
613,  TO_Date( '02/01/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 108,  TO_Date( '02/01/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 6400); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
614,  TO_Date( '02/01/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 102,  TO_Date( '02/05/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 23940); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
616,  TO_Date( '02/03/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 103,  TO_Date( '02/10/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 764); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
619,  TO_Date( '02/22/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 104,  TO_Date( '03/04/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1260); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
617,  TO_Date( '02/05/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 105,  TO_Date( '03/03/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 46370); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
615,  TO_Date( '02/01/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 107,  TO_Date( '02/06/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 710); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
618,  TO_Date( '02/15/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 102,  TO_Date( '03/06/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3083); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
621,  TO_Date( '03/15/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 100,  TO_Date( '04/01/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 730); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
509,  TO_Date( '06/04/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 226,  TO_Date( '06/10/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1174); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
523,  TO_Date( '02/13/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 226,  TO_Date( '02/13/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1165); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
549,  TO_Date( '12/27/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 226,  TO_Date( '01/14/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1620); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
507,  TO_Date( '05/26/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 228,  TO_Date( '05/27/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 886); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
516,  TO_Date( '09/30/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 228,  TO_Date( '10/03/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1815); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
553,  TO_Date( '02/02/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 228,  TO_Date( '02/13/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 4400); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
526,  TO_Date( '03/04/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 221,  TO_Date( '03/07/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 7700); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
543,  TO_Date( '09/04/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 221,  TO_Date( '09/07/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 8400); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
555,  TO_Date( '03/04/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 221,  TO_Date( '03/07/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 8540); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
559,  TO_Date( '11/16/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 222,  TO_Date( '04/23/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 387.2); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
528,  TO_Date( '03/24/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 224,  TO_Date( '03/24/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3770); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
531,  TO_Date( '03/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 224,  TO_Date( '04/02/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1400); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
558,  TO_Date( '03/31/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 224,  TO_Date( '04/02/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1700); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
525,  TO_Date( '02/28/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 225,  TO_Date( '03/03/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 377); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
552,  TO_Date( '02/02/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 223,  TO_Date( '02/07/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 555.8); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
556,  TO_Date( '03/10/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 223,  TO_Date( '03/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 85); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
560,  TO_Date( '04/25/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 223,  TO_Date( '04/25/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 72); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
565,  TO_Date( '06/01/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 227,  TO_Date( '06/03/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 4900); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
574,  TO_Date( '10/10/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '10/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1685); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
576,  TO_Date( '10/13/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '10/18/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2058.9); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
503,  TO_Date( '03/25/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '04/06/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1876); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
518,  TO_Date( '10/20/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '11/05/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2932.5); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
517,  TO_Date( '10/23/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '11/07/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 784); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
544,  TO_Date( '09/11/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '09/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2358); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
524,  TO_Date( '02/22/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '03/04/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1979); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
502,  TO_Date( '02/10/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '02/23/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 500); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
539,  TO_Date( '06/26/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '07/03/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1300); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
511,  TO_Date( '08/17/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '08/21/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 647); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
512,  TO_Date( '08/28/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 203,  TO_Date( '09/13/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 428); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
562,  TO_Date( '05/04/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 203,  TO_Date( '05/19/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2044.5); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
529,  TO_Date( '04/02/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 203,  TO_Date( '04/05/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1264.7); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
563,  TO_Date( '05/25/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '05/26/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 889); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
568,  TO_Date( '07/13/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '07/21/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1217.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
504,  TO_Date( '04/11/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '04/12/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1434.7); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
538,  TO_Date( '06/23/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '06/26/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 741); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
535,  TO_Date( '05/28/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '06/09/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 810); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
578,  TO_Date( '11/19/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '12/04/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2275.6); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
534,  TO_Date( '05/11/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 206,  TO_Date( '05/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 420); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
536,  TO_Date( '05/21/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 206,  TO_Date( '06/06/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2135.6); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
572,  TO_Date( '08/19/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 206,  TO_Date( '08/24/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1200.5); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
514,  TO_Date( '09/05/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 207,  TO_Date( '09/16/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1140); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
521,  TO_Date( '11/20/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 207,  TO_Date( '11/23/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 896.9); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
551,  TO_Date( '01/22/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '02/06/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1142); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
513,  TO_Date( '09/06/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '09/14/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1497); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
508,  TO_Date( '05/26/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '06/08/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1080); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
515,  TO_Date( '09/19/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '09/26/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1428.5); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
542,  TO_Date( '08/11/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '08/23/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2409); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
573,  TO_Date( '10/10/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '10/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1627); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
566,  TO_Date( '06/09/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '06/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3389.2); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
520,  TO_Date( '11/16/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '11/19/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 341.6); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
519,  TO_Date( '10/20/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '11/05/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 955); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
575,  TO_Date( '10/04/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 201,  TO_Date( '10/17/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 684); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
547,  TO_Date( '10/16/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '10/27/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 984.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
540,  TO_Date( '07/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '07/17/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 861.2); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
567,  TO_Date( '07/05/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '07/07/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 200); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
570,  TO_Date( '07/17/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '07/24/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 663.6); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
571,  TO_Date( '08/02/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 202,  TO_Date( '08/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1095.6); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
541,  TO_Date( '08/08/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 203,  TO_Date( '08/18/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 400); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
532,  TO_Date( '04/08/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 203,  TO_Date( '04/21/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1295.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
527,  TO_Date( '02/27/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '03/14/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3054.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
501,  TO_Date( '01/06/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '01/11/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 216); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
564,  TO_Date( '05/25/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '05/26/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 898.8); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
537,  TO_Date( '06/14/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '06/26/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 672.9); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
522,  TO_Date( '01/07/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '01/10/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2578.8); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
554,  TO_Date( '02/18/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 204,  TO_Date( '02/22/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 282.8); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
569,  TO_Date( '07/16/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 205,  TO_Date( '07/23/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2073); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
550,  TO_Date( '01/27/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 205,  TO_Date( '02/07/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2356); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
548,  TO_Date( '11/26/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 205,  TO_Date( '12/12/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 666.9); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
505,  TO_Date( '04/07/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 206,  TO_Date( '04/22/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 650); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
577,  TO_Date( '10/06/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 206,  TO_Date( '10/20/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1265.75); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
533,  TO_Date( '04/28/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 206,  TO_Date( '05/02/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1122.1); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
561,  TO_Date( '04/20/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 207,  TO_Date( '05/07/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2558.3); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
506,  TO_Date( '04/27/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '05/10/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2600.4); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
530,  TO_Date( '04/03/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '04/07/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3026.5); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
545,  TO_Date( '10/06/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '10/13/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 475); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
557,  TO_Date( '03/08/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '03/12/1991 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 2461.8); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
546,  TO_Date( '10/17/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '10/23/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 3663); 
INSERT INTO SALES_ORDER ( ORDER_ID, ORDER_DATE, CUSTOMER_ID, SHIP_DATE,
TOTAL ) VALUES ( 
510,  TO_Date( '07/18/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS'), 208,  TO_Date( '07/21/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, 1336.6); 
COMMIT;



INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
100860, 'ACE TENNIS RACKET I'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
100861, 'ACE TENNIS RACKET II'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
100870, 'ACE TENNIS BALLS-3 PACK'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
100871, 'ACE TENNIS BALLS-6 PACK'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
100890, 'ACE TENNIS NET'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
101860, 'SP TENNIS RACKET'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
101863, 'SP JUNIOR RACKET'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
102130, 'RH: "GUIDE TO TENNIS"'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
200376, 'SB ENERGY BAR-6 PACK'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
200380, 'SB VITA SNACK-6 PACK'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
103120, 'WIFF SOFTBALL BAT I'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
103121, 'WIFF SOFTBALL BAT II'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
103130, 'WIFF SOFTBALL, SMALL'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
103131, 'WIFF SOFTBALL, LARGE'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
103140, 'WIFF SOFTBALL MITT (LH)'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
103141, 'WIFF SOFTBALL MITT (RH)'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
102132, 'RH: "GUIDE TO SOFTBALL"'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
104350, 'DUNK BASKETBALL INDOOR'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
104351, 'DUNK BASKETBALL OUTDOOR'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
104352, 'DUNK BASKETBALL PROFESSIONAL'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
104360, 'DUNK HOOP'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
104361, 'DUNK HOOP W/FIBERGLASS BOARD'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
104362, 'DUNK NETS - RAINBOW'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
102134, 'RH: "GUIDE TO BASKETBALL"'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
105123, 'YELLOW JERSEY BICYCLE HELMET'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
105124, 'YELLOW JERSEY BICYCLE GLOVES'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
105125, 'YELLOW JERSEY WATER BOTTLE'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
105126, 'YELLOW JERSEY BOTTLE CAGE'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
105127, 'YELLOW JERSEY FRAME PUMP'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
105128, 'YELLOW JERSEY SADDLE PACK'); 
INSERT INTO PRODUCT ( PRODUCT_ID, DESCRIPTION ) VALUES ( 
102136, 'RH: "GUIDE TO CYCLING"'); 
COMMIT;



INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
600, 1, 100861, 42, 1, 42); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
610, 3, 100890, 58, 1, 58); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
611, 1, 100861, 45, 1, 45); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
612, 1, 100860, 30, 100, 3000); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
601, 1, 200376, 2.4, 12, 28.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
601, 2, 100860, 32, 1, 32); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
602, 1, 100870, 2.8, 20, 56); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
604, 1, 100890, 58, 3, 174); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
604, 2, 100861, 42, 2, 84); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
604, 3, 100860, 32, 12, 384); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
603, 1, 100860, 32, 7, 224); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
610, 1, 100860, 35, 1, 35); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
610, 2, 100870, 2.8, 3, 8.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
613, 4, 200376, 2.2, 200, 440); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
614, 1, 100860, 35, 444, 15540); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
614, 2, 100870, 2.8, 1000, 2800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
612, 2, 100861, 40.5, 20, 810); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
612, 3, 101863, 10, 150, 1500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
620, 1, 100860, 35, 10, 350); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
620, 2, 200376, 2.4, 1000, 2400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
620, 3, 102130, 3.4, 500, 1700); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
613, 1, 100871, 5.6, 100, 560); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
613, 2, 101860, 24, 200, 4800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
613, 3, 200380, 4, 150, 600); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
619, 3, 102130, 3.4, 100, 340); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 1, 100860, 35, 50, 1750); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 2, 100861, 45, 100, 4500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
614, 3, 100871, 5.6, 1000, 5600); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
616, 1, 100861, 45, 10, 450); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
616, 2, 100870, 2.8, 50, 140); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
616, 3, 100890, 58, 2, 116); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
616, 4, 102130, 3.4, 10, 34); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
616, 5, 200376, 2.4, 10, 24); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
619, 1, 200380, 4, 100, 400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
619, 2, 200376, 2.4, 100, 240); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
615, 1, 100861, 45, 4, 180); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
607, 1, 100871, 5.6, 1, 5.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
615, 2, 100870, 2.8, 100, 280); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 3, 100870, 2.8, 500, 1400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 4, 100871, 5.6, 500, 2800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 5, 100890, 58, 500, 29000); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 6, 101860, 24, 100, 2400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 7, 101863, 12.5, 200, 2500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 8, 102130, 3.4, 100, 340); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 9, 200376, 2.4, 200, 480); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
617, 10, 200380, 4, 300, 1200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
609, 2, 100870, 2.5, 5, 12.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
609, 3, 100890, 50, 1, 50); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
618, 1, 100860, 35, 23, 805); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
618, 2, 100861, 45, 50, 2250); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
618, 3, 100870, 2.8, 10, 28); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
621, 1, 100861, 45, 10, 450); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
621, 2, 100870, 2.8, 100, 280); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
615, 3, 100871, 5, 50, 250); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
608, 1, 101860, 24, 1, 24); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
608, 2, 100871, 5.6, 2, 11.2); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
609, 1, 100861, 40, 1, 40); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
606, 1, 102130, 3.4, 1, 3.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
605, 1, 100861, 45, 100, 4500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
605, 2, 100870, 2.8, 500, 1400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
605, 3, 100890, 58, 5, 290); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
605, 4, 101860, 24, 50, 1200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
605, 5, 101863, 9.5, 100, 950); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
605, 6, 102130, 3.4, 10, 34); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
612, 4, 100871, 5.5, 100, 550); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
619, 4, 100871, 5.6, 50, 280); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
509, 1, 105123, 35, 30, 1050); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
509, 2, 105124, 9, 10, 90); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
509, 3, 102136, 3.4, 10, 34); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
523, 1, 102136, 3.4, 10, 34); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
523, 2, 105123, 37.7, 30, 1131); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
549, 1, 105123, 38, 5, 190); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
549, 2, 105127, 6, 30, 180); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
549, 3, 105125, 3, 200, 600); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
549, 4, 105124, 13, 50, 650); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
507, 1, 105123, 35.3, 20, 706); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
507, 2, 105124, 9, 20, 180); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
516, 1, 105124, 9, 60, 540); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
516, 2, 102136, 3.2, 250, 800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
516, 3, 105125, 1.9, 250, 475); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
553, 1, 105127, 6, 500, 3000); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
553, 2, 200376, 1.75, 800, 1400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
526, 1, 105123, 32, 100, 3200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
526, 2, 105124, 9, 500, 4500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
543, 1, 105123, 34, 100, 3400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
543, 2, 105124, 10, 500, 5000); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
555, 1, 105123, 34, 100, 3400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
555, 2, 105124, 10, 500, 5000); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
555, 3, 102136, 2.8, 50, 140); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
559, 1, 105123, 40, 5, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
559, 2, 105124, 15, 5, 75); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
559, 3, 105127, 6, 5, 30); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
559, 4, 102136, 3.4, 3, 10.2); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
559, 5, 200376, 2.4, 30, 72); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
528, 1, 105123, 37.7, 100, 3770); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
531, 1, 105124, 11, 100, 1100); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
531, 2, 102136, 3, 100, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
558, 1, 105124, 14, 100, 1400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
558, 2, 102136, 3, 100, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
525, 1, 105123, 37.7, 10, 377); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
552, 1, 105123, 40, 10, 400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
552, 2, 105124, 15, 10, 150); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
552, 3, 102136, 3.4, 1, 3.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
552, 4, 200376, 2.4, 1, 2.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
556, 1, 102136, 3.4, 25, 85); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
560, 1, 200376, 2.4, 30, 72); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
565, 1, 105123, 37, 100, 3700); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
565, 2, 105124, 12, 100, 1200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
574, 1, 104350, 41.8, 25, 1045); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
574, 2, 200380, 3.2, 200, 640); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
576, 1, 104350, 44, 10, 440); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
576, 2, 104351, 26, 10, 260); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
576, 3, 104362, 4.25, 170, 722.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
576, 4, 200376, 2.16, 90, 194.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
576, 5, 200380, 3.4, 130, 442); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
503, 1, 104350, 38, 30, 1140); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
503, 2, 104351, 23.6, 10, 236); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
503, 3, 104352, 50, 10, 500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
518, 1, 104350, 38, 25, 950); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
518, 2, 104351, 23.6, 20, 472); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
518, 3, 104360, 36, 20, 720); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
518, 4, 104362, 4.25, 170, 722.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
518, 5, 102134, 3.4, 20, 68); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
517, 1, 104352, 50, 15, 750); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
517, 2, 102134, 3.4, 10, 34); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
544, 1, 104350, 44, 15, 660); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
544, 2, 104351, 26, 15, 390); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
544, 3, 104352, 58.3, 10, 583); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
544, 4, 104361, 50, 10, 500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
544, 5, 104362, 4.5, 50, 225); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
524, 1, 104350, 42, 10, 420); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
524, 2, 104351, 23.56, 35, 824.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
524, 3, 104362, 4.25, 150, 637.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
524, 4, 102134, 3.23, 30, 96.9); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
502, 1, 104352, 50, 10, 500); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
539, 1, 104351, 26, 20, 520); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
539, 2, 104360, 39, 20, 780); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
511, 1, 104351, 23.6, 15, 354); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
511, 2, 104362, 4.5, 50, 225); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
511, 3, 102134, 3.4, 20, 68); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
512, 1, 104360, 36, 10, 360); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
512, 2, 102134, 3.4, 20, 68); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
562, 1, 104351, 24.7, 25, 617.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
562, 2, 104352, 58.3, 15, 874.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
562, 3, 104362, 4.25, 130, 552.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
529, 1, 104350, 39.89, 30, 1196.7); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
529, 2, 102134, 3.4, 20, 68); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
563, 1, 104352, 58.3, 10, 583); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
563, 2, 200376, 2.04, 150, 306); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
568, 1, 104351, 24.7, 30, 741); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
568, 2, 200376, 2.04, 110, 224.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
568, 3, 200380, 3.6, 70, 252); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
504, 1, 104350, 40, 10, 400); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
504, 2, 104351, 22.42, 35, 784.7); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
504, 3, 104352, 50, 5, 250); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
538, 1, 104351, 24.7, 30, 741); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
535, 1, 104352, 54, 15, 810); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
578, 1, 104350, 41.8, 40, 1672); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
578, 2, 200376, 2.04, 190, 387.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
578, 3, 200380, 3.6, 60, 216); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
534, 1, 104350, 42, 10, 420); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
536, 1, 104350, 39.89, 40, 1595.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
536, 2, 104352, 54, 10, 540); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
572, 1, 104351, 24.7, 25, 617.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
572, 2, 104352, 58.3, 10, 583); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
514, 1, 104350, 38, 30, 1140); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
521, 1, 104350, 40, 20, 800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
521, 2, 102134, 3.23, 30, 96.9); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
551, 1, 104350, 44, 10, 440); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
551, 2, 104361, 50, 5, 250); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
551, 3, 102134, 3.4, 20, 68); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
551, 4, 200376, 1.92, 200, 384); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
513, 1, 104350, 40, 15, 600); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
513, 2, 104351, 23.6, 20, 472); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
513, 3, 104362, 4.25, 100, 425); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
508, 1, 104360, 36, 20, 720); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
508, 2, 104362, 4.5, 80, 360); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
515, 1, 104350, 40, 20, 800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
515, 2, 104351, 22.42, 25, 560.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
515, 3, 102134, 3.4, 20, 68); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
542, 1, 104350, 41.8, 25, 1045); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
542, 2, 104360, 39, 20, 780); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
542, 3, 104361, 50, 11, 550); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
542, 4, 102134, 3.4, 10, 34); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
573, 1, 103120, 22.5, 50, 1125); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
573, 2, 103131, 4.04, 50, 202); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
573, 3, 103141, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
566, 1, 103120, 23.75, 40, 950); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
566, 2, 103121, 27, 50, 1350); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
566, 3, 103130, 3.77, 60, 226.2); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
566, 4, 103131, 3.9, 170, 663); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
566, 5, 103141, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
520, 1, 103130, 4, 10, 40); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
520, 2, 103131, 3.77, 80, 301.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
519, 1, 103130, 3.5, 110, 385); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
519, 2, 103140, 19, 30, 570); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
575, 1, 103140, 19, 30, 570); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
575, 2, 200380, 3.8, 30, 114); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
547, 1, 103130, 3.77, 80, 301.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
547, 2, 103131, 4.04, 70, 282.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
547, 3, 103140, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
547, 4, 103141, 20, 5, 100); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
540, 1, 103130, 3.98, 40, 159.2); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
540, 2, 103131, 3.9, 180, 702); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
567, 1, 103140, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
570, 1, 103131, 4.04, 90, 363.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
570, 2, 103140, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
571, 1, 103131, 4.04, 70, 282.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
571, 2, 103140, 19, 25, 475); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
571, 3, 102132, 3.4, 15, 51); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
571, 4, 200376, 2.16, 80, 172.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
571, 5, 200380, 3.8, 30, 114); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
541, 1, 103140, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
541, 2, 103141, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
532, 1, 103120, 21.59, 60, 1295.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
527, 1, 103120, 21.59, 60, 1295.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
527, 2, 103121, 27.35, 40, 1094); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
527, 3, 103140, 19, 35, 665); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
501, 1, 103130, 3.6, 60, 216); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
564, 1, 103130, 3.77, 80, 301.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
564, 2, 103131, 3.9, 120, 468); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
564, 3, 102132, 3.23, 40, 129.2); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
537, 1, 103130, 3.6, 160, 576); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
537, 2, 102132, 3.23, 30, 96.9); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
522, 1, 103120, 21.59, 80, 1727.2); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
522, 2, 103121, 28.8, 10, 288); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
522, 3, 103131, 4.04, 90, 363.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
522, 4, 103141, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
554, 1, 103131, 4.04, 70, 282.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
569, 1, 103120, 22.5, 50, 1125); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
569, 2, 103130, 3.6, 180, 648); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
569, 3, 103141, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
550, 1, 103120, 22.5, 60, 1350); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
550, 2, 103140, 19, 45, 855); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
550, 3, 103141, 20, 5, 100); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
550, 4, 102132, 3.4, 15, 51); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
548, 1, 103140, 19, 30, 570); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
548, 2, 102132, 3.23, 30, 96.9); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
505, 1, 103130, 3.5, 100, 350); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
505, 2, 103140, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
577, 1, 103121, 30, 20, 600); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
577, 2, 103131, 3.9, 150, 585); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
577, 3, 102132, 3.23, 25, 80.75); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
533, 1, 103121, 27.35, 30, 820.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
533, 2, 103130, 3.77, 80, 301.6); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
561, 1, 103120, 22.5, 80, 1800); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
561, 2, 103130, 3.77, 70, 263.9); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
561, 3, 103141, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
561, 4, 200376, 2.16, 90, 194.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
506, 1, 103120, 20.88, 80, 1670.4); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
506, 2, 103130, 3.5, 180, 630); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
506, 3, 103141, 20, 15, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
530, 1, 103121, 25.91, 50, 1295.5); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
530, 2, 103130, 3.6, 200, 720); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
530, 3, 103140, 19, 40, 760); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
530, 4, 103141, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
530, 5, 102132, 3.4, 15, 51); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
545, 1, 103140, 19, 25, 475); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
557, 1, 103120, 23.75, 40, 950); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
557, 2, 103121, 30, 10, 300); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
557, 3, 103140, 19, 35, 665); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
557, 4, 200376, 2.16, 80, 172.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
557, 5, 200380, 3.4, 110, 374); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
546, 1, 103120, 22.5, 50, 1125); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
546, 2, 103121, 30, 20, 600); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
546, 3, 103130, 3.6, 120, 432); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
546, 4, 103131, 3.9, 140, 546); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
546, 5, 103140, 19, 40, 760); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
546, 6, 103141, 20, 10, 200); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
510, 1, 103120, 20.88, 60, 1252.8); 
INSERT INTO ITEM ( ORDER_ID, ITEM_ID, PRODUCT_ID, ACTUAL_PRICE, QUANTITY,
TOTAL ) VALUES ( 
510, 2, 103131, 4.19, 20, 83.8); 
COMMIT;



INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100871, 4.8, 3.2,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100890, 58, 46.4,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100890, 54, 40.5,  TO_Date( '06/01/1988 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1988 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100860, 35, 28,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100860, 32, 25.6,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100860, 30, 24,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100861, 45, 36,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100861, 42, 33.6,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100861, 39, 31.2,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100870, 2.8, 2.4,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100870, 2.4, 1.9,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
100871, 5.6, 4.8,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
101860, 24, 18,  TO_Date( '02/15/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
101863, 12.5, 9.4,  TO_Date( '02/15/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
102130, 3.4, 2.8,  TO_Date( '08/18/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
200376, 2.4, 1.75,  TO_Date( '11/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
200380, 4, 3.2,  TO_Date( '11/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103120, 23.2, 18.6,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103120, 24, 19.2,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103120, 25, 20,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103121, 27.8, 22.3,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103121, 28.8, 23,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103121, 30, 24,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103130, 4, 3.5,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103130, 4.2, 3.6,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103131, 4.2, 3.6,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103131, 4.5, 3.9,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103140, 20, 15,  TO_Date( '02/15/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
103141, 20, 15,  TO_Date( '02/15/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
102132, 3.4, 2.8,  TO_Date( '08/18/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104350, 40, 32,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104350, 42, 33.6,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104350, 44, 35.3,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104351, 23.6, 18.9,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104351, 24.8, 19.8,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104351, 26, 20.8,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104352, 50, 35,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104352, 54, 37.8,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104352, 58.3, 40.8,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104360, 36, 29.5,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104360, 39, 32,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104361, 47, 33,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104361, 50, 35,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
104362, 5, 4,  TO_Date( '02/15/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
102134, 3.4, 2.8,  TO_Date( '08/18/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105123, 36.3, 29,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105123, 37.7, 32,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105123, 40, 34,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105124, 10, 7.6,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105124, 12, 9,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '05/31/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105124, 15, 10,  TO_Date( '06/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105125, 2, 1.7,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105125, 3, 2.6,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105126, 5, 4.3,  TO_Date( '01/01/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
,  TO_Date( '12/31/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105126, 6, 5,  TO_Date( '01/01/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105127, 6, 5,  TO_Date( '11/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
105128, 10, 8,  TO_Date( '11/15/1990 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
INSERT INTO PRICE ( PRODUCT_ID, LIST_PRICE, MIN_PRICE, START_DATE,
END_DATE ) VALUES ( 
102136, 3.4, 2.8,  TO_Date( '08/18/1989 12:00:00', 'MM/DD/YYYY HH24:MI:SS')
, NULL); 
COMMIT;




CREATE OR REPLACE VIEW SALES (salesperson_id,
                              customer_id,
                              CUSTOMER,
                              product_id,
                              PRODUCT,
                              amount
                             )
AS
   SELECT   salesperson_id, SALES_ORDER.customer_id, CUSTOMER.NAME CUSTOMER,
            PRODUCT.product_id, description PRODUCT, SUM (ITEM.total) amount
       FROM SALES_ORDER, ITEM, CUSTOMER, PRODUCT
      WHERE SALES_ORDER.order_id = ITEM.order_id
        AND SALES_ORDER.customer_id = CUSTOMER.customer_id
        AND ITEM.product_id = PRODUCT.product_id
   GROUP BY salesperson_id,
            SALES_ORDER.customer_id,
            CUSTOMER.NAME,
            PRODUCT.product_id,
            description;
