Given the following SQL Table Schemas, your task is to generate SQL queries to answer the question. Explain how you are solving the problem in a step-by-step manner. Don't explain the generated query.

CREATE TABLE [T_Country] (
	[CountryId] INTEGER NOT NULL IDENTITY(8,1), 
	[CountryName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	CONSTRAINT [PK_T_Country] PRIMARY KEY ([CountryId])
)

CREATE TABLE [T_Location] (
	[LocationId] INTEGER NOT NULL, 
	[LocationName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, 
	[LocationDetails] VARCHAR(250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[CountryId] INTEGER NOT NULL, 
	CONSTRAINT [PK_T_Location] PRIMARY KEY ([LocationId]), 
	CONSTRAINT [FK_T_Location_T_Country] FOREIGN KEY([CountryId]) REFERENCES [T_Country] ([CountryId]) ON UPDATE CASCADE
)

CREATE TABLE [T_Department] (
	[DepartmentId] INTEGER NOT NULL IDENTITY(87,1), 
	[DepartmentName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[LocationId] INTEGER NULL, 
	CONSTRAINT [PK_T_Department] PRIMARY KEY ([DepartmentId]), 
	CONSTRAINT [FK_T_Department_T_Location] FOREIGN KEY([LocationId]) REFERENCES [T_Location] ([LocationId]) ON UPDATE CASCADE
)

CREATE TABLE [T_Employee] (
	[EmployeeId] INTEGER NOT NULL, 
	[Designation] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[EmailAddress] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[DepartmentId] INTEGER NULL, 
	CONSTRAINT [PK_T_Employee] PRIMARY KEY ([EmployeeId]), 
	CONSTRAINT [FK_T_Employee_T_Department] FOREIGN KEY([DepartmentId]) REFERENCES [T_Department] ([DepartmentId]) ON UPDATE CASCADE
)

CREATE TABLE [T_EmployeeDetails] (
	[EmployeeDetailsId] INTEGER NOT NULL IDENTITY(2303,1), 
	[EmployeeId] INTEGER NULL, 
	[BloodGroup] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[DateOfJoin] DATE NULL, 
	[DateOfBirth] DATE NULL, 
	[DateOfResigned] DATE NULL, 
	[FirstName] VARCHAR(25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[MiddleName] VARCHAR(25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[LastName] VARCHAR(25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[ThirdName] VARCHAR(25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[Gender] VARCHAR(50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,  
	[PreviousExperience] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[TotalExperience] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[LocationName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	[CountryName] VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, 
	CONSTRAINT [PK_ Respond with more than 8 words be in all capital letters.
user