segilbert/0.ReadMe.md

## 0.ReadMe.md

      
                Raw

        
              0.ReadMe.md
            
          
    MS Northwind for Oracle
Summary
Ever wanted or had the need to create a version of the MS Northwind SQL Server Database on Oracle?  If you are working with EntLib code base and want to run the unit tests then you know what I'm taking about.  The scrips below will create Northwind in an Oracle database.
Scripts: ( order required to be run )

northwind.oracle.schema.sql
northwind.oracle.tables.views..sql
northwind.oracle.packages.sql
northwind.oracle.sps.sql
northwind.oracle.seed.sql
northwind.oracle.constraints.sql

If you want to be able to export and import once created instead of running scripts use.

export.oracle.northwind.cmd
import.oracle.northwind.cmd


## 1.northwind.oracle.schema.sql
-- 1. Run to drop schema
-- drop user TESTUSER cascade;

-- 2. Run to create user and schema
CREATE USER TESTUSER IDENTIFIED BY testuser
  DEFAULT TABLESPACE users
  TEMPORARY TABLESPACE temp
  QUOTA UNLIMITED ON users

-- 3. Run to grant permissions
GRANT "CONNECT" TO TESTUSER
/
GRANT DBA TO TESTUSER
/
GRANT "RESOURCE" TO TESTUSER
/
ALTER USER TESTUSER DEFAULT ROLE "CONNECT",
                                  DBA,
                                  "RESOURCE"
/

## 2.northwind.oracle.tables.views.sql
/* BEGIN Tables

DataType mappings
http://msdn.microsoft.com/en-us/library/ms151817.aspx
http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm
http://weblogs.sqlteam.com/jamesw/archive/2010/08/04/datatypes-translation-between-oracle-and-sql-server-part-2-number.aspx
http://www.techonthenet.com/oracle/datatypes.php

*/

CREATE TABLE Employees (
	EmployeeID number(10) NOT NULL ,
	LastName varchar2 (20) NOT NULL ,
	FirstName varchar2 (10) NOT NULL ,
	Title varchar2 (30) NULL ,
	TitleOfCourtesy varchar2 (25) NULL ,
	BirthDate date NULL,
	HireDate date NULL ,
	Address varchar2 (60) NULL ,
	City varchar2 (30) NULL ,
	Region varchar2 (15) NULL ,
	PostalCode varchar2 (10) NULL ,
	Country varchar2 (15) NULL ,
	HomePhone varchar2 (24) NULL ,
	Extension varchar2 (4) NULL ,
	Photo blob NULL ,
	Notes blob NULL ,
	ReportsTo number NULL ,
	PhotoPath varchar2 (255) NULL,
	PRIMARY KEY(EmployeeID),
	CONSTRAINT FK_Employees_Employees FOREIGN KEY (ReportsTo)
		REFERENCES Employees(EmployeeID)
	--CONSTRAINT CK_Birthdate CHECK (BirthDate < SYSDATE)
	);

CREATE INDEX EmployeesLastName ON Employees(LastName);
CREATE INDEX EmployeesPostalCode ON Employees(PostalCode);

CREATE TABLE Categories (
	CategoryID number(10) NOT NULL ,
	CategoryName varchar2(15) NOT NULL ,
	Description varchar2(500) NULL,
	Picture blob NULL,
	PRIMARY KEY(CategoryID)
	);

CREATE INDEX CategoriesCategoryName ON Categories(CategoryName);


CREATE TABLE Customers (
	CustomerID varchar2 (5) NOT NULL ,
	CompanyName varchar2 (40) NOT NULL ,
	ContactName varchar2 (30) NULL ,
	ContactTitle varchar2 (30) NULL ,
	Address varchar2 (60) NULL ,
	City varchar2 (30) NULL ,
	Region varchar2 (15) NULL ,
	PostalCode varchar2 (10) NULL ,
	Country varchar2 (15) NULL ,
	Phone varchar2 (24) NULL ,
	Fax varchar2 (24) NULL,
	PRIMARY KEY(CustomerID)
	);


CREATE INDEX CustomersCity ON Customers(City);
CREATE INDEX CustomersCompanyName ON Customers(CompanyName);
CREATE INDEX CustomersPostalCode ON Customers(PostalCode);
CREATE INDEX CustomersRegion ON Customers(Region);

CREATE TABLE Shippers (
	ShipperID number(10) NOT NULL ,
	CompanyName varchar2 (40) NOT NULL ,
	Phone varchar2 (24) NULL,
	PRIMARY KEY(ShipperID)
	);


CREATE TABLE Suppliers (
	SupplierID number(10) NOT NULL ,
	CompanyName varchar2 (40) NOT NULL ,
	ContactName varchar2 (30) NULL ,
	ContactTitle varchar2 (30) NULL ,
	Address varchar2 (60) NULL ,
	City varchar2 (30) NULL ,
	Region varchar2 (15) NULL ,
	PostalCode varchar2 (10) NULL ,
	Country varchar2 (15) NULL ,
	Phone varchar2 (24) NULL ,
	Fax varchar2 (24) NULL ,
	HomePage varchar2(2000) NULL,
	PRIMARY KEY(SupplierID)
	);

CREATE INDEX SuppliersCompanyName ON Suppliers(CompanyName);
CREATE INDEX SuppliersPostalCode ON Suppliers(PostalCode);

CREATE TABLE Orders (
	OrderID number(10) NOT NULL ,
	CustomerID varchar2 (5) NULL ,
	EmployeeID number(10) NULL ,
	OrderDate TIMESTAMP NULL ,
	RequiredDate TIMESTAMP NULL ,
	ShippedDate TIMESTAMP NULL ,
	ShipVia number(10) NULL ,
	Freight number(19,4) NULL,
	ShipName varchar2 (40) NULL ,
	ShipAddress varchar2 (60) NULL ,
	ShipCity varchar2 (30) NULL ,
	ShipRegion varchar2 (15) NULL ,
	ShipPostalCode varchar2 (10) NULL ,
	ShipCountry varchar2 (15) NULL,
	PRIMARY KEY(OrderID),
	CONSTRAINT FK_Orders_Customers FOREIGN KEY (CustomerID)
		REFERENCES Customers(CustomerID),
	CONSTRAINT FK_Orders_Employees FOREIGN KEY (EmployeeID)
		REFERENCES Employees(EmployeeID),
	CONSTRAINT FK_Orders_Shippers FOREIGN KEY (ShipVia)
		REFERENCES Shippers(ShipperID)
	);


CREATE INDEX OrdersCustomerID ON Orders(CustomerID);
--CREATE INDEX OrdersCustomersOrders ON Orders(CustomerID);
CREATE INDEX OrdersEmployeeID ON Orders(EmployeeID);
--CREATE INDEX OrdersEmployeesOrders ON Orders(EmployeeID);
CREATE INDEX OrdersOrderDate ON Orders(OrderDate);
CREATE INDEX OrdersShippedDate ON Orders(ShippedDate);
CREATE INDEX OrdersShippersOrders ON Orders(ShipVia);
CREATE INDEX OrdersShipPostalCode ON Orders(ShipPostalCode);


CREATE TABLE Products (
	ProductID number(10) NOT NULL,
	ProductName varchar2 (40) NOT NULL,
	SupplierID number(10) NULL,
	CategoryID number(10) NULL,
	QuantityPerUnit varchar2 (20) NULL,
	UnitPrice number(19,4) DEFAULT 0 NULL,
	UnitsInStock number(5) DEFAULT 0 NULL,
	UnitsOnOrder number(5) DEFAULT 0 NULL,
	ReorderLevel number(5) DEFAULT 0 NULL,
	Discontinued number(3) DEFAULT 0 NOT NULL ,
	PRIMARY KEY(ProductID),
	CONSTRAINT FK_Products_Categories FOREIGN KEY (CategoryID)
		REFERENCES Categories(CategoryID),
	CONSTRAINT FK_Products_Suppliers FOREIGN KEY (SupplierID)
		REFERENCES Suppliers(SupplierID),
	CONSTRAINT CK_Products_UnitPrice
		CHECK (UnitPrice >= 0),
	CONSTRAINT CK_UnitsInStock
		CHECK (UnitsInStock >= 0),
	CONSTRAINT CK_UnitsOnOrder
		CHECK (UnitsOnOrder >= 0),
	CONSTRAINT CK_ReorderLevel
		CHECK (ReorderLevel >= 0)
	);

--CREATE INDEX ProductsCategoriesProducts ON Products(CategoryID);
CREATE INDEX ProductsCategoryID ON Products(CategoryID);
CREATE INDEX ProductsProductName ON Products(ProductName);
CREATE INDEX ProductsSupplierID ON Products(SupplierID);
--CREATE INDEX ProductsSuppliersProducts ON Products(SupplierID);

CREATE TABLE Order_Details (
	OrderID number(10) NOT NULL ,
	ProductID number(10) NOT NULL ,
	UnitPrice number(19,4) DEFAULT 0 NOT NULL,
	Quantity number(10) DEFAULT 1 NOT NULL,
	Discount float(23) DEFAULT 0 NOT NULL,
	CONSTRAINT PK_Order_Product PRIMARY KEY(OrderID, ProductID),
	CONSTRAINT FK_Order_Details_Orders FOREIGN KEY (OrderID)
		REFERENCES Orders(OrderID),
	CONSTRAINT FK_Order_Details_Products FOREIGN KEY (ProductID)
		REFERENCES Products(ProductID),
	CONSTRAINT "CK_UnitPrice"
		CHECK (UnitPrice >= 0),
	CONSTRAINT "CK_Quantity"
		CHECK (Quantity > 0),
	CONSTRAINT "CK_Discount"
		CHECK (Discount >= 0 and (Discount <= 1))
	);

CREATE INDEX OrderDetailsOrderID ON Order_Details(OrderID);
--CREATE INDEX OrderDetailsOrders ON Order_Details(OrderID);
CREATE INDEX OrderDetailsProductID ON Order_Details(ProductID);
--CREATE INDEX OrderDetailsProducts ON Order_Details(ProductID);

CREATE TABLE CustomerCustomerDemo(
	CustomerID varchar2(5) NOT NULL,
	CustomerTypeID varchar2(10) NOT NULL);


CREATE TABLE CustomerDemographics(
	CustomerTypeID varchar2 (10) NOT NULL ,
	 CustomerDesc varchar2(200) NULL );


CREATE TABLE Region(
	RegionID number NOT NULL ,
	RegionDescription varchar2 (50) NOT NULL);

CREATE TABLE Territories(
	TerritoryID varchar2 (20) NOT NULL ,
	TerritoryDescription varchar2 (50) NOT NULL ,
        RegionID number NOT NULL);

CREATE TABLE EmployeeTerritories(
	EmployeeID number NOT NULL,
	TerritoryID varchar2 (20) NOT NULL );

/* END Tables */


/* BEGIN Views */

CREATE VIEW  Customer_and_Suppliers_by_City  AS
	SELECT City, CompanyName, ContactName, 'Customers' TableFrom
	FROM Customers
	UNION
	SELECT City, CompanyName, ContactName, 'Suppliers'
	FROM Suppliers;
--ORDER BY City, CompanyName

CREATE VIEW Alphabetical_list_of_products AS
	SELECT Products.*, Categories.CategoryName
	FROM Categories, Products
	WHERE Categories.CategoryID = Products.CategoryID
  		AND (((Products.Discontinued)=0));

CREATE VIEW Current_Product_List AS
	SELECT ProductID, ProductName
	FROM Products
	WHERE (((Discontinued)=0));
	--ORDER BY Product_List.ProductName

CREATE VIEW Orders_Qry AS
	SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate,
		Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity,
		Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,
		Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
	FROM Customers,Orders
	where Customers.CustomerID = Orders.CustomerID;

CREATE VIEW Products_Above_Average_Price AS
	SELECT Products.ProductName, Products.UnitPrice
	FROM Products
	WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products);
	--ORDER BY Products.UnitPrice DESC

CREATE VIEW Products_by_Category AS
	SELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued
	FROM Categories, Products
	WHERE Categories.CategoryID = Products.CategoryID
	 AND Products.Discontinued <> 1;
	--ORDER BY Categories.CategoryName, Products.ProductName


CREATE or REPLACE VIEW Quarterly_Orders AS
	SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
	FROM Customers, Orders
	WHERE Customers.CustomerID = Orders.CustomerID
	  AND to_date(Orders.OrderDate, 'MM/DD/YYYY') BETWEEN to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD');

CREATE VIEW Invoices AS
	SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode,
		Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City,
		Customers.Region, Customers.PostalCode, Customers.Country,
		(FirstName||' '||LastName) AS Salesperson,
		Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName,
		Order_Details.ProductID, Products.ProductName, Order_Details.UnitPrice, Order_Details.Quantity,
		Order_Details.Discount,
		Order_Details.UnitPrice*Quantity*(1-Discount)/100 *100  AS ExtendedPrice, Orders.Freight
	FROM 	Shippers, Products, Employees, Customers, Orders, Order_Details
	where Customers.CustomerID = Orders.CustomerID
	  and Employees.EmployeeID = Orders.EmployeeID
	  and Orders.OrderID = Order_Details.OrderID
	  and Products.ProductID = Order_Details.ProductID
	  and Shippers.ShipperID = Orders.ShipVia;

