Sql joins database script.sql

/*    ==Scripting Parameters==

    Source Server Version : SQL Server 2016 (13.0.4001)
    Source Database Engine Edition : Microsoft SQL Server Express Edition
    Source Database Engine Type : Standalone SQL Server

    Target Server Version : SQL Server 2017
    Target Database Engine Edition : Microsoft SQL Server Standard Edition
    Target Database Engine Type : Standalone SQL Server
*/

USE [Experiments]
GO
/****** Object:  Table [dbo].[Girls]    Script Date: 2/3/2019 16:58:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Girls](
	[GirlsID] [int] IDENTITY(1,1) NOT NULL,
	[Name] [varchar](255) NULL,
	[Id] [int] NULL,
	[TypeId] [int] NULL,
PRIMARY KEY CLUSTERED 
(
	[GirlsID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[GirlType]    Script Date: 2/3/2019 16:58:14 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GirlType](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Name] [nchar](25) NULL,
	[TypeIdentity] [int] NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[Girls] ON 
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (1, N'Tana', 1, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (2, N'Jessica', 2, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (3, N'Aileen', 3, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (4, N'Camilla', 4, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (5, N'Regan', 5, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (6, N'Hillary', 6, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (7, N'Quail', 7, 4)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (8, N'Clementine', 8, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (9, N'Jeanette', 9, 4)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (10, N'Megan', 10, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (11, N'Halla', 11, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (12, N'Idona', 12, 1)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (13, N'Kirsten', 13, 4)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (14, N'Casey', 14, 1)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (15, N'Imelda', 15, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (16, N'Jasmine', 16, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (17, N'Leah', 17, 2)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (18, N'Chelsea', 18, 0)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (19, N'Quail', 19, 3)
GO
INSERT [dbo].[Girls] ([GirlsID], [Name], [Id], [TypeId]) VALUES (20, N'Teagan', 20, 2)
GO
SET IDENTITY_INSERT [dbo].[Girls] OFF
GO
SET IDENTITY_INSERT [dbo].[GirlType] ON 
GO
INSERT [dbo].[GirlType] ([Id], [Name], [TypeIdentity]) VALUES (2, N'Engineer                 ', 1)
GO
INSERT [dbo].[GirlType] ([Id], [Name], [TypeIdentity]) VALUES (3, N'General                  ', 3)
GO
INSERT [dbo].[GirlType] ([Id], [Name], [TypeIdentity]) VALUES (4, N'Queen                    ', 4)
GO
SET IDENTITY_INSERT [dbo].[GirlType] OFF
GO