Part-13)Join 3 or more than two tables in sql server| Sql Tutorials for beginner

Guys If you have any query related to any course please join our Telegram channel by Clicking below.
Telegram Channel: https://t.me/+FReuKj-xDENjN2Vl

PlayList for 90 days job oriented course: https://www.youtube.com/playlist?list=PLhPFbfobmdK77BRATIwO_N_1S1jOUQjHF
Create table:
Create Table Departments
(
DepartmentID int primary key,
DepartmentName nvarchar(50)
)
Create Table Genders
(
GenderID int primary key,
Gender nvarchar(50)
)
Create Table Employees
(
EmployeeID int primary key,
EmployeeName nvarchar(50),
DepartmentID int foreign key references Departments(DepartmentID),
GenderID int foreign key references Genders(GenderID)
)
Insert into Departments values (1, 'IT')
Insert into Departments values (2, 'HR')
Insert into Departments values (3, 'Payroll')
Insert into Genders values (1, 'Male')
Insert into Genders values (2, 'Female')
Insert into Employees values (1, 'Mark', 1, 1)
Insert into Employees values (2, 'John', 1, 1)
Insert into Employees values (3, 'Mike', 2, 1)
Insert into Employees values (4, 'Mary', 2, 2)
Insert into Employees values (5, 'Stacy', 3, 2)
Insert into Employees values (6, 'Valarie', 3, 2)



sql sever interview query questions,
sql server interview questions,
sql server interview live
sql server interview questions,
sql server interview questions and answers,
sql server interview questions and answers for experienced,
sql server interview questions and answers for 5 years experience,
sql server interview questions by kudvenkat,
sql server interview questions and answers for 7 years experience,
sql server interview questions and answers questpond,
sql server interview questions and answers for beginners,
sql server interview questions and answers for freshers,
sql server interview questions for 3 years experience,
sql server interview questions and answers part 2,
sql server interview questions and answers kudvenkat,
sql server interview questions and answers in hindi,
sql server interview questions and answers in telugu,
sql server interview questions and answers tamil,
sql server interview questions and answers for 3 years experience,
sql server interview questions by questpond,
sql server interview questions by shivprasad koirala pdf,
sql server interview questions basic,
sql server interview questions c# corner,
sql server interview questions dotnet tutorial,
sql server interview questions dotnettricks,
sql server interview questions experienced,
sql server interview questions for 5 years experience,
sql server interview questions and answers for experienced in hindi,
sql server interview questions and answers for 2 years experience,
sql server interview questions for experienced professionals,
sql server interview questions for experienced,
sql server interview questions for freshers,
sql server interview questions for 10 years experience,
sql server interview questions for 8 years experience,
sql server interview questions for senior developer,
sql server interview questions for testers,
sql server interview questions for 2 years experience,
sql server interview questions github,
sql server interview questions guru99,
sql server interview questions geeksforgeeks,