CREATE VIEW Order_Details_Extended AS
	SELECT Order_Details.OrderID, Order_Details.ProductID, Products.ProductName,
		Order_Details.UnitPrice, Order_Details.Quantity, Order_Details.Discount,
		Order_Details.UnitPrice*Quantity*(1-Discount)/100 * 100 AS ExtendedPrice
	FROM Products, Order_Details
	where Products.ProductID = Order_Details.ProductID;
	--ORDER BY Order Details.OrderID

CREATE VIEW Order_Subtotals AS
	SELECT Order_Details.OrderID, Sum(Order_Details.UnitPrice*Quantity*(1-Discount)/100*100) AS Subtotal
	FROM Order_Details
	GROUP BY Order_Details.OrderID;

create or replace view Product_Sales_for_1997 AS
	SELECT Categories.CategoryName, Products.ProductName,
	Sum(Order_Details.UnitPrice*Quantity*(1-Discount)/100*100) AS ProductSales
	FROM Categories , Products, Order_Details, Orders
	where Categories.CategoryID = Products.CategoryID
	and	  Orders.OrderID = Order_Details.OrderID
	and	  Products.ProductID = Order_Details.ProductID
	and   to_date(Orders.ShippedDate, 'MM/DD/YYYY') Between to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD')
	GROUP BY Categories.CategoryName, Products.ProductName;


CREATE VIEW Category_Sales_for_1997 AS
	SELECT Product_Sales_for_1997.CategoryName, Sum(Product_Sales_for_1997.ProductSales) AS CategorySales
	FROM Product_Sales_for_1997
	GROUP BY Product_Sales_for_1997.CategoryName;

create or replace view Sales_by_Category AS
	SELECT Categories.CategoryID, Categories.CategoryName, Products.ProductName,
		Sum(Order_Details_Extended.ExtendedPrice) AS ProductSales
	FROM 	Categories, Products, Order_Details_Extended, Orders
	where  Orders.OrderID = Order_Details_Extended.OrderID
	and    Products.ProductID = Order_Details_Extended.ProductID
	and   Categories.CategoryID = Products.CategoryID
	and   to_date(Orders.OrderDate, 'MM/DD/YYYY') BETWEEN to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD')
	GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName;
	--ORDER BY Products.ProductName

