CREATE TABLE [table].[Orders](
[OrderID] [int] IDENTITY(1,1) NOT NULL,
[CustomerID] [nchar](5) NULL,
[ProductType] [int] NULL,
[OrderDate] [datetime] NULL,
CONSTRAINT [PK_Orders] PRIMARY KEY
(
[OrderID] ASC
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Orders] ON
INSERT [table].[Orders] ([OrderID], [CustomerID], [ProductType],[OrderDate])
VALUES (10248, N'VINET', Apple iphone, 12/2/2002)
INSERT [table].[Orders] ([OrderID], [CustomerID], [ProductType],[OrderDate])
VALUES (10249, N'TOMSP', Gadgets, 12/3/2002))
INSERT [table].[Orders] ([OrderID], [CustomerID], [ProductType],[OrderDate])
VALUES (10250, N'HANAR', Black dress and shoes, 12/4/2002)
INSERT [table].[Orders] ([OrderID], [CustomerID], [ProductType],[OrderDate])
VALUES (10251, N'VICTE', Sony LED TV, 12/5/2002)
INSERT [table].[Orders] ([OrderID], [CustomerID], [ProductType],[OrderDate])
VALUES (10252, N'SUPRD', Gym equipements, 12/6/2002)

CREATE TABLE [table].[Customers](
[CustomerID] [nchar](5) NOT NULL,
[Name] [nvarchar](30) NULL,
[ContactTitle] [nvarchar](30) NULL,
[Place] [nvarchar](60) NULL,
CONSTRAINT [PK_Customers] PRIMARY KEY
(
[CustomerID] ASC
) ON [PRIMARY]
GO
INSERT [table].[Customers] ([CustomerID], [Name], [ContactTitle],  [Place])
VALUES (N'TOMSP', 'Maria', 'Sales Representative', 'Berlin')
INSERT [table].[Customers] ([CustomerID], [Name], [ContactTitle],  [Place])
VALUES (N'ANATR'', 'Ana', 'Owner', 'México')
INSERT [table].[Customers] ([CustomerID], [Name], [ContactTitle],  [Place])
VALUES (N'ANTON', 'Antonio', 'Owner', 'México')
INSERT [table].[Customers] ([CustomerID], [Name], [ContactTitle],  [Place])
VALUES (N'AROUT', 'Thomas Hardy', 'Sales Representative', 'London')
INSERT [table].[Customers] ([CustomerID], [Name], [ContactTitle],  [Place])
VALUES  (N'VINET', 'Christina', 'Order Administrator', Japan)
INSERT [table].[Customers] ([CustomerID], [Name], [ContactTitle],  [Place])
VALUES (N'SUPRD', 'Hanna', 'Sales Representative',Germany)

'Hanna' a 'sales representative' from 'Germany' bought 'Gym equipemnts' on '12/6/2002'