table name: categories
table name: customers
table name: employee_territories
table name: employees
table name: order_details
table name: orders
table name: products
table name: regions
table name: shippers
table name: suppliers
table name: territories
SQL Script:
USE [SQLPractice]
GO
CREATE TABLE [dbo].[categories](
[category_id] [int] NOT NULL,
[category_name] [nvarchar](50) NULL,
[description] [nvarchar](max) NULL,
CONSTRAINT [PK_categories] PRIMARY KEY CLUSTERED
(
[category_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
CREATE TABLE [dbo].[customers](
[customer_id] [nvarchar](50) NOT NULL,
[company_name] [nvarchar](50) NULL,
[contact_name] [nvarchar](50) NULL,
[contact_title] [nvarchar](50) NULL,
[address] [nvarchar](550) NULL,
[city] [nvarchar](50) NULL,
[region] [nvarchar](50) NULL,
[postal_code] [nvarchar](50) NULL,
[country] [nvarchar](50) NULL,
[phone] [nvarchar](50) NULL,
[fax] [nvarchar](50) NULL,
CONSTRAINT [PK_customers] PRIMARY KEY CLUSTERED
(
[customer_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[employee_territories](
[employee_id] [int] NULL,
[territory_id] [nvarchar](50) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[employees](
[employee_id] [int] NOT NULL,
[last_name] [nvarchar](50) NULL,
[first_name] [nvarchar](50) NULL,
[title] [nvarchar](50) NULL,
[title_of_courtesy] [nvarchar](50) NULL,
[birth_date] [date] NULL,
[hire_date] [date] NULL,
[address] [nvarchar](550) NULL,
[city] [nvarchar](50) NULL,
[region] [nvarchar](50) NULL,
[postal_code] [nvarchar](50) NULL,
[country] [nvarchar](50) NULL,
[home_phone] [nvarchar](50) NULL,
[extension] [nvarchar](50) NULL,
[reports_to] [int] NULL,
CONSTRAINT [PK_employees] PRIMARY KEY CLUSTERED
(
[employee_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[order_details](
[order_id] [int] NULL,
[product_id] [int] NULL,
[unit_price] [decimal](18, 2) NULL,
[quantity] [int] NULL,
[discount] [decimal](18, 2) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[orders](
[order_id] [int] NOT NULL,
[customer_id] [nvarchar](50) NULL,
[employee_id] [int] NULL,
[order_date] [date] NULL,
[required_date] [date] NULL,
[shipped_date] [date] NULL,
[ship_via] [int] NULL,
[freight] [decimal](18, 2) NULL,
[ship_name] [nvarchar](50) NULL,
[ship_address] [nvarchar](550) NULL,
[ship_city] [nvarchar](50) NULL,
[ship_region] [nvarchar](50) NULL,
[ship_postal_code] [nvarchar](50) NULL,
[ship_country] [nvarchar](50) NULL,
CONSTRAINT [PK_orders] PRIMARY KEY CLUSTERED
(
[order_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[products](
[product_id] [int] NOT NULL,
[product_name] [nvarchar](50) NULL,
[supplier_id] [int] NULL,
[category_id] [int] NULL,
[quantity_per_unit] [nvarchar](50) NULL,
[unit_price] [decimal](18, 2) NULL,
[units_in_stock] [int] NULL,
[units_on_order] [int] NULL,
[reorder_level] [int] NULL,
[discontinued] [int] NULL,
CONSTRAINT [PK_products] PRIMARY KEY CLUSTERED
(
[product_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[regions](
[region_id] [int] NOT NULL,
[region_description] [nvarchar](550) NULL,
CONSTRAINT [PK_regions] PRIMARY KEY CLUSTERED
(
[region_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[shippers](
[shipper_id] [int] NOT NULL,
[company_name] [nvarchar](50) NULL,
[phone] [nvarchar](50) NULL,
CONSTRAINT [PK_shippers] PRIMARY KEY CLUSTERED
(
[shipper_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[suppliers](
[supplier_id] [int] NOT NULL,
[company_name] [nvarchar](50) NULL,
[contact_name] [nvarchar](50) NULL,
[contact_title] [nvarchar](50) NULL,
[address] [nvarchar](550) NULL,
[city] [nvarchar](50) NULL,
[region] [nvarchar](50) NULL,
[postal_code] [nvarchar](50) NULL,
[country] [nvarchar](50) NULL,
[phone] [nvarchar](50) NULL,
[fax] [nvarchar](50) NULL,
[home_page] [nvarchar](50) NULL,
CONSTRAINT [PK_suppliers] PRIMARY KEY CLUSTERED
(
[supplier_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[territories](
[territory_id] [nvarchar](50) NOT NULL,
[territory_description] [nvarchar](550) NULL,
[region_id] [int] NULL,
CONSTRAINT [PK_territories] PRIMARY KEY CLUSTERED
(
[territory_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (1, N'Beverages', N'Soft drinks, coffees, teas, beers, and ales')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (2, N'Condiments', N'Sweet and savory sauces, relishes, spreads, and seasonings')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (3, N'Confections', N'Desserts, candies, and sweet breads')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (4, N'Dairy Products', N'Cheeses')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (5, N'Grains/Cereals', N'Breads, crackers, pasta, and cereal')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (6, N'Meat/Poultry', N'Prepared meats')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (7, N'Produce', N'Dried fruit and bean curd')
GO
INSERT [dbo].[categories] ([category_id], [category_name], [description]) VALUES (8, N'Seafood', N'Seaweed and fish')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'ALFKI', N'Alfreds Futterkiste', N'Maria Anders', N'Sales Representative', N'Obere Str. 57', N'Berlin', N'Western Europe', N'12209', N'Germany', N'030-0074321', N'030-0076545')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'ANATR', N'Ana Trujillo Emparedados y helados', N'Ana Trujillo', N'Owner', N'Avda. de la Constitución 2222', N'México D.F.', N'Central America', N'05021', N'Mexico', N'(5) 555-4729', N'(5) 555-3745')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'ANTON', N'Antonio Moreno Taquería', N'Antonio Moreno', N'Owner', N'Mataderos 2312', N'México D.F.', N'Central America', N'05023', N'Mexico', N'(5) 555-3932', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'AROUT', N'Around the Horn', N'Thomas Hardy', N'Sales Representative', N'120 Hanover Sq.', N'London', N'British Isles', N'WA1 1DP', N'UK', N'(171) 555-7788', N'(171) 555-6750')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BERGS', N'Berglunds snabbköp', N'Christina Berglund', N'Order Administrator', N'Berguvsvägen 8', N'Luleå', N'Northern Europe', N'S-958 22', N'Sweden', N'0921-12 34 65', N'0921-12 34 67')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BLAUS', N'Blauer See Delikatessen', N'Hanna Moos', N'Sales Representative', N'Forsterstr. 57', N'Mannheim', N'Western Europe', N'68306', N'Germany', N'0621-08460', N'0621-08924')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BLONP', N'Blondesddsl père et fils', N'Frédérique Citeaux', N'Marketing Manager', N'24, place Kléber', N'Strasbourg', N'Western Europe', N'67000', N'France', N'88.60.15.31', N'88.60.15.32')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BOLID', N'Bólido Comidas preparadas', N'Martín Sommer', N'Owner', N'C/ Araquil, 67', N'Madrid', N'Southern Europe', N'28023', N'Spain', N'(91) 555 22 82', N'(91) 555 91 99')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BONAP', N'Bon app''', N'Laurence Lebihan', N'Owner', N'12, rue des Bouchers', N'Marseille', N'Western Europe', N'13008', N'France', N'91.24.45.40', N'91.24.45.41')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BOTTM', N'Bottom-Dollar Markets', N'Elizabeth Lincoln', N'Accounting Manager', N'23 Tsawassen Blvd.', N'Tsawassen', N'North America', N'T2F 8M4', N'Canada', N'(604) 555-4729', N'(604) 555-3745')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'BSBEV', N'B''s Beverages', N'Victoria Ashworth', N'Sales Representative', N'Fauntleroy Circus', N'London', N'British Isles', N'EC2 5NT', N'UK', N'(171) 555-1212', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'CACTU', N'Cactus Comidas para llevar', N'Patricio Simpson', N'Sales Agent', N'Cerrito 333', N'Buenos Aires', N'South America', N'1010', N'Argentina', N'(1) 135-5555', N'(1) 135-4892')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'CENTC', N'Centro comercial Moctezuma', N'Francisco Chang', N'Marketing Manager', N'Sierras de Granada 9993', N'México D.F.', N'Central America', N'05022', N'Mexico', N'(5) 555-3392', N'(5) 555-7293')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'CHOPS', N'Chop-suey Chinese', N'Yang Wang', N'Owner', N'Hauptstr. 29', N'Bern', N'Western Europe', N'3012', N'Switzerland', N'0452-076545', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'COMMI', N'Comércio Mineiro', N'Pedro Afonso', N'Sales Associate', N'Av. dos Lusíadas, 23', N'Sao Paulo', N'South America', N'05432-043', N'Brazil', N'(11) 555-7647', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'CONSH', N'Consolidated Holdings', N'Elizabeth Brown', N'Sales Representative', N'Berkeley Gardens 12 Brewery', N'London', N'British Isles', N'WX1 6LT', N'UK', N'(171) 555-2282', N'(171) 555-9199')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'DRACD', N'Drachenblut Delikatessen', N'Sven Ottlieb', N'Order Administrator', N'Walserweg 21', N'Aachen', N'Western Europe', N'52066', N'Germany', N'0241-039123', N'0241-059428')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'DUMON', N'Du monde entier', N'Janine Labrune', N'Owner', N'67, rue des Cinquante Otages', N'Nantes', N'Western Europe', N'44000', N'France', N'40.67.88.88', N'40.67.89.89')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'EASTC', N'Eastern Connection', N'Ann Devon', N'Sales Agent', N'35 King George', N'London', N'British Isles', N'WX3 6FW', N'UK', N'(171) 555-0297', N'(171) 555-3373')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'ERNSH', N'Ernst Handel', N'Roland Mendel', N'Sales Manager', N'Kirchgasse 6', N'Graz', N'Western Europe', N'8010', N'Austria', N'7675-3425', N'7675-3426')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FAMIA', N'Familia Arquibaldo', N'Aria Cruz', N'Marketing Assistant', N'Rua Orós, 92', N'Sao Paulo', N'South America', N'05442-030', N'Brazil', N'(11) 555-9857', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FISSA', N'FISSA Fabrica Inter. Salchichas S.A.', N'Diego Roel', N'Accounting Manager', N'C/ Moralzarzal, 86', N'Madrid', N'Southern Europe', N'28034', N'Spain', N'(91) 555 94 44', N'(91) 555 55 93')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FOLIG', N'Folies gourmandes', N'Martine Rancé', N'Assistant Sales Agent', N'184, chaussée de Tournai', N'Lille', N'Western Europe', N'59000', N'France', N'20.16.10.16', N'20.16.10.17')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FOLKO', N'Folk och fä HB', N'Maria Larsson', N'Owner', N'Åkergatan 24', N'Bräcke', N'Northern Europe', N'S-844 67', N'Sweden', N'0695-34 67 21', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FRANK', N'Frankenversand', N'Peter Franken', N'Marketing Manager', N'Berliner Platz 43', N'München', N'Western Europe', N'80805', N'Germany', N'089-0877310', N'089-0877451')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FRANR', N'France restauration', N'Carine Schmitt', N'Marketing Manager', N'54, rue Royale', N'Nantes', N'Western Europe', N'44000', N'France', N'40.32.21.21', N'40.32.21.20')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FRANS', N'Franchi S.p.A.', N'Paolo Accorti', N'Sales Representative', N'Via Monte Bianco 34', N'Torino', N'Southern Europe', N'10100', N'Italy', N'011-4988260', N'011-4988261')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'FURIB', N'Furia Bacalhau e Frutos do Mar', N'Lino Rodriguez', N'Sales Manager', N'Jardim das rosas n. 32', N'Lisboa', N'Southern Europe', N'1675', N'Portugal', N'(1) 354-2534', N'(1) 354-2535')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'GALED', N'Galería del gastrónomo', N'Eduardo Saavedra', N'Marketing Manager', N'Rambla de Cataluña, 23', N'Barcelona', N'Southern Europe', N'08022', N'Spain', N'(93) 203 4560', N'(93) 203 4561')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'GODOS', N'Godos Cocina Típica', N'José Pedro Freyre', N'Sales Manager', N'C/ Romero, 33', N'Sevilla', N'Southern Europe', N'41101', N'Spain', N'(95) 555 82 82', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'GOURL', N'Gourmet Lanchonetes', N'André Fonseca', N'Sales Associate', N'Av. Brasil, 442', N'Campinas', N'South America', N'04876-786', N'Brazil', N'(11) 555-9482', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'GREAL', N'Great Lakes Food Market', N'Howard Snyder', N'Marketing Manager', N'2732 Baker Blvd.', N'Eugene', N'North America', N'97403', N'USA', N'(503) 555-7555', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'GROSR', N'GROSELLA-Restaurante', N'Manuel Pereira', N'Owner', N'5ª Ave. Los Palos Grandes', N'Caracas', N'South America', N'1081', N'Venezuela', N'(2) 283-2951', N'(2) 283-3397')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'HANAR', N'Hanari Carnes', N'Mario Pontes', N'Accounting Manager', N'Rua do Paço, 67', N'Rio de Janeiro', N'South America', N'05454-876', N'Brazil', N'(21) 555-0091', N'(21) 555-8765')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'HILAA', N'HILARION-Abastos', N'Carlos Hernández', N'Sales Representative', N'Carrera 22 con Ave. Carlos Soublette #8-35', N'San Cristóbal', N'South America', N'5022', N'Venezuela', N'(5) 555-1340', N'(5) 555-1948')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'HUNGC', N'Hungry Coyote Import Store', N'Yoshi Latimer', N'Sales Representative', N'City Center Plaza 516 Main St.', N'Elgin', N'North America', N'97827', N'USA', N'(503) 555-6874', N'(503) 555-2376')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'HUNGO', N'Hungry Owl All-Night Grocers', N'Patricia McKenna', N'Sales Associate', N'8 Johnstown Road', N'Cork', N'British Isles', NULL, N'Ireland', N'2967 542', N'2967 3333')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'ISLAT', N'Island Trading', N'Helen Bennett', N'Marketing Manager', N'Garden House Crowther Way', N'Cowes', N'British Isles', N'PO31 7PJ', N'UK', N'(198) 555-8888', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'KOENE', N'Königlich Essen', N'Philip Cramer', N'Sales Associate', N'Maubelstr. 90', N'Brandenburg', N'Western Europe', N'14776', N'Germany', N'0555-09876', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LACOR', N'La corne d''abondance', N'Daniel Tonini', N'Sales Representative', N'67, avenue de l''Europe', N'Versailles', N'Western Europe', N'78000', N'France', N'30.59.84.10', N'30.59.85.11')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LAMAI', N'La maison d''Asie', N'Annette Roulet', N'Sales Manager', N'1 rue Alsace-Lorraine', N'Toulouse', N'Western Europe', N'31000', N'France', N'61.77.61.10', N'61.77.61.11')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LAUGB', N'Laughing Bacchus Wine Cellars', N'Yoshi Tannamuri', N'Marketing Assistant', N'1900 Oak St.', N'Vancouver', N'North America', N'V3F 2K1', N'Canada', N'(604) 555-3392', N'(604) 555-7293')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LAZYK', N'Lazy K Kountry Store', N'John Steel', N'Marketing Manager', N'12 Orchestra Terrace', N'Walla Walla', N'North America', N'99362', N'USA', N'(509) 555-7969', N'(509) 555-6221')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LEHMS', N'Lehmanns Marktstand', N'Renate Messner', N'Sales Representative', N'Magazinweg 7', N'Frankfurt a.M.', N'Western Europe', N'60528', N'Germany', N'069-0245984', N'069-0245874')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LETSS', N'Let''s Stop N Shop', N'Jaime Yorres', N'Owner', N'87 Polk St. Suite 5', N'San Francisco', N'North America', N'94117', N'USA', N'(415) 555-5938', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LILAS', N'LILA-Supermercado', N'Carlos González', N'Accounting Manager', N'Carrera 52 con Ave. Bolívar #65-98 Llano Largo', N'Barquisimeto', N'South America', N'3508', N'Venezuela', N'(9) 331-6954', N'(9) 331-7256')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LINOD', N'LINO-Delicateses', N'Felipe Izquierdo', N'Owner', N'Ave. 5 de Mayo Porlamar', N'I. de Margarita', N'South America', N'4980', N'Venezuela', N'(8) 34-56-12', N'(8) 34-93-93')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'LONEP', N'Lonesome Pine Restaurant', N'Fran Wilson', N'Sales Manager', N'89 Chiaroscuro Rd.', N'Portland', N'North America', N'97219', N'USA', N'(503) 555-9573', N'(503) 555-9646')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'MAGAA', N'Magazzini Alimentari Riuniti', N'Giovanni Rovelli', N'Marketing Manager', N'Via Ludovico il Moro 22', N'Bergamo', N'Southern Europe', N'24100', N'Italy', N'035-640230', N'035-640231')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'MAISD', N'Maison Dewey', N'Catherine Dewey', N'Sales Agent', N'Rue Joseph-Bens 532', N'Bruxelles', N'Western Europe', N'B-1180', N'Belgium', N'(02) 201 24 67', N'(02) 201 24 68')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'MEREP', N'Mère Paillarde', N'Jean Fresnière', N'Marketing Assistant', N'43 rue St. Laurent', N'Montréal', N'North America', N'H1J 1C3', N'Canada', N'(514) 555-8054', N'(514) 555-8055')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'MORGK', N'Morgenstern Gesundkost', N'Alexander Feuer', N'Marketing Assistant', N'Heerstr. 22', N'Leipzig', N'Western Europe', N'04179', N'Germany', N'0342-023176', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'NORTS', N'North/South', N'Simon Crowther', N'Sales Associate', N'South House 300 Queensbridge', N'London', N'British Isles', N'SW7 1RZ', N'UK', N'(171) 555-7733', N'(171) 555-2530')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'OCEAN', N'Océano Atlántico Ltda.', N'Yvonne Moncada', N'Sales Agent', N'Ing. Gustavo Moncada 8585 Piso 20-A', N'Buenos Aires', N'South America', N'1010', N'Argentina', N'(1) 135-5333', N'(1) 135-5535')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'OLDWO', N'Old World Delicatessen', N'Rene Phillips', N'Sales Representative', N'2743 Bering St.', N'Anchorage', N'North America', N'99508', N'USA', N'(907) 555-7584', N'(907) 555-2880')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'OTTIK', N'Ottilies Käseladen', N'Henriette Pfalzheim', N'Owner', N'Mehrheimerstr. 369', N'Köln', N'Western Europe', N'50739', N'Germany', N'0221-0644327', N'0221-0765721')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'PARIS', N'Paris spécialités', N'Marie Bertrand', N'Owner', N'265, boulevard Charonne', N'Paris', N'Western Europe', N'75012', N'France', N'(1) 42.34.22.66', N'(1) 42.34.22.77')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'PERIC', N'Pericles Comidas clásicas', N'Guillermo Fernández', N'Sales Representative', N'Calle Dr. Jorge Cash 321', N'México D.F.', N'Central America', N'05033', N'Mexico', N'(5) 552-3745', N'(5) 545-3745')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'PICCO', N'Piccolo und mehr', N'Georg Pipps', N'Sales Manager', N'Geislweg 14', N'Salzburg', N'Western Europe', N'5020', N'Austria', N'6562-9722', N'6562-9723')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'PRINI', N'Princesa Isabel Vinhos', N'Isabel de Castro', N'Sales Representative', N'Estrada da saúde n. 58', N'Lisboa', N'Southern Europe', N'1756', N'Portugal', N'(1) 356-5634', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'QUEDE', N'Que Delícia', N'Bernardo Batista', N'Accounting Manager', N'Rua da Panificadora, 12', N'Rio de Janeiro', N'South America', N'02389-673', N'Brazil', N'(21) 555-4252', N'(21) 555-4545')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'QUEEN', N'Queen Cozinha', N'Lúcia Carvalho', N'Marketing Assistant', N'Alameda dos Canàrios, 891', N'Sao Paulo', N'South America', N'05487-020', N'Brazil', N'(11) 555-1189', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'QUICK', N'QUICK-Stop', N'Horst Kloss', N'Accounting Manager', N'Taucherstraße 10', N'Cunewalde', N'Western Europe', N'01307', N'Germany', N'0372-035188', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'RANCH', N'Rancho grande', N'Sergio Gutiérrez', N'Sales Representative', N'Av. del Libertador 900', N'Buenos Aires', N'South America', N'1010', N'Argentina', N'(1) 123-5555', N'(1) 123-5556')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'RATTC', N'Rattlesnake Canyon Grocery', N'Paula Wilson', N'Assistant Sales Representative', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA', N'(505) 555-5939', N'(505) 555-3620')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'REGGC', N'Reggiani Caseifici', N'Maurizio Moroni', N'Sales Associate', N'Strada Provinciale 124', N'Reggio Emilia', N'Southern Europe', N'42100', N'Italy', N'0522-556721', N'0522-556722')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'RICAR', N'Ricardo Adocicados', N'Janete Limeira', N'Assistant Sales Agent', N'Av. Copacabana, 267', N'Rio de Janeiro', N'South America', N'02389-890', N'Brazil', N'(21) 555-3412', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'RICSU', N'Richter Supermarkt', N'Michael Holz', N'Sales Manager', N'Grenzacherweg 237', N'Genève', N'Western Europe', N'1203', N'Switzerland', N'0897-034214', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'ROMEY', N'Romero y tomillo', N'Alejandra Camino', N'Accounting Manager', N'Gran Vía, 1', N'Madrid', N'Southern Europe', N'28001', N'Spain', N'(91) 745 6200', N'(91) 745 6210')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SANTG', N'Santé Gourmet', N'Jonas Bergulfsen', N'Owner', N'Erling Skakkes gate 78', N'Stavern', N'Scandinavia', N'4110', N'Norway', N'07-98 92 35', N'07-98 92 47')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SAVEA', N'Save-a-lot Markets', N'Jose Pavarotti', N'Sales Representative', N'187 Suffolk Ln.', N'Boise', N'North America', N'83720', N'USA', N'(208) 555-8097', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SEVES', N'Seven Seas Imports', N'Hari Kumar', N'Sales Manager', N'90 Wadhurst Rd.', N'London', N'British Isles', N'OX15 4NB', N'UK', N'(171) 555-1717', N'(171) 555-5646')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SIMOB', N'Simons bistro', N'Jytte Petersen', N'Owner', N'Vinbæltet 34', N'Kobenhavn', N'Northern Europe', N'1734', N'Denmark', N'31 12 34 56', N'31 13 35 57')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SPECD', N'Spécialités du monde', N'Dominique Perrier', N'Marketing Manager', N'25, rue Lauriston', N'Paris', N'Western Europe', N'75016', N'France', N'(1) 47.55.60.10', N'(1) 47.55.60.20')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SPLIR', N'Split Rail Beer & Ale', N'Art Braunschweiger', N'Sales Manager', N'P.O. Box 555', N'Lander', N'North America', N'82520', N'USA', N'(307) 555-4680', N'(307) 555-6525')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'SUPRD', N'Suprêmes délices', N'Pascale Cartrain', N'Accounting Manager', N'Boulevard Tirou, 255', N'Charleroi', N'Western Europe', N'B-6000', N'Belgium', N'(071) 23 67 22 20', N'(071) 23 67 22 21')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'THEBI', N'The Big Cheese', N'Liz Nixon', N'Marketing Manager', N'89 Jefferson Way Suite 2', N'Portland', N'North America', N'97201', N'USA', N'(503) 555-3612', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'THECR', N'The Cracker Box', N'Liu Wong', N'Marketing Assistant', N'55 Grizzly Peak Rd.', N'Butte', N'North America', N'59801', N'USA', N'(406) 555-5834', N'(406) 555-8083')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'TOMSP', N'Toms Spezialitäten', N'Karin Josephs', N'Marketing Manager', N'Luisenstr. 48', N'Münster', N'Western Europe', N'44087', N'Germany', N'0251-031259', N'0251-035695')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'TORTU', N'Tortuga Restaurante', N'Miguel Angel Paolino', N'Owner', N'Avda. Azteca 123', N'México D.F.', N'Central America', N'05033', N'Mexico', N'(5) 555-2933', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'TRADH', N'Tradição Hipermercados', N'Anabela Domingues', N'Sales Representative', N'Av. Inês de Castro, 414', N'Sao Paulo', N'South America', N'05634-030', N'Brazil', N'(11) 555-2167', N'(11) 555-2168')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'TRAIH', N'Trail''s Head Gourmet Provisioners', N'Helvetius Nagy', N'Sales Associate', N'722 DaVinci Blvd.', N'Kirkland', N'North America', N'98034', N'USA', N'(206) 555-8257', N'(206) 555-2174')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'VAFFE', N'Vaffeljernet', N'Palle Ibsen', N'Sales Manager', N'Smagsloget 45', N'Århus', N'Northern Europe', N'8200', N'Denmark', N'86 21 32 43', N'86 22 33 44')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'Val2', N'IT', N'Val2', N'IT', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'VALON', N'IT', N'Valon Hoti', N'IT', NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'VICTE', N'Victuailles en stock', N'Mary Saveley', N'Sales Agent', N'2, rue du Commerce', N'Lyon', N'Western Europe', N'69004', N'France', N'78.32.54.86', N'78.32.54.87')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'VINET', N'Vins et alcools Chevalier', N'Paul Henriot', N'Accounting Manager', N'59 rue de l''Abbaye', N'Reims', N'Western Europe', N'51100', N'France', N'26.47.15.10', N'26.47.15.11')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'WANDK', N'Die Wandernde Kuh', N'Rita Müller', N'Sales Representative', N'Adenauerallee 900', N'Stuttgart', N'Western Europe', N'70563', N'Germany', N'0711-020361', N'0711-035428')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'WARTH', N'Wartian Herkku', N'Pirkko Koskitalo', N'Accounting Manager', N'Torikatu 38', N'Oulu', N'Scandinavia', N'90110', N'Finland', N'981-443655', N'981-443655')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'WELLI', N'Wellington Importadora', N'Paula Parente', N'Sales Manager', N'Rua do Mercado, 12', N'Resende', N'South America', N'08737-363', N'Brazil', N'(14) 555-8122', NULL)
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'WHITC', N'White Clover Markets', N'Karl Jablonski', N'Owner', N'305 - 14th Ave. S. Suite 3B', N'Seattle', N'North America', N'98128', N'USA', N'(206) 555-4112', N'(206) 555-4115')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'WILMK', N'Wilman Kala', N'Matti Karttunen', N'Owner/Marketing Assistant', N'Keskuskatu 45', N'Helsinki', N'Scandinavia', N'21240', N'Finland', N'90-224 8858', N'90-224 8858')
GO
INSERT [dbo].[customers] ([customer_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax]) VALUES (N'WOLZA', N'Wolski Zajazd', N'Zbyszek Piestrzeniewicz', N'Owner', N'ul. Filtrowa 68', N'Warszawa', N'Eastern Europe', N'01-012', N'Poland', N'(26) 642-7012', N'(26) 642-7012')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (1, N'06897')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (1, N'19713')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'01581')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'01730')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'01833')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'02116')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'02139')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'02184')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (2, N'40222')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (3, N'30346')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (3, N'31406')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (3, N'32859')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (3, N'33607')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (4, N'20852')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (4, N'27403')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (4, N'27511')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'02903')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'07960')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'08837')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'10019')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'10038')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'11747')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (5, N'14450')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (6, N'85014')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (6, N'85251')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (6, N'98004')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (6, N'98052')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (6, N'98104')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'60179')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'60601')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'80202')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'80909')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'90405')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'94025')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'94105')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'95008')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'95054')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (7, N'95060')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (8, N'19428')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (8, N'44122')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (8, N'45839')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (8, N'53404')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'03049')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'03801')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'48075')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'48084')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'48304')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'55113')
GO
INSERT [dbo].[employee_territories] ([employee_id], [territory_id]) VALUES (9, N'55439')
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10248, 11, CAST(14.00 AS Decimal(18, 2)), 12, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10248, 42, CAST(9.80 AS Decimal(18, 2)), 10, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10248, 72, CAST(34.80 AS Decimal(18, 2)), 5, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10249, 14, CAST(18.60 AS Decimal(18, 2)), 9, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10249, 51, CAST(42.40 AS Decimal(18, 2)), 40, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10250, 41, CAST(7.70 AS Decimal(18, 2)), 10, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10250, 51, CAST(42.40 AS Decimal(18, 2)), 35, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10250, 65, CAST(16.80 AS Decimal(18, 2)), 15, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10251, 22, CAST(16.80 AS Decimal(18, 2)), 6, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10251, 57, CAST(15.60 AS Decimal(18, 2)), 15, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10251, 65, CAST(16.80 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10252, 20, CAST(64.80 AS Decimal(18, 2)), 40, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10252, 33, CAST(2.00 AS Decimal(18, 2)), 25, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10252, 60, CAST(27.20 AS Decimal(18, 2)), 40, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10253, 31, CAST(10.00 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10253, 39, CAST(14.40 AS Decimal(18, 2)), 42, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10253, 49, CAST(16.00 AS Decimal(18, 2)), 40, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10254, 24, CAST(3.60 AS Decimal(18, 2)), 15, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10254, 55, CAST(19.20 AS Decimal(18, 2)), 21, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10254, 74, CAST(8.00 AS Decimal(18, 2)), 21, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10255, 2, CAST(15.20 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10255, 16, CAST(13.90 AS Decimal(18, 2)), 35, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10255, 36, CAST(15.20 AS Decimal(18, 2)), 25, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10255, 59, CAST(44.00 AS Decimal(18, 2)), 30, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10256, 53, CAST(26.20 AS Decimal(18, 2)), 15, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10256, 77, CAST(10.40 AS Decimal(18, 2)), 12, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10257, 27, CAST(35.10 AS Decimal(18, 2)), 25, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10257, 39, CAST(14.40 AS Decimal(18, 2)), 6, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10257, 77, CAST(10.40 AS Decimal(18, 2)), 15, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10258, 2, CAST(15.20 AS Decimal(18, 2)), 50, CAST(0.20 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10258, 5, CAST(17.00 AS Decimal(18, 2)), 65, CAST(0.20 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10258, 32, CAST(25.60 AS Decimal(18, 2)), 6, CAST(0.20 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10259, 21, CAST(8.00 AS Decimal(18, 2)), 10, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10259, 37, CAST(20.80 AS Decimal(18, 2)), 1, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10260, 41, CAST(7.70 AS Decimal(18, 2)), 16, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10260, 57, CAST(15.60 AS Decimal(18, 2)), 50, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10260, 62, CAST(39.40 AS Decimal(18, 2)), 15, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10260, 70, CAST(12.00 AS Decimal(18, 2)), 21, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10261, 21, CAST(8.00 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10261, 35, CAST(14.40 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10262, 5, CAST(17.00 AS Decimal(18, 2)), 12, CAST(0.20 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10262, 7, CAST(24.00 AS Decimal(18, 2)), 15, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10262, 56, CAST(30.40 AS Decimal(18, 2)), 2, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10263, 16, CAST(13.90 AS Decimal(18, 2)), 60, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10263, 24, CAST(3.60 AS Decimal(18, 2)), 28, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10263, 30, CAST(20.70 AS Decimal(18, 2)), 60, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10263, 74, CAST(8.00 AS Decimal(18, 2)), 36, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10264, 2, CAST(15.20 AS Decimal(18, 2)), 35, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10264, 41, CAST(7.70 AS Decimal(18, 2)), 25, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10265, 17, CAST(31.20 AS Decimal(18, 2)), 30, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10265, 70, CAST(12.00 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10266, 12, CAST(30.40 AS Decimal(18, 2)), 12, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10267, 40, CAST(14.70 AS Decimal(18, 2)), 50, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10267, 59, CAST(44.00 AS Decimal(18, 2)), 70, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10267, 76, CAST(14.40 AS Decimal(18, 2)), 15, CAST(0.15 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10268, 29, CAST(99.00 AS Decimal(18, 2)), 10, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10268, 72, CAST(27.80 AS Decimal(18, 2)), 4, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10269, 33, CAST(2.00 AS Decimal(18, 2)), 60, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10269, 72, CAST(27.80 AS Decimal(18, 2)), 20, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10270, 36, CAST(15.20 AS Decimal(18, 2)), 30, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10270, 43, CAST(36.80 AS Decimal(18, 2)), 25, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10271, 33, CAST(2.00 AS Decimal(18, 2)), 24, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10272, 20, CAST(64.80 AS Decimal(18, 2)), 6, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10272, 31, CAST(10.00 AS Decimal(18, 2)), 40, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10272, 72, CAST(27.80 AS Decimal(18, 2)), 24, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10273, 10, CAST(24.80 AS Decimal(18, 2)), 24, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10273, 31, CAST(10.00 AS Decimal(18, 2)), 15, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10273, 33, CAST(2.00 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10273, 40, CAST(14.70 AS Decimal(18, 2)), 60, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10273, 76, CAST(14.40 AS Decimal(18, 2)), 33, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10274, 71, CAST(17.20 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10274, 72, CAST(27.80 AS Decimal(18, 2)), 7, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10275, 24, CAST(3.60 AS Decimal(18, 2)), 12, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10275, 59, CAST(44.00 AS Decimal(18, 2)), 6, CAST(0.05 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10276, 10, CAST(24.80 AS Decimal(18, 2)), 15, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10276, 13, CAST(4.80 AS Decimal(18, 2)), 10, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10277, 28, CAST(36.40 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10277, 62, CAST(39.40 AS Decimal(18, 2)), 12, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10278, 44, CAST(15.50 AS Decimal(18, 2)), 16, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10278, 59, CAST(44.00 AS Decimal(18, 2)), 15, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10278, 63, CAST(35.10 AS Decimal(18, 2)), 8, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10278, 73, CAST(12.00 AS Decimal(18, 2)), 25, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10279, 17, CAST(31.20 AS Decimal(18, 2)), 15, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10280, 24, CAST(3.60 AS Decimal(18, 2)), 12, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10280, 55, CAST(19.20 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10280, 75, CAST(6.20 AS Decimal(18, 2)), 30, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10281, 19, CAST(7.30 AS Decimal(18, 2)), 1, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10281, 24, CAST(3.60 AS Decimal(18, 2)), 6, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10281, 35, CAST(14.40 AS Decimal(18, 2)), 4, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10282, 30, CAST(20.70 AS Decimal(18, 2)), 6, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10282, 57, CAST(15.60 AS Decimal(18, 2)), 2, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10283, 15, CAST(12.40 AS Decimal(18, 2)), 20, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10283, 19, CAST(7.30 AS Decimal(18, 2)), 18, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10283, 60, CAST(27.20 AS Decimal(18, 2)), 35, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10283, 72, CAST(27.80 AS Decimal(18, 2)), 3, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10284, 27, CAST(35.10 AS Decimal(18, 2)), 15, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10284, 44, CAST(15.50 AS Decimal(18, 2)), 21, CAST(0.00 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10284, 60, CAST(27.20 AS Decimal(18, 2)), 20, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10284, 67, CAST(11.20 AS Decimal(18, 2)), 5, CAST(0.25 AS Decimal(18, 2)))
GO
INSERT [dbo].[order_details] ([order_id], [product_id], [unit_price], [quantity], [discount]) VALUES (10285, 1, CAST(14.40 AS Decimal(18, 2)), 45, CAST(0.20 AS Decimal(18, 2)))
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10248, N'VINET', 5, CAST(N'2016-07-04' AS Date), CAST(N'2016-08-01' AS Date), CAST(N'2016-07-16' AS Date), 3, CAST(32.38 AS Decimal(18, 2)), N'Vins et alcools Chevalier', N'59 rue de l-Abbaye', N'Reims', N'Western Europe', N'51100', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10249, N'TOMSP', 6, CAST(N'2016-07-05' AS Date), CAST(N'2016-08-16' AS Date), CAST(N'2016-07-10' AS Date), 1, CAST(11.61 AS Decimal(18, 2)), N'Toms Spezialitäten', N'Luisenstr. 48', N'Münster', N'Western Europe', N'44087', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10250, N'HANAR', 4, CAST(N'2016-07-08' AS Date), CAST(N'2016-08-05' AS Date), CAST(N'2016-07-12' AS Date), 2, CAST(65.83 AS Decimal(18, 2)), N'Hanari Carnes', N'Rua do Paço, 67', N'Rio de Janeiro', N'South America', N'05454-876', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10251, N'VICTE', 3, CAST(N'2016-07-08' AS Date), CAST(N'2016-08-05' AS Date), CAST(N'2016-07-15' AS Date), 1, CAST(41.34 AS Decimal(18, 2)), N'Victuailles en stock', N'2, rue du Commerce', N'Lyon', N'Western Europe', N'69004', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10252, N'SUPRD', 4, CAST(N'2016-07-09' AS Date), CAST(N'2016-08-06' AS Date), CAST(N'2016-07-11' AS Date), 2, CAST(51.30 AS Decimal(18, 2)), N'Suprêmes délices', N'Boulevard Tirou, 255', N'Charleroi', N'Western Europe', N'B-6000', N'Belgium')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10253, N'HANAR', 3, CAST(N'2016-07-10' AS Date), CAST(N'2016-07-24' AS Date), CAST(N'2016-07-16' AS Date), 2, CAST(58.17 AS Decimal(18, 2)), N'Hanari Carnes', N'Rua do Paço, 67', N'Rio de Janeiro', N'South America', N'05454-876', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10254, N'CHOPS', 5, CAST(N'2016-07-11' AS Date), CAST(N'2016-08-08' AS Date), CAST(N'2016-07-23' AS Date), 2, CAST(22.98 AS Decimal(18, 2)), N'Chop-suey Chinese', N'Hauptstr. 31', N'Bern', N'Western Europe', N'3012', N'Switzerland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10255, N'RICSU', 9, CAST(N'2016-07-12' AS Date), CAST(N'2016-08-09' AS Date), CAST(N'2016-07-15' AS Date), 3, CAST(148.33 AS Decimal(18, 2)), N'Richter Supermarkt', N'Starenweg 5', N'Genève', N'Western Europe', N'1204', N'Switzerland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10256, N'WELLI', 3, CAST(N'2016-07-15' AS Date), CAST(N'2016-08-12' AS Date), CAST(N'2016-07-17' AS Date), 2, CAST(13.97 AS Decimal(18, 2)), N'Wellington Importadora', N'Rua do Mercado, 12', N'Resende', N'South America', N'08737-363', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10257, N'HILAA', 4, CAST(N'2016-07-16' AS Date), CAST(N'2016-08-13' AS Date), CAST(N'2016-07-22' AS Date), 3, CAST(81.91 AS Decimal(18, 2)), N'HILARION-Abastos', N'Carrera 22 con Ave. Carlos Soublette #8-35', N'San Cristóbal', N'South America', N'5022', N'Venezuela')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10258, N'ERNSH', 1, CAST(N'2016-07-17' AS Date), CAST(N'2016-08-14' AS Date), CAST(N'2016-07-23' AS Date), 1, CAST(140.51 AS Decimal(18, 2)), N'Ernst Handel', N'Kirchgasse 6', N'Graz', N'Western Europe', N'8010', N'Austria')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10259, N'CENTC', 4, CAST(N'2016-07-18' AS Date), CAST(N'2016-08-15' AS Date), CAST(N'2016-07-25' AS Date), 3, CAST(3.25 AS Decimal(18, 2)), N'Centro comercial Moctezuma', N'Sierras de Granada 9993', N'México D.F.', N'Central America', N'5022', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10260, N'OTTIK', 4, CAST(N'2016-07-19' AS Date), CAST(N'2016-08-16' AS Date), CAST(N'2016-07-29' AS Date), 1, CAST(55.09 AS Decimal(18, 2)), N'Ottilies Käseladen', N'Mehrheimerstr. 369', N'Köln', N'Western Europe', N'50739', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10261, N'QUEDE', 4, CAST(N'2016-07-19' AS Date), CAST(N'2016-08-16' AS Date), CAST(N'2016-07-30' AS Date), 2, CAST(3.05 AS Decimal(18, 2)), N'Que Delícia', N'Rua da Panificadora, 12', N'Rio de Janeiro', N'South America', N'02389-673', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10262, N'RATTC', 8, CAST(N'2016-07-22' AS Date), CAST(N'2016-08-19' AS Date), CAST(N'2016-07-25' AS Date), 3, CAST(48.29 AS Decimal(18, 2)), N'Rattlesnake Canyon Grocery', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10263, N'ERNSH', 9, CAST(N'2016-07-23' AS Date), CAST(N'2016-08-20' AS Date), CAST(N'2016-07-31' AS Date), 3, CAST(146.06 AS Decimal(18, 2)), N'Ernst Handel', N'Kirchgasse 6', N'Graz', N'Western Europe', N'8010', N'Austria')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10264, N'FOLKO', 6, CAST(N'2016-07-24' AS Date), CAST(N'2016-08-21' AS Date), CAST(N'2016-08-23' AS Date), 3, CAST(3.67 AS Decimal(18, 2)), N'Folk och fä HB', N'Åkergatan 24', N'Bräcke', N'Northern Europe', N'S-844 67', N'Sweden')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10265, N'BLONP', 2, CAST(N'2016-07-25' AS Date), CAST(N'2016-08-22' AS Date), CAST(N'2016-08-12' AS Date), 1, CAST(55.28 AS Decimal(18, 2)), N'Blondel père et fils', N'24, place Kléber', N'Strasbourg', N'Western Europe', N'67000', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10266, N'WARTH', 3, CAST(N'2016-07-26' AS Date), CAST(N'2016-09-06' AS Date), CAST(N'2016-07-31' AS Date), 3, CAST(25.73 AS Decimal(18, 2)), N'Wartian Herkku', N'Torikatu 38', N'Oulu', N'Scandinavia', N'90110', N'Finland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10267, N'FRANK', 4, CAST(N'2016-07-29' AS Date), CAST(N'2016-08-26' AS Date), CAST(N'2016-08-06' AS Date), 1, CAST(208.58 AS Decimal(18, 2)), N'Frankenversand', N'Berliner Platz 43', N'München', N'Western Europe', N'80805', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10268, N'GROSR', 8, CAST(N'2016-07-30' AS Date), CAST(N'2016-08-27' AS Date), CAST(N'2016-08-02' AS Date), 3, CAST(66.29 AS Decimal(18, 2)), N'GROSELLA-Restaurante', N'5ª Ave. Los Palos Grandes', N'Caracas', N'South America', N'1081', N'Venezuela')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10269, N'WHITC', 5, CAST(N'2016-07-31' AS Date), CAST(N'2016-08-14' AS Date), CAST(N'2016-08-09' AS Date), 1, CAST(4.56 AS Decimal(18, 2)), N'White Clover Markets', N'1029 - 12th Ave. S.', N'Seattle', N'North America', N'98124', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10270, N'WARTH', 1, CAST(N'2016-08-01' AS Date), CAST(N'2016-08-29' AS Date), CAST(N'2016-08-02' AS Date), 1, CAST(136.54 AS Decimal(18, 2)), N'Wartian Herkku', N'Torikatu 38', N'Oulu', N'Scandinavia', N'90110', N'Finland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10271, N'SPLIR', 6, CAST(N'2016-08-01' AS Date), CAST(N'2016-08-29' AS Date), CAST(N'2016-08-30' AS Date), 2, CAST(4.54 AS Decimal(18, 2)), N'Split Rail Beer & Ale', N'P.O. Box 555', N'Lander', N'North America', N'82520', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10272, N'RATTC', 6, CAST(N'2016-08-02' AS Date), CAST(N'2016-08-30' AS Date), CAST(N'2016-08-06' AS Date), 2, CAST(98.03 AS Decimal(18, 2)), N'Rattlesnake Canyon Grocery', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10273, N'QUICK', 3, CAST(N'2016-08-05' AS Date), CAST(N'2016-09-02' AS Date), CAST(N'2016-08-12' AS Date), 3, CAST(76.07 AS Decimal(18, 2)), N'QUICK-Stop', N'Taucherstraße 10', N'Cunewalde', N'Western Europe', N'1307', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10274, N'VINET', 6, CAST(N'2016-08-06' AS Date), CAST(N'2016-09-03' AS Date), CAST(N'2016-08-16' AS Date), 1, CAST(6.01 AS Decimal(18, 2)), N'Vins et alcools Chevalier', N'59 rue de l-Abbaye', N'Reims', N'Western Europe', N'51100', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10275, N'MAGAA', 1, CAST(N'2016-08-07' AS Date), CAST(N'2016-09-04' AS Date), CAST(N'2016-08-09' AS Date), 1, CAST(26.93 AS Decimal(18, 2)), N'Magazzini Alimentari Riuniti', N'Via Ludovico il Moro 22', N'Bergamo', N'Southern Europe', N'24100', N'Italy')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10276, N'TORTU', 8, CAST(N'2016-08-08' AS Date), CAST(N'2016-08-22' AS Date), CAST(N'2016-08-14' AS Date), 3, CAST(13.84 AS Decimal(18, 2)), N'Tortuga Restaurante', N'Avda. Azteca 123', N'México D.F.', N'Central America', N'5033', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10277, N'MORGK', 2, CAST(N'2016-08-09' AS Date), CAST(N'2016-09-06' AS Date), CAST(N'2016-08-13' AS Date), 3, CAST(125.77 AS Decimal(18, 2)), N'Morgenstern Gesundkost', N'Heerstr. 22', N'Leipzig', N'Western Europe', N'4179', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10278, N'BERGS', 8, CAST(N'2016-08-12' AS Date), CAST(N'2016-09-09' AS Date), CAST(N'2016-08-16' AS Date), 2, CAST(92.69 AS Decimal(18, 2)), N'Berglunds snabbköp', N'Berguvsvägen 8', N'Luleå', N'Northern Europe', N'S-958 22', N'Sweden')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10279, N'LEHMS', 8, CAST(N'2016-08-13' AS Date), CAST(N'2016-09-10' AS Date), CAST(N'2016-08-16' AS Date), 2, CAST(25.83 AS Decimal(18, 2)), N'Lehmanns Marktstand', N'Magazinweg 7', N'Frankfurt a.M.', N'Western Europe', N'60528', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10280, N'BERGS', 2, CAST(N'2016-08-14' AS Date), CAST(N'2016-09-11' AS Date), CAST(N'2016-09-12' AS Date), 1, CAST(8.98 AS Decimal(18, 2)), N'Berglunds snabbköp', N'Berguvsvägen 8', N'Luleå', N'Northern Europe', N'S-958 22', N'Sweden')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10281, N'ROMEY', 4, CAST(N'2016-08-14' AS Date), CAST(N'2016-08-28' AS Date), CAST(N'2016-08-21' AS Date), 1, CAST(2.94 AS Decimal(18, 2)), N'Romero y tomillo', N'Gran Vía, 1', N'Madrid', N'Southern Europe', N'28001', N'Spain')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10282, N'ROMEY', 4, CAST(N'2016-08-15' AS Date), CAST(N'2016-09-12' AS Date), CAST(N'2016-08-21' AS Date), 1, CAST(12.69 AS Decimal(18, 2)), N'Romero y tomillo', N'Gran Vía, 1', N'Madrid', N'Southern Europe', N'28001', N'Spain')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10283, N'LILAS', 3, CAST(N'2016-08-16' AS Date), CAST(N'2016-09-13' AS Date), CAST(N'2016-08-23' AS Date), 3, CAST(84.81 AS Decimal(18, 2)), N'LILA-Supermercado', N'Carrera 52 con Ave. Bolívar #65-98 Llano Largo', N'Barquisimeto', N'South America', N'3508', N'Venezuela')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10284, N'LEHMS', 4, CAST(N'2016-08-19' AS Date), CAST(N'2016-09-16' AS Date), CAST(N'2016-08-27' AS Date), 1, CAST(76.56 AS Decimal(18, 2)), N'Lehmanns Marktstand', N'Magazinweg 7', N'Frankfurt a.M.', N'Western Europe', N'60528', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10285, N'QUICK', 1, CAST(N'2016-08-20' AS Date), CAST(N'2016-09-17' AS Date), CAST(N'2016-08-26' AS Date), 2, CAST(76.83 AS Decimal(18, 2)), N'QUICK-Stop', N'Taucherstraße 10', N'Cunewalde', N'Western Europe', N'1307', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10286, N'QUICK', 8, CAST(N'2016-08-21' AS Date), CAST(N'2016-09-18' AS Date), CAST(N'2016-08-30' AS Date), 3, CAST(229.24 AS Decimal(18, 2)), N'QUICK-Stop', N'Taucherstraße 10', N'Cunewalde', N'Western Europe', N'1307', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10287, N'RICAR', 8, CAST(N'2016-08-22' AS Date), CAST(N'2016-09-19' AS Date), CAST(N'2016-08-28' AS Date), 3, CAST(12.76 AS Decimal(18, 2)), N'Ricardo Adocicados', N'Av. Copacabana, 267', N'Rio de Janeiro', N'South America', N'02389-890', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10288, N'REGGC', 4, CAST(N'2016-08-23' AS Date), CAST(N'2016-09-20' AS Date), CAST(N'2016-09-03' AS Date), 1, CAST(7.45 AS Decimal(18, 2)), N'Reggiani Caseifici', N'Strada Provinciale 124', N'Reggio Emilia', N'Southern Europe', N'42100', N'Italy')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10289, N'BSBEV', 7, CAST(N'2016-08-26' AS Date), CAST(N'2016-09-23' AS Date), CAST(N'2016-08-28' AS Date), 3, CAST(22.77 AS Decimal(18, 2)), N'B-s Beverages', N'Fauntleroy Circus', N'London', N'British Isles', N'EC2 5NT', N'UK')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10290, N'COMMI', 8, CAST(N'2016-08-27' AS Date), CAST(N'2016-09-24' AS Date), CAST(N'2016-09-03' AS Date), 1, CAST(79.70 AS Decimal(18, 2)), N'Comércio Mineiro', N'Av. dos Lusíadas, 23', N'Sao Paulo', N'South America', N'05432-043', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10291, N'QUEDE', 6, CAST(N'2016-08-27' AS Date), CAST(N'2016-09-24' AS Date), CAST(N'2016-09-04' AS Date), 2, CAST(6.40 AS Decimal(18, 2)), N'Que Delícia', N'Rua da Panificadora, 12', N'Rio de Janeiro', N'South America', N'02389-673', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10292, N'TRADH', 1, CAST(N'2016-08-28' AS Date), CAST(N'2016-09-25' AS Date), CAST(N'2016-09-02' AS Date), 2, CAST(1.35 AS Decimal(18, 2)), N'Tradiçao Hipermercados', N'Av. Inês de Castro, 414', N'Sao Paulo', N'South America', N'05634-030', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10293, N'TORTU', 1, CAST(N'2016-08-29' AS Date), CAST(N'2016-09-26' AS Date), CAST(N'2016-09-11' AS Date), 3, CAST(21.18 AS Decimal(18, 2)), N'Tortuga Restaurante', N'Avda. Azteca 123', N'México D.F.', N'Central America', N'5033', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10294, N'RATTC', 4, CAST(N'2016-08-30' AS Date), CAST(N'2016-09-27' AS Date), CAST(N'2016-09-05' AS Date), 2, CAST(147.26 AS Decimal(18, 2)), N'Rattlesnake Canyon Grocery', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10295, N'VINET', 2, CAST(N'2016-09-02' AS Date), CAST(N'2016-09-30' AS Date), CAST(N'2016-09-10' AS Date), 2, CAST(1.15 AS Decimal(18, 2)), N'Vins et alcools Chevalier', N'59 rue de l-Abbaye', N'Reims', N'Western Europe', N'51100', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10296, N'LILAS', 6, CAST(N'2016-09-03' AS Date), CAST(N'2016-10-01' AS Date), CAST(N'2016-09-11' AS Date), 1, CAST(0.12 AS Decimal(18, 2)), N'LILA-Supermercado', N'Carrera 52 con Ave. Bolívar #65-98 Llano Largo', N'Barquisimeto', N'South America', N'3508', N'Venezuela')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10297, N'BLONP', 5, CAST(N'2016-09-04' AS Date), CAST(N'2016-10-16' AS Date), CAST(N'2016-09-10' AS Date), 2, CAST(5.74 AS Decimal(18, 2)), N'Blondel père et fils', N'24, place Kléber', N'Strasbourg', N'Western Europe', N'67000', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10298, N'HUNGO', 6, CAST(N'2016-09-05' AS Date), CAST(N'2016-10-03' AS Date), CAST(N'2016-09-11' AS Date), 2, CAST(168.22 AS Decimal(18, 2)), N'Hungry Owl All-Night Grocers', N'8 Johnstown Road', N'Cork', N'British Isles', NULL, N'Ireland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10299, N'RICAR', 4, CAST(N'2016-09-06' AS Date), CAST(N'2016-10-04' AS Date), CAST(N'2016-09-13' AS Date), 2, CAST(29.76 AS Decimal(18, 2)), N'Ricardo Adocicados', N'Av. Copacabana, 267', N'Rio de Janeiro', N'South America', N'02389-890', N'Brazil')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10300, N'MAGAA', 2, CAST(N'2016-09-09' AS Date), CAST(N'2016-10-07' AS Date), CAST(N'2016-09-18' AS Date), 2, CAST(17.68 AS Decimal(18, 2)), N'Magazzini Alimentari Riuniti', N'Via Ludovico il Moro 22', N'Bergamo', N'Southern Europe', N'24100', N'Italy')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10301, N'WANDK', 8, CAST(N'2016-09-09' AS Date), CAST(N'2016-10-07' AS Date), CAST(N'2016-09-17' AS Date), 2, CAST(45.08 AS Decimal(18, 2)), N'Die Wandernde Kuh', N'Adenauerallee 900', N'Stuttgart', N'Western Europe', N'70563', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10302, N'SUPRD', 4, CAST(N'2016-09-10' AS Date), CAST(N'2016-10-08' AS Date), CAST(N'2016-10-09' AS Date), 2, CAST(6.27 AS Decimal(18, 2)), N'Suprêmes délices', N'Boulevard Tirou, 255', N'Charleroi', N'Western Europe', N'B-6000', N'Belgium')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10303, N'GODOS', 7, CAST(N'2016-09-11' AS Date), CAST(N'2016-10-09' AS Date), CAST(N'2016-09-18' AS Date), 2, CAST(107.83 AS Decimal(18, 2)), N'Godos Cocina Típica', N'C/ Romero, 33', N'Sevilla', N'Southern Europe', N'41101', N'Spain')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10304, N'TORTU', 1, CAST(N'2016-09-12' AS Date), CAST(N'2016-10-10' AS Date), CAST(N'2016-09-17' AS Date), 2, CAST(63.79 AS Decimal(18, 2)), N'Tortuga Restaurante', N'Avda. Azteca 123', N'México D.F.', N'Central America', N'5033', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10305, N'OLDWO', 8, CAST(N'2016-09-13' AS Date), CAST(N'2016-10-11' AS Date), CAST(N'2016-10-09' AS Date), 3, CAST(257.62 AS Decimal(18, 2)), N'Old World Delicatessen', N'2743 Bering St.', N'Anchorage', N'North America', N'99508', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10306, N'ROMEY', 1, CAST(N'2016-09-16' AS Date), CAST(N'2016-10-14' AS Date), CAST(N'2016-09-23' AS Date), 3, CAST(7.56 AS Decimal(18, 2)), N'Romero y tomillo', N'Gran Vía, 1', N'Madrid', N'Southern Europe', N'28001', N'Spain')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10307, N'LONEP', 2, CAST(N'2016-09-17' AS Date), CAST(N'2016-10-15' AS Date), CAST(N'2016-09-25' AS Date), 2, CAST(0.56 AS Decimal(18, 2)), N'Lonesome Pine Restaurant', N'89 Chiaroscuro Rd.', N'Portland', N'North America', N'97219', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10308, N'ANATR', 7, CAST(N'2016-09-18' AS Date), CAST(N'2016-10-16' AS Date), CAST(N'2016-09-24' AS Date), 3, CAST(1.61 AS Decimal(18, 2)), N'Ana Trujillo Emparedados y helados', N'Avda. de la Constitución 2222', N'México D.F.', N'Central America', N'5021', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10309, N'HUNGO', 3, CAST(N'2016-09-19' AS Date), CAST(N'2016-10-17' AS Date), CAST(N'2016-10-23' AS Date), 1, CAST(47.30 AS Decimal(18, 2)), N'Hungry Owl All-Night Grocers', N'8 Johnstown Road', N'Cork', N'British Isles', NULL, N'Ireland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10310, N'THEBI', 8, CAST(N'2016-09-20' AS Date), CAST(N'2016-10-18' AS Date), CAST(N'2016-09-27' AS Date), 2, CAST(17.52 AS Decimal(18, 2)), N'The Big Cheese', N'89 Jefferson Way Suite 2', N'Portland', N'North America', N'97201', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10311, N'DUMON', 1, CAST(N'2016-09-20' AS Date), CAST(N'2016-10-04' AS Date), CAST(N'2016-09-26' AS Date), 3, CAST(24.69 AS Decimal(18, 2)), N'Du monde entier', N'67, rue des Cinquante Otages', N'Nantes', N'Western Europe', N'44000', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10312, N'WANDK', 2, CAST(N'2016-09-23' AS Date), CAST(N'2016-10-21' AS Date), CAST(N'2016-10-03' AS Date), 2, CAST(40.26 AS Decimal(18, 2)), N'Die Wandernde Kuh', N'Adenauerallee 900', N'Stuttgart', N'Western Europe', N'70563', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10313, N'QUICK', 2, CAST(N'2016-09-24' AS Date), CAST(N'2016-10-22' AS Date), CAST(N'2016-10-04' AS Date), 2, CAST(1.96 AS Decimal(18, 2)), N'QUICK-Stop', N'Taucherstraße 10', N'Cunewalde', N'Western Europe', N'1307', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10314, N'RATTC', 1, CAST(N'2016-09-25' AS Date), CAST(N'2016-10-23' AS Date), CAST(N'2016-10-04' AS Date), 2, CAST(74.16 AS Decimal(18, 2)), N'Rattlesnake Canyon Grocery', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10315, N'ISLAT', 4, CAST(N'2016-09-26' AS Date), CAST(N'2016-10-24' AS Date), CAST(N'2016-10-03' AS Date), 2, CAST(41.76 AS Decimal(18, 2)), N'Island Trading', N'Garden House Crowther Way', N'Cowes', N'British Isles', N'PO31 7PJ', N'UK')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10316, N'RATTC', 1, CAST(N'2016-09-27' AS Date), CAST(N'2016-10-25' AS Date), CAST(N'2016-10-08' AS Date), 3, CAST(150.15 AS Decimal(18, 2)), N'Rattlesnake Canyon Grocery', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10317, N'LONEP', 6, CAST(N'2016-09-30' AS Date), CAST(N'2016-10-28' AS Date), CAST(N'2016-10-10' AS Date), 1, CAST(12.69 AS Decimal(18, 2)), N'Lonesome Pine Restaurant', N'89 Chiaroscuro Rd.', N'Portland', N'North America', N'97219', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10318, N'ISLAT', 8, CAST(N'2016-10-01' AS Date), CAST(N'2016-10-29' AS Date), CAST(N'2016-10-04' AS Date), 2, CAST(4.73 AS Decimal(18, 2)), N'Island Trading', N'Garden House Crowther Way', N'Cowes', N'British Isles', N'PO31 7PJ', N'UK')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10319, N'TORTU', 7, CAST(N'2016-10-02' AS Date), CAST(N'2016-10-30' AS Date), CAST(N'2016-10-11' AS Date), 3, CAST(64.50 AS Decimal(18, 2)), N'Tortuga Restaurante', N'Avda. Azteca 123', N'México D.F.', N'Central America', N'5033', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10320, N'WARTH', 5, CAST(N'2016-10-03' AS Date), CAST(N'2016-10-17' AS Date), CAST(N'2016-10-18' AS Date), 3, CAST(34.57 AS Decimal(18, 2)), N'Wartian Herkku', N'Torikatu 38', N'Oulu', N'Scandinavia', N'90110', N'Finland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10321, N'ISLAT', 3, CAST(N'2016-10-03' AS Date), CAST(N'2016-10-31' AS Date), CAST(N'2016-10-11' AS Date), 2, CAST(3.43 AS Decimal(18, 2)), N'Island Trading', N'Garden House Crowther Way', N'Cowes', N'British Isles', N'PO31 7PJ', N'UK')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10322, N'PERIC', 7, CAST(N'2016-10-04' AS Date), CAST(N'2016-11-01' AS Date), CAST(N'2016-10-23' AS Date), 3, CAST(0.40 AS Decimal(18, 2)), N'Pericles Comidas clásicas', N'Calle Dr. Jorge Cash 321', N'México D.F.', N'Central America', N'5033', N'Mexico')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10323, N'KOENE', 4, CAST(N'2016-10-07' AS Date), CAST(N'2016-11-04' AS Date), CAST(N'2016-10-14' AS Date), 1, CAST(4.88 AS Decimal(18, 2)), N'Königlich Essen', N'Maubelstr. 90', N'Brandenburg', N'Western Europe', N'14776', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10324, N'SAVEA', 9, CAST(N'2016-10-08' AS Date), CAST(N'2016-11-05' AS Date), CAST(N'2016-10-10' AS Date), 1, CAST(214.27 AS Decimal(18, 2)), N'Save-a-lot Markets', N'187 Suffolk Ln.', N'Boise', N'North America', N'83720', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10325, N'KOENE', 1, CAST(N'2016-10-09' AS Date), CAST(N'2016-10-23' AS Date), CAST(N'2016-10-14' AS Date), 3, CAST(64.86 AS Decimal(18, 2)), N'Königlich Essen', N'Maubelstr. 90', N'Brandenburg', N'Western Europe', N'14776', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10326, N'BOLID', 4, CAST(N'2016-10-10' AS Date), CAST(N'2016-11-07' AS Date), CAST(N'2016-10-14' AS Date), 2, CAST(77.92 AS Decimal(18, 2)), N'Bólido Comidas preparadas', N'C/ Araquil, 67', N'Madrid', N'Southern Europe', N'28023', N'Spain')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10327, N'FOLKO', 2, CAST(N'2016-10-11' AS Date), CAST(N'2016-11-08' AS Date), CAST(N'2016-10-14' AS Date), 1, CAST(63.36 AS Decimal(18, 2)), N'Folk och fä HB', N'Åkergatan 24', N'Bräcke', N'Northern Europe', N'S-844 67', N'Sweden')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10328, N'FURIB', 4, CAST(N'2016-10-14' AS Date), CAST(N'2016-11-11' AS Date), CAST(N'2016-10-17' AS Date), 3, CAST(87.03 AS Decimal(18, 2)), N'Furia Bacalhau e Frutos do Mar', N'Jardim das rosas n. 32', N'Lisboa', N'Southern Europe', N'1675', N'Portugal')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10329, N'SPLIR', 4, CAST(N'2016-10-15' AS Date), CAST(N'2016-11-26' AS Date), CAST(N'2016-10-23' AS Date), 2, CAST(191.67 AS Decimal(18, 2)), N'Split Rail Beer & Ale', N'P.O. Box 555', N'Lander', N'North America', N'82520', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10330, N'LILAS', 3, CAST(N'2016-10-16' AS Date), CAST(N'2016-11-13' AS Date), CAST(N'2016-10-28' AS Date), 1, CAST(12.75 AS Decimal(18, 2)), N'LILA-Supermercado', N'Carrera 52 con Ave. Bolívar #65-98 Llano Largo', N'Barquisimeto', N'South America', N'3508', N'Venezuela')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10331, N'BONAP', 9, CAST(N'2016-10-16' AS Date), CAST(N'2016-11-27' AS Date), CAST(N'2016-10-21' AS Date), 1, CAST(10.19 AS Decimal(18, 2)), N'Bon app-', N'12, rue des Bouchers', N'Marseille', N'Western Europe', N'13008', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10332, N'MEREP', 3, CAST(N'2016-10-17' AS Date), CAST(N'2016-11-28' AS Date), CAST(N'2016-10-21' AS Date), 2, CAST(52.84 AS Decimal(18, 2)), N'Mère Paillarde', N'43 rue St. Laurent', N'Montréal', N'North America', N'H1J 1C3', N'Canada')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10333, N'WARTH', 5, CAST(N'2016-10-18' AS Date), CAST(N'2016-11-15' AS Date), CAST(N'2016-10-25' AS Date), 3, CAST(0.59 AS Decimal(18, 2)), N'Wartian Herkku', N'Torikatu 38', N'Oulu', N'Scandinavia', N'90110', N'Finland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10334, N'VICTE', 8, CAST(N'2016-10-21' AS Date), CAST(N'2016-11-18' AS Date), CAST(N'2016-10-28' AS Date), 2, CAST(8.56 AS Decimal(18, 2)), N'Victuailles en stock', N'2, rue du Commerce', N'Lyon', N'Western Europe', N'69004', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10335, N'HUNGO', 7, CAST(N'2016-10-22' AS Date), CAST(N'2016-11-19' AS Date), CAST(N'2016-10-24' AS Date), 2, CAST(42.11 AS Decimal(18, 2)), N'Hungry Owl All-Night Grocers', N'8 Johnstown Road', N'Cork', N'British Isles', NULL, N'Ireland')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10336, N'PRINI', 7, CAST(N'2016-10-23' AS Date), CAST(N'2016-11-20' AS Date), CAST(N'2016-10-25' AS Date), 2, CAST(15.51 AS Decimal(18, 2)), N'Princesa Isabel Vinhos', N'Estrada da saúde n. 58', N'Lisboa', N'Southern Europe', N'1756', N'Portugal')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10337, N'FRANK', 4, CAST(N'2016-10-24' AS Date), CAST(N'2016-11-21' AS Date), CAST(N'2016-10-29' AS Date), 3, CAST(108.26 AS Decimal(18, 2)), N'Frankenversand', N'Berliner Platz 43', N'München', N'Western Europe', N'80805', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10338, N'OLDWO', 4, CAST(N'2016-10-25' AS Date), CAST(N'2016-11-22' AS Date), CAST(N'2016-10-29' AS Date), 3, CAST(84.21 AS Decimal(18, 2)), N'Old World Delicatessen', N'2743 Bering St.', N'Anchorage', N'North America', N'99508', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10339, N'MEREP', 2, CAST(N'2016-10-28' AS Date), CAST(N'2016-11-25' AS Date), CAST(N'2016-11-04' AS Date), 2, CAST(15.66 AS Decimal(18, 2)), N'Mère Paillarde', N'43 rue St. Laurent', N'Montréal', N'North America', N'H1J 1C3', N'Canada')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10340, N'BONAP', 1, CAST(N'2016-10-29' AS Date), CAST(N'2016-11-26' AS Date), CAST(N'2016-11-08' AS Date), 3, CAST(166.31 AS Decimal(18, 2)), N'Bon app-', N'12, rue des Bouchers', N'Marseille', N'Western Europe', N'13008', N'France')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10341, N'SIMOB', 7, CAST(N'2016-10-29' AS Date), CAST(N'2016-11-26' AS Date), CAST(N'2016-11-05' AS Date), 3, CAST(26.78 AS Decimal(18, 2)), N'Simons bistro', N'Vinbæltet 34', N'Kobenhavn', N'Northern Europe', N'1734', N'Denmark')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10342, N'FRANK', 4, CAST(N'2016-10-30' AS Date), CAST(N'2016-11-13' AS Date), CAST(N'2016-11-04' AS Date), 2, CAST(54.83 AS Decimal(18, 2)), N'Frankenversand', N'Berliner Platz 43', N'München', N'Western Europe', N'80805', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10343, N'LEHMS', 4, CAST(N'2016-10-31' AS Date), CAST(N'2016-11-28' AS Date), CAST(N'2016-11-06' AS Date), 1, CAST(110.37 AS Decimal(18, 2)), N'Lehmanns Marktstand', N'Magazinweg 7', N'Frankfurt a.M.', N'Western Europe', N'60528', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10344, N'WHITC', 4, CAST(N'2016-11-01' AS Date), CAST(N'2016-11-29' AS Date), CAST(N'2016-11-05' AS Date), 2, CAST(23.29 AS Decimal(18, 2)), N'White Clover Markets', N'1029 - 12th Ave. S.', N'Seattle', N'North America', N'98124', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10345, N'QUICK', 2, CAST(N'2016-11-04' AS Date), CAST(N'2016-12-02' AS Date), CAST(N'2016-11-11' AS Date), 2, CAST(249.06 AS Decimal(18, 2)), N'QUICK-Stop', N'Taucherstraße 10', N'Cunewalde', N'Western Europe', N'1307', N'Germany')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10346, N'RATTC', 3, CAST(N'2016-11-05' AS Date), CAST(N'2016-12-17' AS Date), CAST(N'2016-11-08' AS Date), 3, CAST(142.08 AS Decimal(18, 2)), N'Rattlesnake Canyon Grocery', N'2817 Milton Dr.', N'Albuquerque', N'North America', N'87110', N'USA')
GO
INSERT [dbo].[orders] ([order_id], [customer_id], [employee_id], [order_date], [required_date], [shipped_date], [ship_via], [freight], [ship_name], [ship_address], [ship_city], [ship_region], [ship_postal_code], [ship_country]) VALUES (10347, N'FAMIA', 4, CAST(N'2016-11-06' AS Date), CAST(N'2016-12-04' AS Date), CAST(N'2016-11-08' AS Date), 3, CAST(3.10 AS Decimal(18, 2)), N'Familia Arquibaldo', N'Rua Orós, 92', N'Sao Paulo', N'South America', N'05442-030', N'Brazil')
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (1, N'Chai', 1, 1, N'10 boxes x 20 bags', CAST(18.00 AS Decimal(18, 2)), 39, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (2, N'Chang', 1, 1, N'24 - 12 oz bottles', CAST(19.00 AS Decimal(18, 2)), 17, 40, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (3, N'Aniseed Syrup', 1, 2, N'12 - 550 ml bottles', CAST(10.00 AS Decimal(18, 2)), 13, 70, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (4, N'Chef Anton''s Cajun Seasoning', 2, 2, N'48 - 6 oz jars', CAST(22.00 AS Decimal(18, 2)), 53, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (5, N'Chef Anton''s Gumbo Mix', 2, 2, N'36 boxes', CAST(21.35 AS Decimal(18, 2)), 0, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (6, N'Grandma''s Boysenberry Spread', 3, 2, N'12 - 8 oz jars', CAST(25.00 AS Decimal(18, 2)), 120, 0, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (7, N'Uncle Bob''s Organic Dried Pears', 3, 7, N'12 - 1 lb pkgs.', CAST(30.00 AS Decimal(18, 2)), 15, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (8, N'Northwoods Cranberry Sauce', 3, 2, N'12 - 12 oz jars', CAST(40.00 AS Decimal(18, 2)), 6, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (9, N'Mishi Kobe Niku', 4, 6, N'18 - 500 g pkgs.', CAST(97.00 AS Decimal(18, 2)), 29, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (10, N'Ikura', 4, 8, N'12 - 200 ml jars', CAST(31.00 AS Decimal(18, 2)), 31, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (11, N'Queso Cabrales', 5, 4, N'1 kg pkg.', CAST(21.00 AS Decimal(18, 2)), 22, 30, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (12, N'Queso Manchego La Pastora', 5, 4, N'10 - 500 g pkgs.', CAST(38.00 AS Decimal(18, 2)), 86, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (13, N'Konbu', 6, 8, N'2 kg box', CAST(6.00 AS Decimal(18, 2)), 24, 0, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (14, N'Tofu', 6, 7, N'40 - 100 g pkgs.', CAST(23.25 AS Decimal(18, 2)), 35, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (15, N'Genen Shouyu', 6, 2, N'24 - 250 ml bottles', CAST(15.50 AS Decimal(18, 2)), 39, 0, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (16, N'Pavlova', 7, 3, N'32 - 500 g boxes', CAST(17.45 AS Decimal(18, 2)), 29, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (17, N'Alice Mutton', 7, 6, N'20 - 1 kg tins', CAST(39.00 AS Decimal(18, 2)), 0, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (18, N'Carnarvon Tigers', 7, 8, N'16 kg pkg.', CAST(62.50 AS Decimal(18, 2)), 42, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (19, N'Teatime Chocolate Biscuits', 8, 3, N'10 boxes x 12 pieces', CAST(9.20 AS Decimal(18, 2)), 25, 0, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (20, N'Sir Rodney''s Marmalade', 8, 3, N'30 gift boxes', CAST(81.00 AS Decimal(18, 2)), 40, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (21, N'Sir Rodney''s Scones', 8, 3, N'24 pkgs. x 4 pieces', CAST(10.00 AS Decimal(18, 2)), 3, 40, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (22, N'Gustaf''s Knäckebröd', 9, 5, N'24 - 500 g pkgs.', CAST(21.00 AS Decimal(18, 2)), 104, 0, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (23, N'Tunnbröd', 9, 5, N'12 - 250 g pkgs.', CAST(9.00 AS Decimal(18, 2)), 61, 0, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (24, N'Guaraná Fantástica', 10, 1, N'12 - 355 ml cans', CAST(4.50 AS Decimal(18, 2)), 20, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (25, N'NuNuCa Nuß-Nougat-Creme', 11, 3, N'20 - 450 g glasses', CAST(14.00 AS Decimal(18, 2)), 76, 0, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (26, N'Gumbär Gummibärchen', 11, 3, N'100 - 250 g bags', CAST(31.23 AS Decimal(18, 2)), 15, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (27, N'Schoggi Schokolade', 11, 3, N'100 - 100 g pieces', CAST(43.90 AS Decimal(18, 2)), 49, 0, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (28, N'Rössle Sauerkraut', 12, 7, N'25 - 825 g cans', CAST(45.60 AS Decimal(18, 2)), 26, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (29, N'Thüringer Rostbratwurst', 12, 6, N'50 bags x 30 sausgs.', CAST(123.79 AS Decimal(18, 2)), 0, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (30, N'Nord-Ost Matjeshering', 13, 8, N'10 - 200 g glasses', CAST(25.89 AS Decimal(18, 2)), 10, 0, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (31, N'Gorgonzola Telino', 14, 4, N'12 - 100 g pkgs', CAST(12.50 AS Decimal(18, 2)), 0, 70, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (32, N'Mascarpone Fabioli', 14, 4, N'24 - 200 g pkgs.', CAST(32.00 AS Decimal(18, 2)), 9, 40, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (33, N'Geitost', 15, 4, N'500 g', CAST(2.50 AS Decimal(18, 2)), 112, 0, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (34, N'Sasquatch Ale', 16, 1, N'24 - 12 oz bottles', CAST(14.00 AS Decimal(18, 2)), 111, 0, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (35, N'Steeleye Stout', 16, 1, N'24 - 12 oz bottles', CAST(18.00 AS Decimal(18, 2)), 20, 0, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (36, N'Inlagd Sill', 17, 8, N'24 - 250 g jars', CAST(19.00 AS Decimal(18, 2)), 112, 0, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (37, N'Gravad lax', 17, 8, N'12 - 500 g pkgs.', CAST(26.00 AS Decimal(18, 2)), 11, 50, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (38, N'Côte de Blaye', 18, 1, N'12 - 75 cl bottles', CAST(263.50 AS Decimal(18, 2)), 17, 0, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (39, N'Chartreuse verte', 18, 1, N'750 cc per bottle', CAST(18.00 AS Decimal(18, 2)), 69, 0, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (40, N'Boston Crab Meat', 19, 8, N'24 - 4 oz tins', CAST(18.40 AS Decimal(18, 2)), 123, 0, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (41, N'Jack''s New England Clam Chowder', 19, 8, N'12 - 12 oz cans', CAST(9.65 AS Decimal(18, 2)), 85, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (42, N'Singaporean Hokkien Fried Mee', 20, 5, N'32 - 1 kg pkgs.', CAST(14.00 AS Decimal(18, 2)), 26, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (43, N'Ipoh Coffee', 20, 1, N'16 - 500 g tins', CAST(46.00 AS Decimal(18, 2)), 17, 10, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (44, N'Gula Malacca', 20, 2, N'20 - 2 kg bags', CAST(19.45 AS Decimal(18, 2)), 27, 0, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (45, N'Rogede sild', 21, 8, N'1k pkg.', CAST(9.50 AS Decimal(18, 2)), 5, 70, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (46, N'Spegesild', 21, 8, N'4 - 450 g glasses', CAST(12.00 AS Decimal(18, 2)), 95, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (47, N'Zaanse koeken', 22, 3, N'10 - 4 oz boxes', CAST(9.50 AS Decimal(18, 2)), 36, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (48, N'Chocolade', 22, 3, N'10 pkgs.', CAST(12.75 AS Decimal(18, 2)), 15, 70, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (49, N'Maxilaku', 23, 3, N'24 - 50 g pkgs.', CAST(20.00 AS Decimal(18, 2)), 10, 60, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (50, N'Valkoinen suklaa', 23, 3, N'12 - 100 g bars', CAST(16.25 AS Decimal(18, 2)), 65, 0, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (51, N'Manjimup Dried Apples', 24, 7, N'50 - 300 g pkgs.', CAST(53.00 AS Decimal(18, 2)), 20, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (52, N'Filo Mix', 24, 5, N'16 - 2 kg boxes', CAST(7.00 AS Decimal(18, 2)), 38, 0, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (53, N'Perth Pasties', 24, 6, N'48 pieces', CAST(32.80 AS Decimal(18, 2)), 0, 0, 0, 1)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (54, N'Tourtière', 25, 6, N'16 pies', CAST(7.45 AS Decimal(18, 2)), 21, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (55, N'Pâté chinois', 25, 6, N'24 boxes x 2 pies', CAST(24.00 AS Decimal(18, 2)), 115, 0, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (56, N'Gnocchi di nonna Alice', 26, 5, N'24 - 250 g pkgs.', CAST(38.00 AS Decimal(18, 2)), 21, 10, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (57, N'Ravioli Angelo', 26, 5, N'24 - 250 g pkgs.', CAST(19.50 AS Decimal(18, 2)), 36, 0, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (58, N'Escargots de Bourgogne', 27, 8, N'24 pieces', CAST(13.25 AS Decimal(18, 2)), 62, 0, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (59, N'Raclette Courdavault', 28, 4, N'5 kg pkg.', CAST(55.00 AS Decimal(18, 2)), 79, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (60, N'Camembert Pierrot', 28, 4, N'15 - 300 g rounds', CAST(34.00 AS Decimal(18, 2)), 19, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (61, N'Sirop d''érable', 29, 2, N'24 - 500 ml bottles', CAST(28.50 AS Decimal(18, 2)), 113, 0, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (62, N'Tarte au sucre', 29, 3, N'48 pies', CAST(49.30 AS Decimal(18, 2)), 17, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (63, N'Vegie-spread', 7, 2, N'15 - 625 g jars', CAST(43.90 AS Decimal(18, 2)), 24, 0, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (64, N'Wimmers gute Semmelknödel', 12, 5, N'20 bags x 4 pieces', CAST(33.25 AS Decimal(18, 2)), 22, 80, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (65, N'Louisiana Fiery Hot Pepper Sauce', 2, 2, N'32 - 8 oz bottles', CAST(21.05 AS Decimal(18, 2)), 76, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (66, N'Louisiana Hot Spiced Okra', 2, 2, N'24 - 8 oz jars', CAST(17.00 AS Decimal(18, 2)), 4, 100, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (67, N'Laughing Lumberjack Lager', 16, 1, N'24 - 12 oz bottles', CAST(14.00 AS Decimal(18, 2)), 52, 0, 10, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (68, N'Scottish Longbreads', 8, 3, N'10 boxes x 8 pieces', CAST(12.50 AS Decimal(18, 2)), 6, 10, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (69, N'Gudbrandsdalsost', 15, 4, N'10 kg pkg.', CAST(36.00 AS Decimal(18, 2)), 26, 0, 15, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (70, N'Outback Lager', 7, 1, N'24 - 355 ml bottles', CAST(15.00 AS Decimal(18, 2)), 15, 10, 30, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (71, N'Flotemysost', 15, 4, N'10 - 500 g pkgs.', CAST(21.50 AS Decimal(18, 2)), 26, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (72, N'Mozzarella di Giovanni', 14, 4, N'24 - 200 g pkgs.', CAST(34.80 AS Decimal(18, 2)), 14, 0, 0, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (73, N'Röd Kaviar', 17, 8, N'24 - 150 g jars', CAST(15.00 AS Decimal(18, 2)), 101, 0, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (74, N'Longlife Tofu', 4, 7, N'5 kg pkg.', CAST(10.00 AS Decimal(18, 2)), 4, 20, 5, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (75, N'Rhönbräu Klosterbier', 12, 1, N'24 - 0.5 l bottles', CAST(7.75 AS Decimal(18, 2)), 125, 0, 25, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (76, N'Lakkalikööri', 23, 1, N'500 ml', CAST(18.00 AS Decimal(18, 2)), 57, 0, 20, 0)
GO
INSERT [dbo].[products] ([product_id], [product_name], [supplier_id], [category_id], [quantity_per_unit], [unit_price], [units_in_stock], [units_on_order], [reorder_level], [discontinued]) VALUES (77, N'Original Frankfurter grüne Soße', 12, 2, N'12 boxes', CAST(13.00 AS Decimal(18, 2)), 32, 0, 15, 0)
GO
INSERT [dbo].[regions] ([region_id], [region_description]) VALUES (1, N'Eastern')
GO
INSERT [dbo].[regions] ([region_id], [region_description]) VALUES (2, N'Westerns')
GO
INSERT [dbo].[regions] ([region_id], [region_description]) VALUES (3, N'Northern')
GO
INSERT [dbo].[regions] ([region_id], [region_description]) VALUES (4, N'Southern')
GO
INSERT [dbo].[shippers] ([shipper_id], [company_name], [phone]) VALUES (1, N'Speedy Express', N'(503) 555-9831')
GO
INSERT [dbo].[shippers] ([shipper_id], [company_name], [phone]) VALUES (2, N'United Package', N'(503) 555-3199')
GO
INSERT [dbo].[shippers] ([shipper_id], [company_name], [phone]) VALUES (3, N'Federal Shipping', N'(503) 555-9931')
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (1, N'Exotic Liquids', N'Charlotte Cooper', N'Purchasing Manager', N'49 Gilbert St.', N'London', N'British Isles', N'EC1 4SD', N'UK', N'(171) 555-2222', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (2, N'New Orleans Cajun Delights', N'Shelley Burke', N'Order Administrator', N'P.O. Box 78934', N'New Orleans', N'North America', N'70117', N'USA', N'(100) 555-4822', NULL, N'#CAJUN.HTM#')
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (3, N'Grandma Kelly''s Homestead', N'Regina Murphy', N'Sales Representative', N'707 Oxford Rd.', N'Ann Arbor', N'North America', N'48104', N'USA', N'(313) 555-5735', N'(313) 555-3349', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (4, N'Tokyo Traders', N'Yoshi Nagase', N'Marketing Manager', N'9-8 Sekimai Musashino-shi', N'Tokyo', N'Eastern Asia', N'100', N'Japan', N'(03) 3555-5011', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (5, N'Cooperativa de Quesos ''Las Cabras''', N'Antonio del Valle Saavedra', N'Export Administrator', N'Calle del Rosal 4', N'Oviedo', N'Southern Europe', N'33007', N'Spain', N'(98) 598 76 54', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (7, N'Pavlova, Ltd.', N'Ian Devling', N'Marketing Manager', N'74 Rose St. Moonie Ponds', N'Melbourne', N'Victoria', N'3058', N'Australia', N'(03) 444-2343', N'(03) 444-6588', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (8, N'Specialty Biscuits, Ltd.', N'Peter Wilson', N'Sales Representative', N'29 King''s Way', N'Manchester', N'British Isles', N'M14 GSD', N'UK', N'(161) 555-4448', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (9, N'PB Knäckebröd AB', N'Lars Peterson', N'Sales Agent', N'Kaloadagatan 13', N'Göteborg', NULL, N'S-345 67', N'Sweden', N'031-987 65 43', N'031-987 65 91', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (10, N'Refrescos Americanas LTDA', N'Carlos Diaz', N'Marketing Manager', N'Av. das Americanas 12.890', N'São Paulo', N'South America', N'5442', N'Brazil', N'(11) 555 4640', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (11, N'Heli Süßwaren GmbH & Co. KG', N'Petra Winkler', N'Sales Manager', N'Tiergartenstraße 5', N'Berlin', N'Western Europe', N'10785', N'Germany', N'(010) 9984510', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (13, N'Nord-Ost-Fisch Handelsgesellschaft mbH', N'Sven Petersen', N'Coordinator Foreign Markets', N'Frahmredder 112a', N'Cuxhaven', N'Western Europe', N'27478', N'Germany', N'(04721) 8713', N'(04721) 8714', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (14, N'Formaggi Fortini s.r.l.', N'Elio Rossi', N'Sales Representative', N'Viale Dante, 75', N'Ravenna', N'Southern Europe', N'48100', N'Italy', N'(0544) 60323', N'(0544) 60603', N'#FORMAGGI.HTM#')
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (15, N'Norske Meierier', N'Beate Vileid', N'Marketing Manager', N'Hatlevegen 5', N'Sandvika', N'Scandinavia', N'1320', N'Norway', N'(0)2-953010', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (16, N'Bigfoot Breweries', N'Cheryl Saylor', N'Regional Account Rep.', N'3400 - 8th Avenue Suite 210', N'Bend', N'North America', N'97101', N'USA', N'(503) 555-9931', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (17, N'Svensk Sjöföda AB', N'Michael Björn', N'Sales Representative', N'Brovallavägen 231', N'Stockholm', N'Northern Europe', N'S-123 45', N'Sweden', N'08-123 45 67', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (18, N'Aux joyeux ecclésiastiques', N'Guylène Nodier', N'Sales Manager', N'203, Rue des Francs-Bourgeois', N'Paris', N'Western Europe', N'75004', N'France', N'(1) 03.83.00.68', N'(1) 03.83.00.62', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (19, N'New England Seafood Cannery', N'Robb Merchant', N'Wholesale Account Agent', N'Order Processing Dept. 2100 Paul Revere Blvd.', N'Boston', N'North America', N'02134', N'USA', N'(617) 555-3267', N'(617) 555-3389', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (20, N'Leka Trading', N'Chandra Leka', N'Owner', N'471 Serangoon Loop, Suite #402', N'Singapore', N'South-East Asia', N'0512', N'Singapore', N'555-8787', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (21, N'Lyngbysild', N'Niels Petersen', N'Sales Manager', N'Lyngbysild Fiskebakken 10', N'Lyngby', N'Northern Europe', N'2800', N'Denmark', N'43844108', N'43844115', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (22, N'Zaanse Snoepfabriek', N'Dirk Luchte', N'Accounting Manager', N'Verkoop Rijnweg 22', N'Zaandam', N'Northern Europe', N'9999 ZZ', N'Netherlands', N'(12345) 1212', N'(12345) 1210', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (23, N'Karkki Oy', N'Anne Heikkonen', N'Product Manager', N'Valtakatu 12', N'Lappeenranta', N'Scandinavia', N'53120', N'Finland', N'(953) 10956', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (25, N'Ma Maison', N'Jean-Guy Lauzon', N'Marketing Manager', N'2960 Rue St. Laurent', N'Montréal', N'North America', N'H1J 1C3', N'Canada', N'(514) 555-9022', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (26, N'Pasta Buttini s.r.l.', N'Giovanni Giudici', N'Order Administrator', N'Via dei Gelsomini, 153', N'Salerno', N'Southern Europe', N'84100', N'Italy', N'(089) 6547665', N'(089) 6547667', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (27, N'Escargots Nouveaux', N'Marie Delamare', N'Sales Manager', N'22, rue H. Voiron', N'Montceau', N'Western Europe', N'71300', N'France', N'85.57.00.07', NULL, NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (28, N'Gai pâturage', N'Eliane Noz', N'Sales Representative', N'Bat. B 3, rue des Alpes', N'Annecy', N'Western Europe', N'74000', N'France', N'38.76.98.06', N'38.76.98.58', NULL)
GO
INSERT [dbo].[suppliers] ([supplier_id], [company_name], [contact_name], [contact_title], [address], [city], [region], [postal_code], [country], [phone], [fax], [home_page]) VALUES (29, N'Forêts d''érables', N'Chantal Goulet', N'Accounting Manager', N'148 rue Chasseur', N'Ste-Hyacinthe', N'North America', N'J2S 7S8', N'Canada', N'(514) 555-2955', N'(514) 555-2921', NULL)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'01581', N'Westboro', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'01730', N'Bedford', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'01833', N'Georgetow', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'02116', N'Boston', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'02139', N'Cambridge', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'02184', N'Braintree', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'02903', N'Providence', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'03049', N'Hollis', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'03801', N'Portsmouth', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'06897', N'Wilton', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'07960', N'Morristown', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'08837', N'Edison', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'10019', N'New York', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'10038', N'New York', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'11747', N'Mellvile', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'14450', N'Fairport', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'19428', N'Philadelphia', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'19713', N'Neward', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'20852', N'Rockville', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'27403', N'Greensboro', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'27511', N'Cary', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'29202', N'Columbia', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'30346', N'Atlanta', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'31406', N'Savannah', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'32859', N'Orlando', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'33607', N'Tampa', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'40222', N'Louisville', 1)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'44122', N'Beachwood', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'45839', N'Findlay', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'48075', N'Southfield', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'48084', N'Troy', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'48304', N'Bloomfield Hills', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'53404', N'Racine', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'55113', N'Roseville', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'55439', N'Minneapolis', 3)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'60179', N'Hoffman Estates', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'60601', N'Chicago', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'72716', N'Bentonville', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'75234', N'Dallas', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'78759', N'Austin', 4)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'80202', N'Denver', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'80909', N'Colorado Springs', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'85014', N'Phoenix', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'85251', N'Scottsdale', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'90405', N'Santa Monica', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'94025', N'Menlo Park', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'94105', N'San Francisco', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'95008', N'Campbell', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'95054', N'Santa Clara', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'95060', N'Santa Cruz', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'98004', N'Bellevue', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'98052', N'Redmond', 2)
GO
INSERT [dbo].[territories] ([territory_id], [territory_description], [region_id]) VALUES (N'98104', N'Seattle', 2)
GO