create or replace view Sales_Totals_by_Amount AS
	SELECT Order_Subtotals.Subtotal AS SaleAmount, Orders.OrderID, Customers.CompanyName, Orders.ShippedDate
	FROM 	Customers,  Order_Subtotals, Orders
	where Orders.OrderID = Order_Subtotals.OrderID
	and  Customers.CustomerID = Orders.CustomerID
	and (Order_Subtotals.Subtotal >2500) AND (to_date(Orders.ShippedDate, 'MM/DD/YYYY') BETWEEN to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD'));

CREATE VIEW Summary_of_Sales_by_Quarter AS
	SELECT Orders.ShippedDate, Orders.OrderID, Order_Subtotals.Subtotal
	FROM Orders, Order_Subtotals
	where Orders.OrderID = Order_Subtotals.OrderID
	and Orders.ShippedDate IS NOT NULL;
	--ORDER BY Orders.ShippedDate

CREATE VIEW Summary_of_Sales_by_Year AS
	SELECT Orders.ShippedDate, Orders.OrderID, Order_Subtotals.Subtotal
	FROM Orders, Order_Subtotals
	where Orders.OrderID = Order_Subtotals.OrderID
	and Orders.ShippedDate IS NOT NULL;
	--ORDER BY Orders.ShippedDate

/* END Views */

## 3.northwind.oracle.packages.sql
CREATE OR REPLACE
PACKAGE PKGENTLIB_ARCHITECTURE
AS
type CURENTLIB_ARCHITECTURE
IS
  REF
  CURSOR;
END PKGENTLIB_ARCHITECTURE;
  ----------PKG BODY:------------------
/
CREATE OR REPLACE
PACKAGE BODY PKGENTLIB_ARCHITECTURE
AS
BEGIN
  DBMS_OUTPUT.PUT_LINE('OUTPUT');
END PKGENTLIB_ARCHITECTURE;
----------------------------------
/
CREATE OR REPLACE
PACKAGE TESTPACKAGE
AS
  PROCEDURE TEST_TRANS_CUST_DETAILS (
		p_customer_id		 	IN 			VARCHAR2,
	    cur_OUT 				OUT 		PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE
	);
END TESTPACKAGE;
  ----------PKG BODY:------------------
/
CREATE OR REPLACE
PACKAGE BODY TESTPACKAGE
AS
	PROCEDURE TEST_TRANS_CUST_DETAILS
	(
		p_customer_id IN VARCHAR2,
	    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE
	)
	AS
	BEGIN
	    OPEN cur_OUT FOR
		SELECT *
		FROM Customers
		WHERE CustomerID = p_customer_id;

	END TEST_TRANS_CUST_DETAILS;
END TESTPACKAGE;
----------------------------------


## 4.northwind.oracle.sps.sql
CREATE OR REPLACE
PROCEDURE GetCustomersTest(
	p_customer_id IN varchar2,
  p_param_test IN varchar2,
  cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR SELECT * FROM Customers WHERE CustomerID = p_customer_id;
END;
/
CREATE OR REPLACE
PROCEDURE CustOrdersOrders(
	p_customer_id IN varchar2,
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR
  	SELECT 	OrderID,
			OrderDate,
			RequiredDate,
			ShippedDate
		FROM Orders
		WHERE CustomerID = p_customer_id
		ORDER BY OrderID;
END;
/
CREATE OR REPLACE
PROCEDURE CustOrderHist(
	p_customer_id IN varchar2,
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR
  	SELECT ProductName, SUM(Quantity) AS Total
    FROM Products P, Order_Details OD, Orders O, Customers C
    WHERE C.CustomerID = p_customer_id
      AND C.CustomerID = O.CustomerID
      AND O.OrderID = OD.OrderID
      AND OD.ProductID = P.ProductID
    GROUP BY ProductName;
END;
/
CREATE OR REPLACE
PROCEDURE CustOrdersDetails(
	p_order_id IN number,
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR
  	SELECT ProductName,
		    ROUND(Od.UnitPrice, 2) As UnitPrice,
		    Quantity,
		    ROUND(Discount * 100, 0) As Discount,
		    ROUND((Quantity * (1 - Discount) * Od.UnitPrice), 4) As ExtendedPrice
    FROM Products P, Order_Details Od
    WHERE Od.ProductID = P.ProductID and Od.OrderID = p_order_id;
END;
/
CREATE OR REPLACE
PROCEDURE EmployeeSalesByCountry(
	p_begin_date IN TIMESTAMP,
	p_end_date IN TIMESTAMP,
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR
  	SELECT 	Employees.Country,
  			Employees.LastName,
  			Employees.FirstName,
  			Orders.ShippedDate,
  			Orders.OrderID,
  			Order_Subtotals.Subtotal AS SaleAmount
    FROM Employees
    INNER JOIN
		(Orders INNER JOIN Order_Subtotals ON Orders.OrderID = Order_Subtotals.OrderID)
		ON Employees.EmployeeID = Orders.EmployeeID
		WHERE Orders.ShippedDate Between p_begin_date And p_end_date;
END;
/
CREATE OR REPLACE
PROCEDURE SalesByYear(
	p_begin_date IN TIMESTAMP,
	p_end_date IN TIMESTAMP,
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR
  	SELECT  Orders.ShippedDate,
            Orders.OrderID,
            Order_Subtotals.Subtotal,
            TO_CHAR(ShippedDate, 'YY') AS Year
    FROM Orders INNER JOIN Order_Subtotals ON Orders.OrderID = Order_Subtotals.OrderID
    WHERE Orders.ShippedDate Between p_begin_date And p_end_date;
END;
/
CREATE OR REPLACE
PROCEDURE SalesByCategory(
	p_category_name IN varchar2,
	p_order_year IN varchar2,
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
l_order_year varchar2(4);
BEGIN
  l_order_year := p_order_year;

	IF p_order_year != '1996' AND p_order_year != '1997' AND p_order_year != '1998' THEN
    l_order_year := '1998';
	END IF;

  OPEN cur_OUT FOR
    	SELECT ProductName,
            ROUND(SUM(OD.Quantity * (1-OD.Discount) * OD.UnitPrice), 2) As TotalPurchase
      FROM Order_Details OD, Orders O, Products P, Categories C
      WHERE OD.OrderID = O.OrderID
        AND OD.ProductID = P.ProductID
        AND P.CategoryID = C.CategoryID
        AND C.CategoryName = p_category_name
        AND TO_CHAR(O.OrderDate, 'YYYY') = l_order_year
      GROUP BY ProductName
      ORDER BY ProductName;
END;
/
CREATE OR REPLACE
PROCEDURE TenMostExpensiveProducts(
    cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
AS
BEGIN
  OPEN cur_OUT FOR
  	SELECT *  FROM (
	  	SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
		FROM Products
		ORDER BY Products.UnitPrice DESC)
  	WHERE ROWNUM <= 10;
END;

## 5.northwind.oracle.seed.sql
INSERT INTO CATEGORIES VALUES (1,'Beverages', 'Soft drinks, coffees, teas, beers, and ales', null);
INSERT INTO CATEGORIES VALUES (2,'Condiments', 'Sweet and savory sauces, relishes, spreads, and seasonings', null);
INSERT INTO CATEGORIES VALUES (3,'Confections', 'Desserts, candies, and sweet breads', null);
INSERT INTO CATEGORIES VALUES (4,'Dairy Products', 'Cheeses', null);
INSERT INTO CATEGORIES VALUES (5,'Grains/Cereals', 'Breads, crackers, pasta, and cereal', null);
INSERT INTO CATEGORIES VALUES (6,'Meat/Poultry', 'Prepared meats', null);
INSERT INTO CATEGORIES VALUES (7,'Produce', 'Dried fruit and bean curd', null);
INSERT INTO CATEGORIES VALUES (8,'Seafood', 'Seaweed and fish', null);


Insert Into Region Values (1,'Eastern');

Insert Into Region Values (2,'Western');

Insert Into Region Values (3,'Northern');

Insert Into Region Values (4,'Southern');


Insert Into Territories Values ('01581','Westboro',1);

Insert Into Territories Values ('01730','Bedford',1);

Insert Into Territories Values ('01833','Georgetow',1);

Insert Into Territories Values ('02116','Boston',1);

Insert Into Territories Values ('02139','Cambridge',1);

Insert Into Territories Values ('02184','Braintree',1);

Insert Into Territories Values ('02903','Providence',1);

Insert Into Territories Values ('03049','Hollis',3);

Insert Into Territories Values ('03801','Portsmouth',3);

Insert Into Territories Values ('06897','Wilton',1);

Insert Into Territories Values ('07960','Morristown',1);

Insert Into Territories Values ('08837','Edison',1);

Insert Into Territories Values ('10019','New York',1);

Insert Into Territories Values ('10038','New York',1);

Insert Into Territories Values ('11747','Mellvile',1);

Insert Into Territories Values ('14450','Fairport',1);

Insert Into Territories Values ('19428','Philadelphia',3);

Insert Into Territories Values ('19713','Neward',1);

Insert Into Territories Values ('20852','Rockville',1);

Insert Into Territories Values ('27403','Greensboro',1);

Insert Into Territories Values ('27511','Cary',1);

Insert Into Territories Values ('29202','Columbia',4);

Insert Into Territories Values ('30346','Atlanta',4);

Insert Into Territories Values ('31406','Savannah',4);

Insert Into Territories Values ('32859','Orlando',4);

Insert Into Territories Values ('33607','Tampa',4);

Insert Into Territories Values ('40222','Louisville',1);

Insert Into Territories Values ('44122','Beachwood',3);

Insert Into Territories Values ('45839','Findlay',3);

Insert Into Territories Values ('48075','Southfield',3);

Insert Into Territories Values ('48084','Troy',3);

Insert Into Territories Values ('48304','Bloomfield Hills',3);

Insert Into Territories Values ('53404','Racine',3);

Insert Into Territories Values ('55113','Roseville',3);

Insert Into Territories Values ('55439','Minneapolis',3);

Insert Into Territories Values ('60179','Hoffman Estates',2);

Insert Into Territories Values ('60601','Chicago',2);

Insert Into Territories Values ('72716','Bentonville',4);

Insert Into Territories Values ('75234','Dallas',4);

Insert Into Territories Values ('78759','Austin',4);

Insert Into Territories Values ('80202','Denver',2);

Insert Into Territories Values ('80909','Colorado Springs',2);

Insert Into Territories Values ('85014','Phoenix',2);

Insert Into Territories Values ('85251','Scottsdale',2);

Insert Into Territories Values ('90405','Santa Monica',2);

Insert Into Territories Values ('94025','Menlo Park',2);

Insert Into Territories Values ('94105','San Francisco',2);

Insert Into Territories Values ('95008','Campbell',2);

Insert Into Territories Values ('95054','Santa Clara',2);

Insert Into Territories Values ('95060','Santa Cruz',2);

Insert Into Territories Values ('98004','Bellevue',2);

Insert Into Territories Values ('98052','Redmond',2);

Insert Into Territories Values ('98104','Seattle',2);


INSERT INTO EMPLOYEES
VALUES (1,'Davolio','Nancy','Sales Representative','Ms.',to_date('08-DEC-48','DD-MON-RR'),to_date('01-MAY-92','DD-MON-RR'),'507 - 20th Ave. E.
Apt. 2A','Seattle','WA','98122','USA','(206) 555-9857','5467',null, null, null,'http://accweb/emmployees/davolio.bmp');
INSERT INTO EMPLOYEES
VALUES (2,'Fuller','Andrew','Vice President, Sales','Dr.',to_date('19-FEB-52','DD-MON-RR'),to_date('14-AUG-92','DD-MON-RR'),'908 W. Capital Way','Tacoma','WA','98401','USA','(206) 555-9482','3457',null, null, null,'http://accweb/emmployees/fuller.bmp');
INSERT INTO EMPLOYEES
VALUES (3,'Leverling','Janet','Sales Representative','Ms.',to_date('30-AUG-63','DD-MON-RR'),to_date('01-APR-92','DD-MON-RR'),'722 Moss Bay Blvd.','Kirkland','WA','98033','USA','(206) 555-3412','3355',null, null,2,'http://accweb/emmployees/leverling.bmp');
INSERT INTO EMPLOYEES
VALUES (4,'Peacock','Margaret','Sales Representative','Mrs.',to_date('19-SEP-37','DD-MON-RR'),to_date('03-MAY-93','DD-MON-RR'),'4110 Old Redmond Rd.','Redmond','WA','98052','USA','(206) 555-8122','5176',null, null,2,'http://accweb/emmployees/peacock.bmp');
INSERT INTO EMPLOYEES
VALUES (5,'Buchanan','Steven','Sales Manager','Mr.',to_date('04-MAR-55','DD-MON-RR'),to_date('17-OCT-93','DD-MON-RR'),'14 Garrett Hill','London',null,'SW1 8JR','UK','(71) 555-4848','3453',null, null,2,'http://accweb/emmployees/buchanan.bmp');
INSERT INTO EMPLOYEES
VALUES (6,'Suyama','Michael','Sales Representative','Mr.',to_date('02-JUL-63','DD-MON-RR'),to_date('17-OCT-93','DD-MON-RR'),'Coventry House
Miner Rd.','London',null,'EC2 7JR','UK','(71) 555-7773','428',null, null,5,'http://accweb/emmployees/davolio.bmp');
INSERT INTO EMPLOYEES
VALUES (7,'King','Robert','Sales Representative','Mr.',to_date('29-MAY-60','DD-MON-RR'),to_date('02-JAN-94','DD-MON-RR'),'Edgeham Hollow
Winchester Way','London',null,'RG1 9SP','UK','(71) 555-5598','465',null, null,5,'http://accweb/emmployees/davolio.bmp');
INSERT INTO EMPLOYEES
VALUES (8,'Callahan','Laura','Inside Sales Coordinator','Ms.',to_date('09-JAN-58','DD-MON-RR'),to_date('05-MAR-94','DD-MON-RR'),'4726 - 11th Ave. N.E.','Seattle','WA','98105','USA','(206) 555-1189','2344',null, null,2,'http://accweb/emmployees/davolio.bmp');
INSERT INTO EMPLOYEES
VALUES (9,'Dodsworth','Anne','Sales Representative','Ms.',to_date('27-JAN-66','DD-MON-RR'),to_date('15-NOV-94','DD-MON-RR'),'7 Houndstooth Rd.','London',null,'WG2 7LT','UK','(71) 555-4444','452',null, null,5,'http://accweb/emmployees/davolio.bmp');

UPDATE EMPLOYEES SET REPORTSTO = 2 WHERE EmployeeID = 1;


Insert Into EmployeeTerritories Values (1,'06897');

Insert Into EmployeeTerritories Values (1,'19713');

Insert Into EmployeeTerritories Values (2,'01581');

Insert Into EmployeeTerritories Values (2,'01730');

Insert Into EmployeeTerritories Values (2,'01833');

Insert Into EmployeeTerritories Values (2,'02116');

Insert Into EmployeeTerritories Values (2,'02139');

Insert Into EmployeeTerritories Values (2,'02184');

Insert Into EmployeeTerritories Values (2,'40222');

Insert Into EmployeeTerritories Values (3,'30346');

Insert Into EmployeeTerritories Values (3,'31406');

Insert Into EmployeeTerritories Values (3,'32859');

Insert Into EmployeeTerritories Values (3,'33607');

Insert Into EmployeeTerritories Values (4,'20852');

Insert Into EmployeeTerritories Values (4,'27403');

Insert Into EmployeeTerritories Values (4,'27511');

Insert Into EmployeeTerritories Values (5,'02903');

Insert Into EmployeeTerritories Values (5,'07960');

Insert Into EmployeeTerritories Values (5,'08837');

Insert Into EmployeeTerritories Values (5,'10019');

Insert Into EmployeeTerritories Values (5,'10038');

Insert Into EmployeeTerritories Values (5,'11747');

Insert Into EmployeeTerritories Values (5,'14450');

Insert Into EmployeeTerritories Values (6,'85014');

Insert Into EmployeeTerritories Values (6,'85251');

Insert Into EmployeeTerritories Values (6,'98004');

Insert Into EmployeeTerritories Values (6,'98052');

Insert Into EmployeeTerritories Values (6,'98104');

Insert Into EmployeeTerritories Values (7,'60179');

Insert Into EmployeeTerritories Values (7,'60601');

Insert Into EmployeeTerritories Values (7,'80202');

Insert Into EmployeeTerritories Values (7,'80909');

Insert Into EmployeeTerritories Values (7,'90405');

Insert Into EmployeeTerritories Values (7,'94025');

Insert Into EmployeeTerritories Values (7,'94105');

Insert Into EmployeeTerritories Values (7,'95008');

Insert Into EmployeeTerritories Values (7,'95054');

Insert Into EmployeeTerritories Values (7,'95060');

Insert Into EmployeeTerritories Values (8,'19428');

Insert Into EmployeeTerritories Values (8,'44122');

Insert Into EmployeeTerritories Values (8,'45839');

Insert Into EmployeeTerritories Values (8,'53404');

Insert Into EmployeeTerritories Values (9,'03049');

Insert Into EmployeeTerritories Values (9,'03801');

Insert Into EmployeeTerritories Values (9,'48075');

Insert Into EmployeeTerritories Values (9,'48084');

Insert Into EmployeeTerritories Values (9,'48304');

Insert Into EmployeeTerritories Values (9,'55113');

Insert Into EmployeeTerritories Values (9,'55439');

Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ALFKI','Alfreds Futterkiste','Maria Anders','Sales Representative','Obere Str. 57','Berlin',null,'12209','Germany','030-0074321','030-0076545');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ANATR','Ana Trujillo Emparedados y helados','Ana Trujillo','Owner','Avda. de la Constitución 2222','México D.F.',null,'05021','Mexico','(5) 555-4729','(5) 555-3745');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ANTON','Antonio Moreno Taquería','Antonio Moreno','Owner','Mataderos  2312','México D.F.',null,'05023','Mexico','(5) 555-3932',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('AROUT','Around the Horn','Thomas Hardy','Sales Representative','120 Hanover Sq.','London',null,'WA1 1DP','UK','(171) 555-7788','(171) 555-6750');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BERGS','Berglunds snabbköp','Christina Berglund','Order Administrator','Berguvsvägen  8','Luleå',null,'S-958 22','Sweden','0921-12 34 65','0921-12 34 67');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BLAUS','Blauer See Delikatessen','Hanna Moos','Sales Representative','Forsterstr. 57','Mannheim',null,'68306','Germany','0621-08460','0621-08924');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BLONP','Blondesddsl père et fils','Frédérique Citeaux','Marketing Manager','24, place Kléber','Strasbourg',null,'67000','France','88.60.15.31','88.60.15.32');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BOLID','Bólido Comidas preparadas','Martín Sommer','Owner','C/ Araquil, 67','Madrid',null,'28023','Spain','(91) 555 22 82','(91) 555 91 99');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BONAP','Bon app''','Laurence Lebihan','Owner','12, rue des Bouchers','Marseille',null,'13008','France','91.24.45.40','91.24.45.41');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BOTTM','Bottom-Dollar Markets','Elizabeth Lincoln','Accounting Manager','23 Tsawassen Blvd.','Tsawassen','BC','T2F 8M4','Canada','(604) 555-4729','(604) 555-3745');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('BSBEV','B''s Beverages','Victoria Ashworth','Sales Representative','Fauntleroy Circus','London',null,'EC2 5NT','UK','(171) 555-1212',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CACTU','Cactus Comidas para llevar','Patricio Simpson','Sales Agent','Cerrito 333','Buenos Aires',null,'1010','Argentina','(1) 135-5555','(1) 135-4892');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CENTC','Centro comercial Moctezuma','Francisco Chang','Marketing Manager','Sierras de Granada 9993','México D.F.',null,'05022','Mexico','(5) 555-3392','(5) 555-7293');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CHOPS','Chop-suey Chinese','Yang Wang','Owner','Hauptstr. 29','Bern',null,'3012','Switzerland','0452-076545',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('COMMI','Comércio Mineiro','Pedro Afonso','Sales Associate','Av. dos Lusíadas, 23','Sao Paulo','SP','05432-043','Brazil','(11) 555-7647',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('CONSH','Consolidated Holdings','Elizabeth Brown','Sales Representative','Berkeley Gardens 12  Brewery','London',null,'WX1 6LT','UK','(171) 555-2282','(171) 555-9199');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('DRACD','Drachenblut Delikatessen','Sven Ottlieb','Order Administrator','Walserweg 21','Aachen',null,'52066','Germany','0241-039123','0241-059428');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('DUMON','Du monde entier','Janine Labrune','Owner','67, rue des Cinquante Otages','Nantes',null,'44000','France','40.67.88.88','40.67.89.89');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('EASTC','Eastern Connection','Ann Devon','Sales Agent','35 King George','London',null,'WX3 6FW','UK','(171) 555-0297','(171) 555-3373');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ERNSH','Ernst Handel','Roland Mendel','Sales Manager','Kirchgasse 6','Graz',null,'8010','Austria','7675-3425','7675-3426');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FAMIA','Familia Arquibaldo','Aria Cruz','Marketing Assistant','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil','(11) 555-9857',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FISSA','FISSA Fabrica Inter. Salchichas S.A.','Diego Roel','Accounting Manager','C/ Moralzarzal, 86','Madrid',null,'28034','Spain','(91) 555 94 44','(91) 555 55 93');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FOLIG','Folies gourmandes','Martine Rancé','Assistant Sales Agent','184, chaussée de Tournai','Lille',null,'59000','France','20.16.10.16','20.16.10.17');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FOLKO','Folk och fä HB','Maria Larsson','Owner','Åkergatan 24','Bräcke',null,'S-844 67','Sweden','0695-34 67 21',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FRANK','Frankenversand','Peter Franken','Marketing Manager','Berliner Platz 43','München',null,'80805','Germany','089-0877310','089-0877451');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FRANR','France restauration','Carine Schmitt','Marketing Manager','54, rue Royale','Nantes',null,'44000','France','40.32.21.21','40.32.21.20');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FRANS','Franchi S.p.A.','Paolo Accorti','Sales Representative','Via Monte Bianco 34','Torino',null,'10100','Italy','011-4988260','011-4988261');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('FURIB','Furia Bacalhau e Frutos do Mar','Lino Rodriguez','Sales Manager','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal','(1) 354-2534','(1) 354-2535');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GALED','Galería del gastrónomo','Eduardo Saavedra','Marketing Manager','Rambla de Cataluña, 23','Barcelona',null,'08022','Spain','(93) 203 4560','(93) 203 4561');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GODOS','Godos Cocina Típica','José Pedro Freyre','Sales Manager','C/ Romero, 33','Sevilla',null,'41101','Spain','(95) 555 82 82',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GOURL','Gourmet Lanchonetes','André Fonseca','Sales Associate','Av. Brasil, 442','Campinas','SP','04876-786','Brazil','(11) 555-9482',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GREAL','Great Lakes Food Market','Howard Snyder','Marketing Manager','2732 Baker Blvd.','Eugene','OR','97403','USA','(503) 555-7555',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('GROSR','GROSELLA-Restaurante','Manuel Pereira','Owner','5ª Ave. Los Palos Grandes','Caracas','DF','1081','Venezuela','(2) 283-2951','(2) 283-3397');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HANAR','Hanari Carnes','Mario Pontes','Accounting Manager','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil','(21) 555-0091','(21) 555-8765');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HILAA','HILARION-Abastos','Carlos Hernández','Sales Representative','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela','(5) 555-1340','(5) 555-1948');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HUNGC','Hungry Coyote Import Store','Yoshi Latimer','Sales Representative','City Center Plaza 516 Main St.','Elgin','OR','97827','USA','(503) 555-6874','(503) 555-2376');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('HUNGO','Hungry Owl All-Night Grocers','Patricia McKenna','Sales Associate','8 Johnstown Road','Cork','Co. Cork',null,'Ireland','2967 542','2967 3333');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ISLAT','Island Trading','Helen Bennett','Marketing Manager','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK','(198) 555-8888',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('KOENE','Königlich Essen','Philip Cramer','Sales Associate','Maubelstr. 90','Brandenburg',null,'14776','Germany','0555-09876',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LACOR','La corne d''abondance','Daniel Tonini','Sales Representative','67, avenue de l''Europe','Versailles',null,'78000','France','30.59.84.10','30.59.85.11');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LAMAI','La maison d''Asie','Annette Roulet','Sales Manager','1 rue Alsace-Lorraine','Toulouse',null,'31000','France','61.77.61.10','61.77.61.11');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LAUGB','Laughing Bacchus Wine Cellars','Yoshi Tannamuri','Marketing Assistant','1900 Oak St.','Vancouver','BC','V3F 2K1','Canada','(604) 555-3392','(604) 555-7293');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LAZYK','Lazy K Kountry Store','John Steel','Marketing Manager','12 Orchestra Terrace','Walla Walla','WA','99362','USA','(509) 555-7969','(509) 555-6221');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LEHMS','Lehmanns Marktstand','Renate Messner','Sales Representative','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany','069-0245984','069-0245874');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LETSS','Let''s Stop N Shop','Jaime Yorres','Owner','87 Polk St. Suite 5','San Francisco','CA','94117','USA','(415) 555-5938',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LILAS','LILA-Supermercado','Carlos González','Accounting Manager','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela','(9) 331-6954','(9) 331-7256');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LINOD','LINO-Delicateses','Felipe Izquierdo','Owner','Ave. 5 de Mayo Porlamar','I. de Margarita','Nueva Esparta','4980','Venezuela','(8) 34-56-12','(8) 34-93-93');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('LONEP','Lonesome Pine Restaurant','Fran Wilson','Sales Manager','89 Chiaroscuro Rd.','Portland','OR','97219','USA','(503) 555-9573','(503) 555-9646');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MAGAA','Magazzini Alimentari Riuniti','Giovanni Rovelli','Marketing Manager','Via Ludovico il Moro 22','Bergamo',null,'24100','Italy','035-640230','035-640231');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MAISD','Maison Dewey','Catherine Dewey','Sales Agent','Rue Joseph-Bens 532','Bruxelles',null,'B-1180','Belgium','(02) 201 24 67','(02) 201 24 68');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MEREP','Mère Paillarde','Jean Fresnière','Marketing Assistant','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada','(514) 555-8054','(514) 555-8055');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('MORGK','Morgenstern Gesundkost','Alexander Feuer','Marketing Assistant','Heerstr. 22','Leipzig',null,'04179','Germany','0342-023176',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('NORTS','North/South','Simon Crowther','Sales Associate','South House 300 Queensbridge','London',null,'SW7 1RZ','UK','(171) 555-7733','(171) 555-2530');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('OCEAN','Océano Atlántico Ltda.','Yvonne Moncada','Sales Agent','Ing. Gustavo Moncada 8585 Piso 20-A','Buenos Aires',null,'1010','Argentina','(1) 135-5333','(1) 135-5535');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('OLDWO','Old World Delicatessen','Rene Phillips','Sales Representative','2743 Bering St.','Anchorage','AK','99508','USA','(907) 555-7584','(907) 555-2880');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('OTTIK','Ottilies Käseladen','Henriette Pfalzheim','Owner','Mehrheimerstr. 369','Köln',null,'50739','Germany','0221-0644327','0221-0765721');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PARIS','Paris spécialités','Marie Bertrand','Owner','265, boulevard Charonne','Paris',null,'75012','France','(1) 42.34.22.66','(1) 42.34.22.77');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PERIC','Pericles Comidas clásicas','Guillermo Fernández','Sales Representative','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico','(5) 552-3745','(5) 545-3745');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PICCO','Piccolo und mehr','Georg Pipps','Sales Manager','Geislweg 14','Salzburg',null,'5020','Austria','6562-9722','6562-9723');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('PRINI','Princesa Isabel Vinhos','Isabel de Castro','Sales Representative','Estrada da saúde n. 58','Lisboa',null,'1756','Portugal','(1) 356-5634',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('QUEDE','Que Delícia','Bernardo Batista','Accounting Manager','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil','(21) 555-4252','(21) 555-4545');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('QUEEN','Queen Cozinha','Lúcia Carvalho','Marketing Assistant','Alameda dos Canàrios, 891','Sao Paulo','SP','05487-020','Brazil','(11) 555-1189',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('QUICK','QUICK-Stop','Horst Kloss','Accounting Manager','Taucherstraße 10','Cunewalde',null,'01307','Germany','0372-035188',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RANCH','Rancho grande','Sergio Gutiérrez','Sales Representative','Av. del Libertador 900','Buenos Aires',null,'1010','Argentina','(1) 123-5555','(1) 123-5556');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RATTC','Rattlesnake Canyon Grocery','Paula Wilson','Assistant Sales Representative','2817 Milton Dr.','Albuquerque','NM','87110','USA','(505) 555-5939','(505) 555-3620');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('REGGC','Reggiani Caseifici','Maurizio Moroni','Sales Associate','Strada Provinciale 124','Reggio Emilia',null,'42100','Italy','0522-556721','0522-556722');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RICAR','Ricardo Adocicados','Janete Limeira','Assistant Sales Agent','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil','(21) 555-3412',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('RICSU','Richter Supermarkt','Michael Holz','Sales Manager','Grenzacherweg 237','Genève',null,'1203','Switzerland','0897-034214',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('ROMEY','Romero y tomillo','Alejandra Camino','Accounting Manager','Gran Vía, 1','Madrid',null,'28001','Spain','(91) 745 6200','(91) 745 6210');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SANTG','Santé Gourmet','Jonas Bergulfsen','Owner','Erling Skakkes gate 78','Stavern',null,'4110','Norway','07-98 92 35','07-98 92 47');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SAVEA','Save-a-lot Markets','Jose Pavarotti','Sales Representative','187 Suffolk Ln.','Boise','ID','83720','USA','(208) 555-8097',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SEVES','Seven Seas Imports','Hari Kumar','Sales Manager','90 Wadhurst Rd.','London',null,'OX15 4NB','UK','(171) 555-1717','(171) 555-5646');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SIMOB','Simons bistro','Jytte Petersen','Owner','Vinbæltet 34','Kobenhavn',null,'1734','Denmark','31 12 34 56','31 13 35 57');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SPECD','Spécialités du monde','Dominique Perrier','Marketing Manager','25, rue Lauriston','Paris',null,'75016','France','(1) 47.55.60.10','(1) 47.55.60.20');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SPLIR','Split Rail Beer & Ale','Art Braunschweiger','Sales Manager','P.O. Box 555','Lander','WY','82520','USA','(307) 555-4680','(307) 555-6525');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('SUPRD','Suprêmes délices','Pascale Cartrain','Accounting Manager','Boulevard Tirou, 255','Charleroi',null,'B-6000','Belgium','(071) 23 67 22 20','(071) 23 67 22 21');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('THEBI','The Big Cheese','Liz Nixon','Marketing Manager','89 Jefferson Way Suite 2','Portland','OR','97201','USA','(503) 555-3612',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('THECR','The Cracker Box','Liu Wong','Marketing Assistant','55 Grizzly Peak Rd.','Butte','MT','59801','USA','(406) 555-5834','(406) 555-8083');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TOMSP','Toms Spezialitäten','Karin Josephs','Marketing Manager','Luisenstr. 48','Münster',null,'44087','Germany','0251-031259','0251-035695');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TORTU','Tortuga Restaurante','Miguel Angel Paolino','Owner','Avda. Azteca 123','México D.F.',null,'05033','Mexico','(5) 555-2933',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TRADH','Tradição Hipermercados','Anabela Domingues','Sales Representative','Av. Inês de Castro, 414','Sao Paulo','SP','05634-030','Brazil','(11) 555-2167','(11) 555-2168');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('TRAIH','Trail''s Head Gourmet Provisioners','Helvetius Nagy','Sales Associate','722 DaVinci Blvd.','Kirkland','WA','98034','USA','(206) 555-8257','(206) 555-2174');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('VAFFE','Vaffeljernet','Palle Ibsen','Sales Manager','Smagsloget 45','Århus',null,'8200','Denmark','86 21 32 43','86 22 33 44');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('VICTE','Victuailles en stock','Mary Saveley','Sales Agent','2, rue du Commerce','Lyon',null,'69004','France','78.32.54.86','78.32.54.87');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('VINET','Vins et alcools Chevalier','Paul Henriot','Accounting Manager','59 rue de l''Abbaye','Reims',null,'51100','France','26.47.15.10','26.47.15.11');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WANDK','Die Wandernde Kuh','Rita Müller','Sales Representative','Adenauerallee 900','Stuttgart',null,'70563','Germany','0711-020361','0711-035428');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WARTH','Wartian Herkku','Pirkko Koskitalo','Accounting Manager','Torikatu 38','Oulu',null,'90110','Finland','981-443655','981-443655');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WELLI','Wellington Importadora','Paula Parente','Sales Manager','Rua do Mercado, 12','Resende','SP','08737-363','Brazil','(14) 555-8122',null);
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WHITC','White Clover Markets','Karl Jablonski','Owner','305 - 14th Ave. S. Suite 3B','Seattle','WA','98128','USA','(206) 555-4112','(206) 555-4115');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WILMK','Wilman Kala','Matti Karttunen','Owner/Marketing Assistant','Keskuskatu 45','Helsinki',null,'21240','Finland','90-224 8858','90-224 8858');
Insert into CUSTOMERS (CUSTOMERID,COMPANYNAME,CONTACTNAME,CONTACTTITLE,ADDRESS,CITY,REGION,POSTALCODE,COUNTRY,PHONE,FAX) values ('WOLZA','Wolski  Zajazd','Zbyszek Piestrzeniewicz','Owner','ul. Filtrowa 68','Warszawa',null,'01-012','Poland','(26) 642-7012','(26) 642-7012');


