Page 123 - SQL
P. 123
Id Name Id FName LName PhoneNumber ManagerId DepartmentId Salary HireDate
01-01-
1 HR 1 James Smith 1234567890 NULL 1 1000
2002
23-03-
1 HR 2 John Johnson 2468101214 1 1 400
2005
12-05-
1 HR 3 Michael Williams 1357911131 1 2 600
2009
24-07-
1 HR 4 Johnathon Smith 1212121212 2 1 500
2016
01-01-
2 Sales 1 James Smith 1234567890 NULL 1 1000
2002
23-03-
2 Sales 2 John Johnson 2468101214 1 1 400
2005
12-05-
2 Sales 3 Michael Williams 1357911131 1 2 600
2009
24-07-
2 Sales 4 Johnathon Smith 1212121212 2 1 500
2016
01-01-
3 Tech 1 James Smith 1234567890 NULL 1 1000
2002
23-03-
3 Tech 2 John Johnson 2468101214 1 1 400
2005
12-05-
3 Tech 3 Michael Williams 1357911131 1 2 600
2009
24-07-
3 Tech 4 Johnathon Smith 1212121212 2 1 500
2016
Finally each expression used within the SELECT clause is evaluated to return our final table:
Departments.Name Employees.FName
HR James
HR John
Sales Richard
Tech NULL
https://riptutorial.com/ 105