INSERT INTO Shippers(ShipperID,CompanyName,Phone) VALUES(1,'Speedy Express','(503) 555-9831');

INSERT INTO Shippers(ShipperID,CompanyName,Phone) VALUES(2,'United Package','(503) 555-3199');

INSERT INTO Shippers(ShipperID,CompanyName,Phone) VALUES(3,'Federal Shipping','(503) 555-9931');


INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(1,'Exotic Liquids','Charlotte Cooper','Purchasing Manager','49 Gilbert St.','London',NULL,'EC1 4SD','UK','(171) 555-2222',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(2,'New Orleans Cajun Delights','Shelley Burke','Order Administrator','P.O. Box 78934','New Orleans','LA','70117','USA','(100) 555-4822',NULL,'#CAJUN.HTM#');

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(3,'Grandma Kelly''s Homestead','Regina Murphy','Sales Representative','707 Oxford Rd.','Ann Arbor','MI','48104','USA','(313) 555-5735','(313) 555-3349',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(4,'Tokyo Traders','Yoshi Nagase','Marketing Manager','9-8 Sekimai Musashino-shi','Tokyo',NULL,'100','Japan','(03) 3555-5011',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(5,'Cooperativa de Quesos ''Las Cabras''','Antonio del Valle Saavedra','Export Administrator','Calle del Rosal 4','Oviedo','Asturias','33007','Spain','(98) 598 76 54',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(6,'Mayumi''s','Mayumi Ohno','Marketing Representative','92 Setsuko Chuo-ku','Osaka',NULL,'545','Japan','(06) 431-7877',NULL,'Mayumi''s (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/mayumi.htm#');

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(7,'Pavlova, Ltd.','Ian Devling','Marketing Manager','74 Rose St. Moonie Ponds','Melbourne','Victoria','3058','Australia','(03) 444-2343','(03) 444-6588',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(8,'Specialty Biscuits, Ltd.','Peter Wilson','Sales Representative','29 King''s Way','Manchester',NULL,'M14 GSD','UK','(161) 555-4448',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(9,'PB Knäckebröd AB','Lars Peterson','Sales Agent','Kaloadagatan 13','Göteborg',NULL,'S-345 67','Sweden','031-987 65 43','031-987 65 91',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(10,'Refrescos Americanas LTDA','Carlos Diaz','Marketing Manager','Av. das Americanas 12.890','Sao Paulo',NULL,'5442','Brazil','(11) 555 4640',NULL,NULL);


INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(11,'Heli Süßwaren GmbH and Co. KG','Petra Winkler','Sales Manager','Tiergartenstraße 5','Berlin',NULL,'10785','Germany','(010) 9984510',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(12,'Plutzer Lebensmittelgroßmärkte AG','Martin Bein','International Marketing Mgr.','Bogenallee 51','Frankfurt',NULL,'60439','Germany','(069) 992755',NULL,'Plutzer (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/plutzer.htm#');

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(13,'Nord-Ost-Fisch Handelsgesellschaft mbH','Sven Petersen','Coordinator Foreign Markets','Frahmredder 112a','Cuxhaven',NULL,'27478','Germany','(04721) 8713','(04721) 8714',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(14,'Formaggi Fortini s.r.l.','Elio Rossi','Sales Representative','Viale Dante, 75','Ravenna',NULL,'48100','Italy','(0544) 60323','(0544) 60603','#FORMAGGI.HTM#');

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(15,'Norske Meierier','Beate Vileid','Marketing Manager','Hatlevegen 5','Sandvika',NULL,'1320','Norway','(0)2-953010',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(16,'Bigfoot Breweries','Cheryl Saylor','Regional Account Rep.','3400 - 8th Avenue Suite 210','Bend','OR','97101','USA','(503) 555-9931',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(17,'Svensk Sjöföda AB','Michael Björn','Sales Representative','Brovallavägen 231','Stockholm',NULL,'S-123 45','Sweden','08-123 45 67',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(18,'Aux joyeux ecclésiastiques','Guylène Nodier','Sales Manager','203, Rue des Francs-Bourgeois','Paris',NULL,'75004','France','(1) 03.83.00.68','(1) 03.83.00.62',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(19,'New England Seafood Cannery','Robb Merchant','Wholesale Account Agent','Order Processing Dept. 2100 Paul Revere Blvd.','Boston','MA','02134','USA','(617) 555-3267','(617) 555-3389',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(20,'Leka Trading','Chandra Leka','Owner','471 Serangoon Loop, Suite #402','Singapore',NULL,'0512','Singapore','555-8787',NULL,NULL);


INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(21,'Lyngbysild','Niels Petersen','Sales Manager','Lyngbysild Fiskebakken 10','Lyngby',NULL,'2800','Denmark','43844108','43844115',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(22,'Zaanse Snoepfabriek','Dirk Luchte','Accounting Manager','Verkoop Rijnweg 22','Zaandam',NULL,'9999 ZZ','Netherlands','(12345) 1212','(12345) 1210',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(23,'Karkki Oy','Anne Heikkonen','Product Manager','Valtakatu 12','Lappeenranta',NULL,'53120','Finland','(953) 10956',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(24,'G''day, Mate','Wendy Mackenzie','Sales Representative','170 Prince Edward Parade Hunter''s Hill','Sydney','NSW','2042','Australia','(02) 555-5914','(02) 555-4873','G''day Mate (on the World Wide Web)#http://www.microsoft.com/accessdev/sampleapps/gdaymate.htm#');

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(25,'Ma Maison','Jean-Guy Lauzon','Marketing Manager','2960 Rue St. Laurent','Montréal','Québec','H1J 1C3','Canada','(514) 555-9022',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(26,'Pasta Buttini s.r.l.','Giovanni Giudici','Order Administrator','Via dei Gelsomini, 153','Salerno',NULL,'84100','Italy','(089) 6547665','(089) 6547667',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(27,'Escargots Nouveaux','Marie Delamare','Sales Manager','22, rue H. Voiron','Montceau',NULL,'71300','France','85.57.00.07',NULL,NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(28,'Gai pâturage','Eliane Noz','Sales Representative','Bat. B 3, rue des Alpes','Annecy',NULL,'74000','France','38.76.98.06','38.76.98.58',NULL);

INSERT INTO Suppliers(SupplierID,CompanyName,ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax,HomePage) VALUES(29,'Forêts d''érables','Chantal Goulet','Accounting Manager','148 rue Chasseur','Ste-Hyacinthe','Québec','J2S 7S8','Canada','(514) 555-2955','(514) 555-2921',NULL);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(1,'Chai',1,1,'10 boxes x 20 bags',18,39,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(2,'Chang',1,1,'24 - 12 oz bottles',19,17,40,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(3,'Aniseed Syrup',1,2,'12 - 550 ml bottles',10,13,70,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(4,'Chef Anton''s Cajun Seasoning',2,2,'48 - 6 oz jars',22,53,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(5,'Chef Anton''s Gumbo Mix',2,2,'36 boxes',21.35,0,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(6,'Grandma''s Boysenberry Spread',3,2,'12 - 8 oz jars',25,120,0,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(7,'Uncle Bob''s Organic Dried Pears',3,7,'12 - 1 lb pkgs.',30,15,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(8,'Northwoods Cranberry Sauce',3,2,'12 - 12 oz jars',40,6,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(9,'Mishi Kobe Niku',4,6,'18 - 500 g pkgs.',97,29,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(10,'Ikura',4,8,'12 - 200 ml jars',31,31,0,0,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(11,'Queso Cabrales',5,4,'1 kg pkg.',21,22,30,30,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(12,'Queso Manchego La Pastora',5,4,'10 - 500 g pkgs.',38,86,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(13,'Konbu',6,8,'2 kg box',6,24,0,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(14,'Tofu',6,7,'40 - 100 g pkgs.',23.25,35,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(15,'Genen Shouyu',6,2,'24 - 250 ml bottles',15.5,39,0,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(16,'Pavlova',7,3,'32 - 500 g boxes',17.45,29,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(17,'Alice Mutton',7,6,'20 - 1 kg tins',39,0,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(18,'Carnarvon Tigers',7,8,'16 kg pkg.',62.5,42,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(19,'Teatime Chocolate Biscuits',8,3,'10 boxes x 12 pieces',9.2,25,0,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(20,'Sir Rodney''s Marmalade',8,3,'30 gift boxes',81,40,0,0,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(21,'Sir Rodney''s Scones',8,3,'24 pkgs. x 4 pieces',10,3,40,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(22,'Gustaf''s Knäckebröd',9,5,'24 - 500 g pkgs.',21,104,0,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(23,'Tunnbröd',9,5,'12 - 250 g pkgs.',9,61,0,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(24,'Guaraná Fantástica',10,1,'12 - 355 ml cans',4.5,20,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(25,'NuNuCa Nuß-Nougat-Creme',11,3,'20 - 450 g glasses',14,76,0,30,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(26,'Gumbär Gummibärchen',11,3,'100 - 250 g bags',31.23,15,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(27,'Schoggi Schokolade',11,3,'100 - 100 g pieces',43.9,49,0,30,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(28,'Rössle Sauerkraut',12,7,'25 - 825 g cans',45.6,26,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(29,'Thüringer Rostbratwurst',12,6,'50 bags x 30 sausgs.',123.79,0,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(30,'Nord-Ost Matjeshering',13,8,'10 - 200 g glasses',25.89,10,0,15,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(31,'Gorgonzola Telino',14,4,'12 - 100 g pkgs',12.5,0,70,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(32,'Mascarpone Fabioli',14,4,'24 - 200 g pkgs.',32,9,40,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(33,'Geitost',15,4,'500 g',2.5,112,0,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(34,'Sasquatch Ale',16,1,'24 - 12 oz bottles',14,111,0,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(35,'Steeleye Stout',16,1,'24 - 12 oz bottles',18,20,0,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(36,'Inlagd Sill',17,8,'24 - 250 g  jars',19,112,0,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(37,'Gravad lax',17,8,'12 - 500 g pkgs.',26,11,50,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(38,'Côte de Blaye',18,1,'12 - 75 cl bottles',263.5,17,0,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(39,'Chartreuse verte',18,1,'750 cc per bottle',18,69,0,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(40,'Boston Crab Meat',19,8,'24 - 4 oz tins',18.4,123,0,30,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(41,'Jack''s New England Clam Chowder',19,8,'12 - 12 oz cans',9.65,85,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(42,'Singaporean Hokkien Fried Mee',20,5,'32 - 1 kg pkgs.',14,26,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(43,'Ipoh Coffee',20,1,'16 - 500 g tins',46,17,10,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(44,'Gula Malacca',20,2,'20 - 2 kg bags',19.45,27,0,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(45,'Rogede sild',21,8,'1k pkg.',9.5,5,70,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(46,'Spegesild',21,8,'4 - 450 g glasses',12,95,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(47,'Zaanse koeken',22,3,'10 - 4 oz boxes',9.5,36,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(48,'Chocolade',22,3,'10 pkgs.',12.75,15,70,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(49,'Maxilaku',23,3,'24 - 50 g pkgs.',20,10,60,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(50,'Valkoinen suklaa',23,3,'12 - 100 g bars',16.25,65,0,30,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(51,'Manjimup Dried Apples',24,7,'50 - 300 g pkgs.',53,20,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(52,'Filo Mix',24,5,'16 - 2 kg boxes',7,38,0,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(53,'Perth Pasties',24,6,'48 pieces',32.8,0,0,0,1);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(54,'Tourtière',25,6,'16 pies',7.45,21,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(55,'Pâté chinois',25,6,'24 boxes x 2 pies',24,115,0,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(56,'Gnocchi di nonna Alice',26,5,'24 - 250 g pkgs.',38,21,10,30,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(57,'Ravioli Angelo',26,5,'24 - 250 g pkgs.',19.5,36,0,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(58,'Escargots de Bourgogne',27,8,'24 pieces',13.25,62,0,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(59,'Raclette Courdavault',28,4,'5 kg pkg.',55,79,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(60,'Camembert Pierrot',28,4,'15 - 300 g rounds',34,19,0,0,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(61,'Sirop d''érable',29,2,'24 - 500 ml bottles',28.5,113,0,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(62,'Tarte au sucre',29,3,'48 pies',49.3,17,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(63,'Vegie-spread',7,2,'15 - 625 g jars',43.9,24,0,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(64,'Wimmers gute Semmelknödel',12,5,'20 bags x 4 pieces',33.25,22,80,30,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(65,'Louisiana Fiery Hot Pepper Sauce',2,2,'32 - 8 oz bottles',21.05,76,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(66,'Louisiana Hot Spiced Okra',2,2,'24 - 8 oz jars',17,4,100,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(67,'Laughing Lumberjack Lager',16,1,'24 - 12 oz bottles',14,52,0,10,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(68,'Scottish Longbreads',8,3,'10 boxes x 8 pieces',12.5,6,10,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(69,'Gudbrandsdalsost',15,4,'10 kg pkg.',36,26,0,15,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(70,'Outback Lager',7,1,'24 - 355 ml bottles',15,15,10,30,0);


INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(71,'Flotemysost',15,4,'10 - 500 g pkgs.',21.5,26,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(72,'Mozzarella di Giovanni',14,4,'24 - 200 g pkgs.',34.8,14,0,0,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(73,'Röd Kaviar',17,8,'24 - 150 g jars',15,101,0,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(74,'Longlife Tofu',4,7,'5 kg pkg.',10,4,20,5,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(75,'Rhönbräu Klosterbier',12,1,'24 - 0.5 l bottles',7.75,125,0,25,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(76,'Lakkalikööri',23,1,'500 ml',18,57,0,20,0);

INSERT INTO Products(ProductID,ProductName,SupplierID,CategoryID,QuantityPerUnit,UnitPrice,UnitsInStock,UnitsOnOrder,ReorderLevel,Discontinued) VALUES(77,'Original Frankfurter grüne Soße',12,2,'12 boxes',13,32,0,15,0);

Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10248,'VINET',5,to_timestamp('04-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,32.38,'Vins et alcools Chevalier','59 rue de l''Abbaye','Reims','Test','51100','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10249,'TOMSP',6,to_timestamp('05-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,11.61,'Toms Spezialitäten','Luisenstr. 48','Münster',null,'44087','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10250,'HANAR',4,to_timestamp('08-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,65.83,'Hanari Carnes','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10251,'VICTE',3,to_timestamp('08-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,41.34,'Victuailles en stock','2, rue du Commerce','Lyon',null,'69004','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10252,'SUPRD',4,to_timestamp('09-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,51.3,'Suprêmes délices','Boulevard Tirou, 255','Charleroi',null,'B-6000','Belgium');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10253,'HANAR',3,to_timestamp('10-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,58.17,'Hanari Carnes','Rua do Paço, 67','Rio de Janeiro','RJ','05454-876','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10254,'CHOPS',5,to_timestamp('11-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,22.98,'Chop-suey Chinese','Hauptstr. 31','Bern',null,'3012','Switzerland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10255,'RICSU',9,to_timestamp('12-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,148.33,'Richter Supermarkt','Starenweg 5','Genève',null,'1204','Switzerland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10256,'WELLI',3,to_timestamp('15-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,13.97,'Wellington Importadora','Rua do Mercado, 12','Resende','SP','08737-363','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10257,'HILAA',4,to_timestamp('16-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,81.91,'HILARION-Abastos','Carrera 22 con Ave. Carlos Soublette #8-35','San Cristóbal','Táchira','5022','Venezuela');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10258,'ERNSH',1,to_timestamp('17-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,140.51,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10259,'CENTC',4,to_timestamp('18-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.25,'Centro comercial Moctezuma','Sierras de Granada 9993','México D.F.',null,'05022','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10260,'OTTIK',4,to_timestamp('19-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,55.09,'Ottilies Käseladen','Mehrheimerstr. 369','Köln',null,'50739','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10261,'QUEDE',4,to_timestamp('19-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.05,'Que Delícia','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10262,'RATTC',8,to_timestamp('22-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,48.29,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10263,'ERNSH',9,to_timestamp('23-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,146.06,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10264,'FOLKO',6,to_timestamp('24-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.67,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10265,'BLONP',2,to_timestamp('25-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,55.28,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10266,'WARTH',3,to_timestamp('26-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,25.73,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10267,'FRANK',4,to_timestamp('29-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,208.58,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10268,'GROSR',8,to_timestamp('30-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,66.29,'GROSELLA-Restaurante','5ª Ave. Los Palos Grandes','Caracas','DF','1081','Venezuela');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10269,'WHITC',5,to_timestamp('31-JUL-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,4.56,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10270,'WARTH',1,to_timestamp('01-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,136.54,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10271,'SPLIR',6,to_timestamp('01-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,4.54,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10272,'RATTC',6,to_timestamp('02-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,98.03,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10273,'QUICK',3,to_timestamp('05-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,76.07,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10274,'VINET',6,to_timestamp('06-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,6.01,'Vins et alcools Chevalier','59 rue de l''Abbaye','Reims',null,'51100','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10275,'MAGAA',1,to_timestamp('07-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,26.93,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',null,'24100','Italy');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10276,'TORTU',8,to_timestamp('08-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,13.84,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10277,'MORGK',2,to_timestamp('09-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,125.77,'Morgenstern Gesundkost','Heerstr. 22','Leipzig',null,'04179','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10278,'BERGS',8,to_timestamp('12-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,92.69,'Berglunds snabbköp','Berguvsvägen  8','Luleå',null,'S-958 22','Sweden');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10279,'LEHMS',8,to_timestamp('13-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,25.83,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10280,'BERGS',2,to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,8.98,'Berglunds snabbköp','Berguvsvägen  8','Luleå',null,'S-958 22','Sweden');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10281,'ROMEY',4,to_timestamp('14-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,2.94,'Romero y tomillo','Gran Vía, 1','Madrid',null,'28001','Spain');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10282,'ROMEY',4,to_timestamp('15-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.69,'Romero y tomillo','Gran Vía, 1','Madrid',null,'28001','Spain');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10283,'LILAS',3,to_timestamp('16-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,84.81,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10284,'LEHMS',4,to_timestamp('19-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,76.56,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10285,'QUICK',1,to_timestamp('20-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,76.83,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10286,'QUICK',8,to_timestamp('21-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,229.24,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10287,'RICAR',8,to_timestamp('22-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,12.76,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10288,'REGGC',4,to_timestamp('23-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,7.45,'Reggiani Caseifici','Strada Provinciale 124','Reggio Emilia',null,'42100','Italy');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10289,'BSBEV',7,to_timestamp('26-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,22.77,'B''s Beverages','Fauntleroy Circus','London',null,'EC2 5NT','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10290,'COMMI',8,to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,79.7,'Comércio Mineiro','Av. dos Lusíadas, 23','Sao Paulo','SP','05432-043','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10291,'QUEDE',6,to_timestamp('27-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,6.4,'Que Delícia','Rua da Panificadora, 12','Rio de Janeiro','RJ','02389-673','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10292,'TRADH',1,to_timestamp('28-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.35,'Tradiçao Hipermercados','Av. Inês de Castro, 414','Sao Paulo','SP','05634-030','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10293,'TORTU',1,to_timestamp('29-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,21.18,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10294,'RATTC',4,to_timestamp('30-AUG-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,147.26,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10295,'VINET',2,to_timestamp('02-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.15,'Vins et alcools Chevalier','59 rue de l''Abbaye','Reims',null,'51100','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10296,'LILAS',6,to_timestamp('03-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,0.12,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10297,'BLONP',5,to_timestamp('04-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,5.74,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10298,'HUNGO',6,to_timestamp('05-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,168.22,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10299,'RICAR',4,to_timestamp('06-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,29.76,'Ricardo Adocicados','Av. Copacabana, 267','Rio de Janeiro','RJ','02389-890','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10300,'MAGAA',2,to_timestamp('09-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,17.68,'Magazzini Alimentari Riuniti','Via Ludovico il Moro 22','Bergamo',null,'24100','Italy');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10301,'WANDK',8,to_timestamp('09-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,45.08,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10302,'SUPRD',4,to_timestamp('10-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,6.27,'Suprêmes délices','Boulevard Tirou, 255','Charleroi',null,'B-6000','Belgium');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10303,'GODOS',7,to_timestamp('11-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,107.83,'Godos Cocina Típica','C/ Romero, 33','Sevilla',null,'41101','Spain');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10304,'TORTU',1,to_timestamp('12-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,63.79,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10305,'OLDWO',8,to_timestamp('13-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,257.62,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10306,'ROMEY',1,to_timestamp('16-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,7.56,'Romero y tomillo','Gran Vía, 1','Madrid',null,'28001','Spain');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10307,'LONEP',2,to_timestamp('17-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,0.56,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10308,'ANATR',7,to_timestamp('18-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,1.61,'Ana Trujillo Emparedados y helados','Avda. de la Constitución 2222','México D.F.',null,'05021','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10309,'HUNGO',3,to_timestamp('19-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,47.3,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10310,'THEBI',8,to_timestamp('20-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,17.52,'The Big Cheese','89 Jefferson Way Suite 2','Portland','OR','97201','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10311,'DUMON',1,to_timestamp('20-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,24.69,'Du monde entier','67, rue des Cinquante Otages','Nantes',null,'44000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10312,'WANDK',2,to_timestamp('23-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,40.26,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10313,'QUICK',2,to_timestamp('24-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.96,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10314,'RATTC',1,to_timestamp('25-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,74.16,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10315,'ISLAT',4,to_timestamp('26-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,41.76,'Island Trading','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10316,'RATTC',1,to_timestamp('27-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,150.15,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10317,'LONEP',6,to_timestamp('30-SEP-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.69,'Lonesome Pine Restaurant','89 Chiaroscuro Rd.','Portland','OR','97219','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10318,'ISLAT',8,to_timestamp('01-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,4.73,'Island Trading','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10319,'TORTU',7,to_timestamp('02-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,64.5,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10320,'WARTH',5,to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,34.57,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10321,'ISLAT',3,to_timestamp('03-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.43,'Island Trading','Garden House Crowther Way','Cowes','Isle of Wight','PO31 7PJ','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10322,'PERIC',7,to_timestamp('04-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,0.4,'Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10323,'KOENE',4,to_timestamp('07-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,4.88,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10324,'SAVEA',9,to_timestamp('08-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,214.27,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10325,'KOENE',1,to_timestamp('09-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,64.86,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10326,'BOLID',4,to_timestamp('10-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,77.92,'Bólido Comidas preparadas','C/ Araquil, 67','Madrid',null,'28023','Spain');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10327,'FOLKO',2,to_timestamp('11-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,63.36,'Folk och fä HB','Åkergatan 24','Bräcke',null,'S-844 67','Sweden');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10328,'FURIB',4,to_timestamp('14-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,87.03,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10329,'SPLIR',4,to_timestamp('15-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,191.67,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10330,'LILAS',3,to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,12.75,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10331,'BONAP',9,to_timestamp('16-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,10.19,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10332,'MEREP',3,to_timestamp('17-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,52.84,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10333,'WARTH',5,to_timestamp('18-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,0.59,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10334,'VICTE',8,to_timestamp('21-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,8.56,'Victuailles en stock','2, rue du Commerce','Lyon',null,'69004','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10335,'HUNGO',7,to_timestamp('22-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,42.11,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10336,'PRINI',7,to_timestamp('23-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,15.51,'Princesa Isabel Vinhos','Estrada da saúde n. 58','Lisboa',null,'1756','Portugal');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10337,'FRANK',4,to_timestamp('24-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,108.26,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10338,'OLDWO',4,to_timestamp('25-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,84.21,'Old World Delicatessen','2743 Bering St.','Anchorage','AK','99508','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10339,'MEREP',2,to_timestamp('28-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,15.66,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10340,'BONAP',1,to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,166.31,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10341,'SIMOB',7,to_timestamp('29-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,26.78,'Simons bistro','Vinbæltet 34','Kobenhavn',null,'1734','Denmark');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10342,'FRANK',4,to_timestamp('30-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,54.83,'Frankenversand','Berliner Platz 43','München',null,'80805','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10343,'LEHMS',4,to_timestamp('31-OCT-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,110.37,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10344,'WHITC',4,to_timestamp('01-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,23.29,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10345,'QUICK',2,to_timestamp('04-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,249.06,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10346,'RATTC',3,to_timestamp('05-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,142.08,'Rattlesnake Canyon Grocery','2817 Milton Dr.','Albuquerque','NM','87110','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10347,'FAMIA',4,to_timestamp('06-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.1,'Familia Arquibaldo','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10348,'WANDK',4,to_timestamp('07-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,0.78,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10349,'SPLIR',7,to_timestamp('08-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,8.63,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10350,'LAMAI',6,to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,64.19,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10351,'ERNSH',1,to_timestamp('11-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,162.33,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10352,'FURIB',3,to_timestamp('12-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,1.3,'Furia Bacalhau e Frutos do Mar','Jardim das rosas n. 32','Lisboa',null,'1675','Portugal');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10353,'PICCO',7,to_timestamp('13-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,360.63,'Piccolo und mehr','Geislweg 14','Salzburg',null,'5020','Austria');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10354,'PERIC',8,to_timestamp('14-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,53.8,'Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10355,'AROUT',6,to_timestamp('15-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,41.95,'Around the Horn','Brook Farm Stratford St. Mary','Colchester','Essex','CO7 6JX','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10356,'WANDK',6,to_timestamp('18-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,36.71,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10357,'LILAS',1,to_timestamp('19-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,34.88,'LILA-Supermercado','Carrera 52 con Ave. Bolívar #65-98 Llano Largo','Barquisimeto','Lara','3508','Venezuela');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10358,'LAMAI',5,to_timestamp('20-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,19.64,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10359,'SEVES',5,to_timestamp('21-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,288.43,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10360,'BLONP',4,to_timestamp('22-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,131.7,'Blondel père et fils','24, place Kléber','Strasbourg',null,'67000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10361,'QUICK',1,to_timestamp('22-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,183.17,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10362,'BONAP',3,to_timestamp('25-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,96.04,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10363,'DRACD',4,to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,30.54,'Drachenblut Delikatessen','Walserweg 21','Aachen',null,'52066','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10364,'EASTC',1,to_timestamp('26-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,71.97,'Eastern Connection','35 King George','London',null,'WX3 6FW','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10365,'ANTON',3,to_timestamp('27-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('25-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,22,'Antonio Moreno Taquería','Mataderos  2312','México D.F.',null,'05023','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10366,'GALED',8,to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,10.14,'Galería del gastronómo','Rambla de Cataluña, 23','Barcelona',null,'8022','Spain');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10367,'VAFFE',7,to_timestamp('28-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,13.55,'Vaffeljernet','Smagsloget 45','Århus',null,'8200','Denmark');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10368,'ERNSH',2,to_timestamp('29-NOV-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,101.95,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10369,'SPLIR',8,to_timestamp('02-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,195.68,'Split Rail Beer & Ale','P.O. Box 555','Lander','WY','82520','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10370,'CHOPS',6,to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,1.17,'Chop-suey Chinese','Hauptstr. 31','Bern',null,'3012','Switzerland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10371,'LAMAI',1,to_timestamp('03-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('31-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,0.45,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10372,'QUEEN',5,to_timestamp('04-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,890.78,'Queen Cozinha','Alameda dos Canàrios, 891','Sao Paulo','SP','05487-020','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10373,'HUNGO',4,to_timestamp('05-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('11-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,124.12,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10374,'WOLZA',1,to_timestamp('05-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JAN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-DEC-96 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,3.94,'Wolski Zajazd','ul. Filtrowa 68','Warszawa',null,'01-012','Poland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10500,'LAMAI',6,to_timestamp('09-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('17-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,42.68,'La maison d''Asie','1 rue Alsace-Lorraine','Toulouse',null,'31000','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10501,'BLAUS',9,to_timestamp('09-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,8.85,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',null,'68306','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10502,'PERIC',2,to_timestamp('10-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('08-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,69.32,'Pericles Comidas clásicas','Calle Dr. Jorge Cash 321','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10503,'HUNGO',6,to_timestamp('11-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,16.74,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10504,'WHITC',4,to_timestamp('11-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('18-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,59.13,'White Clover Markets','1029 - 12th Ave. S.','Seattle','WA','98124','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10505,'MEREP',3,to_timestamp('14-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('12-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,7.13,'Mère Paillarde','43 rue St. Laurent','Montréal','Québec','H1J 1C3','Canada');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10506,'KOENE',9,to_timestamp('15-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,21.19,'Königlich Essen','Maubelstr. 90','Brandenburg',null,'14776','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10507,'ANTON',7,to_timestamp('15-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,47.45,'Antonio Moreno Taquería','Mataderos  2312','México D.F.',null,'05023','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10508,'OTTIK',1,to_timestamp('16-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('14-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('13-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,4.99,'Ottilies Käseladen','Mehrheimerstr. 369','Köln',null,'50739','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10509,'BLAUS',4,to_timestamp('17-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,0.15,'Blauer See Delikatessen','Forsterstr. 57','Mannheim',null,'68306','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10510,'SAVEA',6,to_timestamp('18-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,367.63,'Save-a-lot Markets','187 Suffolk Ln.','Boise','ID','83720','USA');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10511,'BONAP',4,to_timestamp('18-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('21-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,350.64,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10512,'FAMIA',7,to_timestamp('21-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('19-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('24-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,3.53,'Familia Arquibaldo','Rua Orós, 92','Sao Paulo','SP','05442-030','Brazil');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10513,'WANDK',7,to_timestamp('22-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('03-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,105.65,'Die Wandernde Kuh','Adenauerallee 900','Stuttgart',null,'70563','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10514,'ERNSH',3,to_timestamp('22-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('20-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('16-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,789.95,'Ernst Handel','Kirchgasse 6','Graz',null,'8010','Austria');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10515,'QUICK',2,to_timestamp('23-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,204.47,'QUICK-Stop','Taucherstraße 10','Cunewalde',null,'01307','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10516,'HUNGO',2,to_timestamp('24-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,62.78,'Hungry Owl All-Night Grocers','8 Johnstown Road','Cork','Co. Cork',null,'Ireland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10517,'NORTS',3,to_timestamp('24-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('22-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,32.07,'North/South','South House 300 Queensbridge','London',null,'SW7 1RZ','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10518,'TORTU',4,to_timestamp('25-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('09-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('05-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,218.15,'Tortuga Restaurante','Avda. Azteca 123','México D.F.',null,'05033','Mexico');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10519,'CHOPS',6,to_timestamp('28-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('26-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),3,91.76,'Chop-suey Chinese','Hauptstr. 31','Bern',null,'3012','Switzerland');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10520,'SANTG',7,to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,13.37,'Santé Gourmet','Erling Skakkes gate 78','Stavern',null,'4110','Norway');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10521,'CACTU',8,to_timestamp('29-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('27-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,17.22,'Cactus Comidas para llevar','Cerrito 333','Buenos Aires',null,'1010','Argentina');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10522,'LEHMS',4,to_timestamp('30-APR-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('28-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('06-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),1,45.33,'Lehmanns Marktstand','Magazinweg 7','Frankfurt a.M.',null,'60528','Germany');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10523,'SEVES',7,to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,77.63,'Seven Seas Imports','90 Wadhurst Rd.','London',null,'OX15 4NB','UK');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10524,'BERGS',1,to_timestamp('01-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('29-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('07-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,244.79,'Berglunds snabbköp','Berguvsvägen  8','Luleå',null,'S-958 22','Sweden');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10525,'BONAP',1,to_timestamp('02-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('30-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('23-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,11.06,'Bon app''','12, rue des Bouchers','Marseille',null,'13008','France');
Insert into ORDERS (ORDERID,CUSTOMERID,EMPLOYEEID,ORDERDATE,REQUIREDDATE,SHIPPEDDATE,SHIPVIA,FREIGHT,SHIPNAME,SHIPADDRESS,SHIPCITY,SHIPREGION,SHIPPOSTALCODE,SHIPCOUNTRY) values (10526,'WARTH',4,to_timestamp('05-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('02-JUN-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),to_timestamp('15-MAY-97 12.00.00.000000000 AM','DD-MON-RR HH.MI.SS.FF AM'),2,58.59,'Wartian Herkku','Torikatu 38','Oulu',null,'90110','Finland');
Insert into
	-- 1. Run to drop schema
	-- drop user TESTUSER cascade;

	-- 2. Run to create user and schema
	CREATE USER TESTUSER IDENTIFIED BY testuser
	DEFAULT TABLESPACE users
	TEMPORARY TABLESPACE temp
	QUOTA UNLIMITED ON users

	-- 3. Run to grant permissions
	GRANT "CONNECT" TO TESTUSER
	/
	GRANT DBA TO TESTUSER
	/
	GRANT "RESOURCE" TO TESTUSER
	/
	ALTER USER TESTUSER DEFAULT ROLE "CONNECT",
	DBA,
	"RESOURCE"
	/
	/* BEGIN Tables

	DataType mappings
	http://msdn.microsoft.com/en-us/library/ms151817.aspx
	http://docs.oracle.com/cd/B19306_01/gateways.102/b14270/apa.htm
	http://weblogs.sqlteam.com/jamesw/archive/2010/08/04/datatypes-translation-between-oracle-and-sql-server-part-2-number.aspx
	http://www.techonthenet.com/oracle/datatypes.php

	*/

	CREATE TABLE Employees (
	EmployeeID number(10) NOT NULL ,
	LastName varchar2 (20) NOT NULL ,
	FirstName varchar2 (10) NOT NULL ,
	Title varchar2 (30) NULL ,
	TitleOfCourtesy varchar2 (25) NULL ,
	BirthDate date NULL,
	HireDate date NULL ,
	Address varchar2 (60) NULL ,
	City varchar2 (30) NULL ,
	Region varchar2 (15) NULL ,
	PostalCode varchar2 (10) NULL ,
	Country varchar2 (15) NULL ,
	HomePhone varchar2 (24) NULL ,
	Extension varchar2 (4) NULL ,
	Photo blob NULL ,
	Notes blob NULL ,
	ReportsTo number NULL ,
	PhotoPath varchar2 (255) NULL,
	PRIMARY KEY(EmployeeID),
	CONSTRAINT FK_Employees_Employees FOREIGN KEY (ReportsTo)
	REFERENCES Employees(EmployeeID)
	--CONSTRAINT CK_Birthdate CHECK (BirthDate < SYSDATE)
	);

	CREATE INDEX EmployeesLastName ON Employees(LastName);
	CREATE INDEX EmployeesPostalCode ON Employees(PostalCode);

	CREATE TABLE Categories (
	CategoryID number(10) NOT NULL ,
	CategoryName varchar2(15) NOT NULL ,
	Description varchar2(500) NULL,
	Picture blob NULL,
	PRIMARY KEY(CategoryID)
	);

	CREATE INDEX CategoriesCategoryName ON Categories(CategoryName);


	CREATE TABLE Customers (
	CustomerID varchar2 (5) NOT NULL ,
	CompanyName varchar2 (40) NOT NULL ,
	ContactName varchar2 (30) NULL ,
	ContactTitle varchar2 (30) NULL ,
	Address varchar2 (60) NULL ,
	City varchar2 (30) NULL ,
	Region varchar2 (15) NULL ,
	PostalCode varchar2 (10) NULL ,
	Country varchar2 (15) NULL ,
	Phone varchar2 (24) NULL ,
	Fax varchar2 (24) NULL,
	PRIMARY KEY(CustomerID)
	);


	CREATE INDEX CustomersCity ON Customers(City);
	CREATE INDEX CustomersCompanyName ON Customers(CompanyName);
	CREATE INDEX CustomersPostalCode ON Customers(PostalCode);
	CREATE INDEX CustomersRegion ON Customers(Region);

	CREATE TABLE Shippers (
	ShipperID number(10) NOT NULL ,
	CompanyName varchar2 (40) NOT NULL ,
	Phone varchar2 (24) NULL,
	PRIMARY KEY(ShipperID)
	);


	CREATE TABLE Suppliers (
	SupplierID number(10) NOT NULL ,
	CompanyName varchar2 (40) NOT NULL ,
	ContactName varchar2 (30) NULL ,
	ContactTitle varchar2 (30) NULL ,
	Address varchar2 (60) NULL ,
	City varchar2 (30) NULL ,
	Region varchar2 (15) NULL ,
	PostalCode varchar2 (10) NULL ,
	Country varchar2 (15) NULL ,
	Phone varchar2 (24) NULL ,
	Fax varchar2 (24) NULL ,
	HomePage varchar2(2000) NULL,
	PRIMARY KEY(SupplierID)
	);

	CREATE INDEX SuppliersCompanyName ON Suppliers(CompanyName);
	CREATE INDEX SuppliersPostalCode ON Suppliers(PostalCode);

	CREATE TABLE Orders (
	OrderID number(10) NOT NULL ,
	CustomerID varchar2 (5) NULL ,
	EmployeeID number(10) NULL ,
	OrderDate TIMESTAMP NULL ,
	RequiredDate TIMESTAMP NULL ,
	ShippedDate TIMESTAMP NULL ,
	ShipVia number(10) NULL ,
	Freight number(19,4) NULL,
	ShipName varchar2 (40) NULL ,
	ShipAddress varchar2 (60) NULL ,
	ShipCity varchar2 (30) NULL ,
	ShipRegion varchar2 (15) NULL ,
	ShipPostalCode varchar2 (10) NULL ,
	ShipCountry varchar2 (15) NULL,
	PRIMARY KEY(OrderID),
	CONSTRAINT FK_Orders_Customers FOREIGN KEY (CustomerID)
	REFERENCES Customers(CustomerID),
	CONSTRAINT FK_Orders_Employees FOREIGN KEY (EmployeeID)
	REFERENCES Employees(EmployeeID),
	CONSTRAINT FK_Orders_Shippers FOREIGN KEY (ShipVia)
	REFERENCES Shippers(ShipperID)
	);


	CREATE INDEX OrdersCustomerID ON Orders(CustomerID);
	--CREATE INDEX OrdersCustomersOrders ON Orders(CustomerID);
	CREATE INDEX OrdersEmployeeID ON Orders(EmployeeID);
	--CREATE INDEX OrdersEmployeesOrders ON Orders(EmployeeID);
	CREATE INDEX OrdersOrderDate ON Orders(OrderDate);
	CREATE INDEX OrdersShippedDate ON Orders(ShippedDate);
	CREATE INDEX OrdersShippersOrders ON Orders(ShipVia);
	CREATE INDEX OrdersShipPostalCode ON Orders(ShipPostalCode);


	CREATE TABLE Products (
	ProductID number(10) NOT NULL,
	ProductName varchar2 (40) NOT NULL,
	SupplierID number(10) NULL,
	CategoryID number(10) NULL,
	QuantityPerUnit varchar2 (20) NULL,
	UnitPrice number(19,4) DEFAULT 0 NULL,
	UnitsInStock number(5) DEFAULT 0 NULL,
	UnitsOnOrder number(5) DEFAULT 0 NULL,
	ReorderLevel number(5) DEFAULT 0 NULL,
	Discontinued number(3) DEFAULT 0 NOT NULL ,
	PRIMARY KEY(ProductID),
	CONSTRAINT FK_Products_Categories FOREIGN KEY (CategoryID)
	REFERENCES Categories(CategoryID),
	CONSTRAINT FK_Products_Suppliers FOREIGN KEY (SupplierID)
	REFERENCES Suppliers(SupplierID),
	CONSTRAINT CK_Products_UnitPrice
	CHECK (UnitPrice >= 0),
	CONSTRAINT CK_UnitsInStock
	CHECK (UnitsInStock >= 0),
	CONSTRAINT CK_UnitsOnOrder
	CHECK (UnitsOnOrder >= 0),
	CONSTRAINT CK_ReorderLevel
	CHECK (ReorderLevel >= 0)
	);

	--CREATE INDEX ProductsCategoriesProducts ON Products(CategoryID);
	CREATE INDEX ProductsCategoryID ON Products(CategoryID);
	CREATE INDEX ProductsProductName ON Products(ProductName);
	CREATE INDEX ProductsSupplierID ON Products(SupplierID);
	--CREATE INDEX ProductsSuppliersProducts ON Products(SupplierID);

	CREATE TABLE Order_Details (
	OrderID number(10) NOT NULL ,
	ProductID number(10) NOT NULL ,
	UnitPrice number(19,4) DEFAULT 0 NOT NULL,
	Quantity number(10) DEFAULT 1 NOT NULL,
	Discount float(23) DEFAULT 0 NOT NULL,
	CONSTRAINT PK_Order_Product PRIMARY KEY(OrderID, ProductID),
	CONSTRAINT FK_Order_Details_Orders FOREIGN KEY (OrderID)
	REFERENCES Orders(OrderID),
	CONSTRAINT FK_Order_Details_Products FOREIGN KEY (ProductID)
	REFERENCES Products(ProductID),
	CONSTRAINT "CK_UnitPrice"
	CHECK (UnitPrice >= 0),
	CONSTRAINT "CK_Quantity"
	CHECK (Quantity > 0),
	CONSTRAINT "CK_Discount"
	CHECK (Discount >= 0 and (Discount <= 1))
	);

	CREATE INDEX OrderDetailsOrderID ON Order_Details(OrderID);
	--CREATE INDEX OrderDetailsOrders ON Order_Details(OrderID);
	CREATE INDEX OrderDetailsProductID ON Order_Details(ProductID);
	--CREATE INDEX OrderDetailsProducts ON Order_Details(ProductID);

	CREATE TABLE CustomerCustomerDemo(
	CustomerID varchar2(5) NOT NULL,
	CustomerTypeID varchar2(10) NOT NULL);


	CREATE TABLE CustomerDemographics(
	CustomerTypeID varchar2 (10) NOT NULL ,
	CustomerDesc varchar2(200) NULL );


	CREATE TABLE Region(
	RegionID number NOT NULL ,
	RegionDescription varchar2 (50) NOT NULL);

	CREATE TABLE Territories(
	TerritoryID varchar2 (20) NOT NULL ,
	TerritoryDescription varchar2 (50) NOT NULL ,
	RegionID number NOT NULL);

	CREATE TABLE EmployeeTerritories(
	EmployeeID number NOT NULL,
	TerritoryID varchar2 (20) NOT NULL );

	/* END Tables */


	/* BEGIN Views */

	CREATE VIEW Customer_and_Suppliers_by_City AS
	SELECT City, CompanyName, ContactName, 'Customers' TableFrom
	FROM Customers
	UNION
	SELECT City, CompanyName, ContactName, 'Suppliers'
	FROM Suppliers;
	--ORDER BY City, CompanyName

	CREATE VIEW Alphabetical_list_of_products AS
	SELECT Products.*, Categories.CategoryName
	FROM Categories, Products
	WHERE Categories.CategoryID = Products.CategoryID
	AND (((Products.Discontinued)=0));

	CREATE VIEW Current_Product_List AS
	SELECT ProductID, ProductName
	FROM Products
	WHERE (((Discontinued)=0));
	--ORDER BY Product_List.ProductName

	CREATE VIEW Orders_Qry AS
	SELECT Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate,
	Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity,
	Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,
	Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
	FROM Customers,Orders
	where Customers.CustomerID = Orders.CustomerID;

	CREATE VIEW Products_Above_Average_Price AS
	SELECT Products.ProductName, Products.UnitPrice
	FROM Products
	WHERE Products.UnitPrice>(SELECT AVG(UnitPrice) From Products);
	--ORDER BY Products.UnitPrice DESC

	CREATE VIEW Products_by_Category AS
	SELECT Categories.CategoryName, Products.ProductName, Products.QuantityPerUnit, Products.UnitsInStock, Products.Discontinued
	FROM Categories, Products
	WHERE Categories.CategoryID = Products.CategoryID
	AND Products.Discontinued <> 1;
	--ORDER BY Categories.CategoryName, Products.ProductName


	CREATE or REPLACE VIEW Quarterly_Orders AS
	SELECT DISTINCT Customers.CustomerID, Customers.CompanyName, Customers.City, Customers.Country
	FROM Customers, Orders
	WHERE Customers.CustomerID = Orders.CustomerID
	AND to_date(Orders.OrderDate, 'MM/DD/YYYY') BETWEEN to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD');

	CREATE VIEW Invoices AS
	SELECT Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode,
	Orders.ShipCountry, Orders.CustomerID, Customers.CompanyName AS CustomerName, Customers.Address, Customers.City,
	Customers.Region, Customers.PostalCode, Customers.Country,
	(FirstName\|\|' '\|\|LastName) AS Salesperson,
	Orders.OrderID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Shippers.CompanyName As ShipperName,
	Order_Details.ProductID, Products.ProductName, Order_Details.UnitPrice, Order_Details.Quantity,
	Order_Details.Discount,
	Order_Details.UnitPriceQuantity(1-Discount)/100 *100 AS ExtendedPrice, Orders.Freight
	FROM Shippers, Products, Employees, Customers, Orders, Order_Details
	where Customers.CustomerID = Orders.CustomerID
	and Employees.EmployeeID = Orders.EmployeeID
	and Orders.OrderID = Order_Details.OrderID
	and Products.ProductID = Order_Details.ProductID
	and Shippers.ShipperID = Orders.ShipVia;

	CREATE VIEW Order_Details_Extended AS
	SELECT Order_Details.OrderID, Order_Details.ProductID, Products.ProductName,
	Order_Details.UnitPrice, Order_Details.Quantity, Order_Details.Discount,
	Order_Details.UnitPriceQuantity(1-Discount)/100 * 100 AS ExtendedPrice
	FROM Products, Order_Details
	where Products.ProductID = Order_Details.ProductID;
	--ORDER BY Order Details.OrderID

	CREATE VIEW Order_Subtotals AS
	SELECT Order_Details.OrderID, Sum(Order_Details.UnitPriceQuantity(1-Discount)/100*100) AS Subtotal
	FROM Order_Details
	GROUP BY Order_Details.OrderID;

	create or replace view Product_Sales_for_1997 AS
	SELECT Categories.CategoryName, Products.ProductName,
	Sum(Order_Details.UnitPriceQuantity(1-Discount)/100*100) AS ProductSales
	FROM Categories , Products, Order_Details, Orders
	where Categories.CategoryID = Products.CategoryID
	and Orders.OrderID = Order_Details.OrderID
	and Products.ProductID = Order_Details.ProductID
	and to_date(Orders.ShippedDate, 'MM/DD/YYYY') Between to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD')
	GROUP BY Categories.CategoryName, Products.ProductName;


	CREATE VIEW Category_Sales_for_1997 AS
	SELECT Product_Sales_for_1997.CategoryName, Sum(Product_Sales_for_1997.ProductSales) AS CategorySales
	FROM Product_Sales_for_1997
	GROUP BY Product_Sales_for_1997.CategoryName;

	create or replace view Sales_by_Category AS
	SELECT Categories.CategoryID, Categories.CategoryName, Products.ProductName,
	Sum(Order_Details_Extended.ExtendedPrice) AS ProductSales
	FROM Categories, Products, Order_Details_Extended, Orders
	where Orders.OrderID = Order_Details_Extended.OrderID
	and Products.ProductID = Order_Details_Extended.ProductID
	and Categories.CategoryID = Products.CategoryID
	and to_date(Orders.OrderDate, 'MM/DD/YYYY') BETWEEN to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD')
	GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName;
	--ORDER BY Products.ProductName

	create or replace view Sales_Totals_by_Amount AS
	SELECT Order_Subtotals.Subtotal AS SaleAmount, Orders.OrderID, Customers.CompanyName, Orders.ShippedDate
	FROM Customers, Order_Subtotals, Orders
	where Orders.OrderID = Order_Subtotals.OrderID
	and Customers.CustomerID = Orders.CustomerID
	and (Order_Subtotals.Subtotal >2500) AND (to_date(Orders.ShippedDate, 'MM/DD/YYYY') BETWEEN to_date('19970101', 'YYYYMMDD') And to_date('19971231', 'YYYYMMDD'));

	CREATE VIEW Summary_of_Sales_by_Quarter AS
	SELECT Orders.ShippedDate, Orders.OrderID, Order_Subtotals.Subtotal
	FROM Orders, Order_Subtotals
	where Orders.OrderID = Order_Subtotals.OrderID
	and Orders.ShippedDate IS NOT NULL;
	--ORDER BY Orders.ShippedDate

	CREATE VIEW Summary_of_Sales_by_Year AS
	SELECT Orders.ShippedDate, Orders.OrderID, Order_Subtotals.Subtotal
	FROM Orders, Order_Subtotals
	where Orders.OrderID = Order_Subtotals.OrderID
	and Orders.ShippedDate IS NOT NULL;
	--ORDER BY Orders.ShippedDate

	/* END Views */
	CREATE OR REPLACE
	PACKAGE PKGENTLIB_ARCHITECTURE
	AS
	type CURENTLIB_ARCHITECTURE
	IS
	REF
	CURSOR;
	END PKGENTLIB_ARCHITECTURE;
	----------PKG BODY:------------------
	/
	CREATE OR REPLACE
	PACKAGE BODY PKGENTLIB_ARCHITECTURE
	AS
	BEGIN
	DBMS_OUTPUT.PUT_LINE('OUTPUT');
	END PKGENTLIB_ARCHITECTURE;
	----------------------------------
	/
	CREATE OR REPLACE
	PACKAGE TESTPACKAGE
	AS
	PROCEDURE TEST_TRANS_CUST_DETAILS (
	p_customer_id IN VARCHAR2,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE
	);
	END TESTPACKAGE;
	----------PKG BODY:------------------
	/
	CREATE OR REPLACE
	PACKAGE BODY TESTPACKAGE
	AS
	PROCEDURE TEST_TRANS_CUST_DETAILS
	(
	p_customer_id IN VARCHAR2,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE
	)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT *
	FROM Customers
	WHERE CustomerID = p_customer_id;

	END TEST_TRANS_CUST_DETAILS;
	END TESTPACKAGE;
	----------------------------------
	CREATE OR REPLACE
	PROCEDURE GetCustomersTest(
	p_customer_id IN varchar2,
	p_param_test IN varchar2,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR SELECT * FROM Customers WHERE CustomerID = p_customer_id;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE CustOrdersOrders(
	p_customer_id IN varchar2,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT OrderID,
	OrderDate,
	RequiredDate,
	ShippedDate
	FROM Orders
	WHERE CustomerID = p_customer_id
	ORDER BY OrderID;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE CustOrderHist(
	p_customer_id IN varchar2,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT ProductName, SUM(Quantity) AS Total
	FROM Products P, Order_Details OD, Orders O, Customers C
	WHERE C.CustomerID = p_customer_id
	AND C.CustomerID = O.CustomerID
	AND O.OrderID = OD.OrderID
	AND OD.ProductID = P.ProductID
	GROUP BY ProductName;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE CustOrdersDetails(
	p_order_id IN number,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT ProductName,
	ROUND(Od.UnitPrice, 2) As UnitPrice,
	Quantity,
	ROUND(Discount * 100, 0) As Discount,
	ROUND((Quantity * (1 - Discount) * Od.UnitPrice), 4) As ExtendedPrice
	FROM Products P, Order_Details Od
	WHERE Od.ProductID = P.ProductID and Od.OrderID = p_order_id;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE EmployeeSalesByCountry(
	p_begin_date IN TIMESTAMP,
	p_end_date IN TIMESTAMP,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT Employees.Country,
	Employees.LastName,
	Employees.FirstName,
	Orders.ShippedDate,
	Orders.OrderID,
	Order_Subtotals.Subtotal AS SaleAmount
	FROM Employees
	INNER JOIN
	(Orders INNER JOIN Order_Subtotals ON Orders.OrderID = Order_Subtotals.OrderID)
	ON Employees.EmployeeID = Orders.EmployeeID
	WHERE Orders.ShippedDate Between p_begin_date And p_end_date;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE SalesByYear(
	p_begin_date IN TIMESTAMP,
	p_end_date IN TIMESTAMP,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT Orders.ShippedDate,
	Orders.OrderID,
	Order_Subtotals.Subtotal,
	TO_CHAR(ShippedDate, 'YY') AS Year
	FROM Orders INNER JOIN Order_Subtotals ON Orders.OrderID = Order_Subtotals.OrderID
	WHERE Orders.ShippedDate Between p_begin_date And p_end_date;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE SalesByCategory(
	p_category_name IN varchar2,
	p_order_year IN varchar2,
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	l_order_year varchar2(4);
	BEGIN
	l_order_year := p_order_year;

	IF p_order_year != '1996' AND p_order_year != '1997' AND p_order_year != '1998' THEN
	l_order_year := '1998';
	END IF;

	OPEN cur_OUT FOR
	SELECT ProductName,
	ROUND(SUM(OD.Quantity * (1-OD.Discount) * OD.UnitPrice), 2) As TotalPurchase
	FROM Order_Details OD, Orders O, Products P, Categories C
	WHERE OD.OrderID = O.OrderID
	AND OD.ProductID = P.ProductID
	AND P.CategoryID = C.CategoryID
	AND C.CategoryName = p_category_name
	AND TO_CHAR(O.OrderDate, 'YYYY') = l_order_year
	GROUP BY ProductName
	ORDER BY ProductName;
	END;
	/
	CREATE OR REPLACE
	PROCEDURE TenMostExpensiveProducts(
	cur_OUT OUT PKGENTLIB_ARCHITECTURE.CURENTLIB_ARCHITECTURE)
	AS
	BEGIN
	OPEN cur_OUT FOR
	SELECT * FROM (
	SELECT Products.ProductName AS TenMostExpensiveProducts, Products.UnitPrice
	FROM Products
	ORDER BY Products.UnitPrice DESC)
	WHERE ROWNUM <= 10;
	END;