ComputerID
Location
Employee ID
Advanced Software Packet
1
B1
2108
true
2
D1
2112
true
3
C1
2108
true
4
A1
2110
true
5
A2
2138
true
6
A3
2129
true
7
A4
2103
true
8
B2
2135
false
9
B3
2113
false
10
B4
2118
false
11
C2
2106
false
12
C3
2109
false
13
C4
2126
false
14
D2
2131
false
15
D3
2107
false
16
D4
2121
false
17
A5
2136
true
18
B5
2134
false
19
C5
2100
false
20
D5
2120
false
Employee ID
Last Name
First Name
Job Title
Office Phone
Mobile Phone
2100
Wilson
Mason
Marketing Officer
1219
404-555-0169
2101
Smith
Emily
Director
1228
617-555-0101
2103
Green
John
Chairman
1218
202-555-0132
2106
Hernández
Jessica
Administrative Assistant
1213
404-555-0122
2107
Martínez
Jayden
Sales Associate
1223
202-555-0185
2108
Baker
Sonia
Director
1225
617-555-0176
2109
García
Lucas
Marketing Officer
1216
202-555-0158
2110
Miller
Aiden
CEO
1222
404-555-0184
2112
Johnson
Jeremiah
Director
1212
202-555-0142
2113
Brown
Julia
Finance Officer
1231
404-555-0107
2118
Jones
Jackson
Finance Officer
1227
602-555-0123
2120
Taylor
Jacob
Sales Associate
1229
617-555-0148
2121
Anderson
Ethan
Sales Associate
1224
404-555-0155
2126
Rodríguez
Noah
Marketing Officer
1226
404-555-0169
2129
Scott
Casey
Vice President
1217
602-555-0117
2131
Moore
Sharon
Administrative Assistant
1220
602-555-0178
2134
Davis
Liam
Finance Officer
1221
617-555-0101
2135
Thomas
Jack
Administrative Assistant
1230
202-555-0137
2136
Williams
Joshua
Administrative Assistant
1215
202-555-0133
2138
King
Linda
Vice President
1214
617-555-0165
Job Title
Administrative Assistant
CEO
Chairman
Director
Finance Officer
Marketing Officer
Sales Associate
Vice President
Computer ID
Upgrade Group
Current OS Version
Upgrade OS Version
Upgrade Date
1
Group 1
version 4
version 5
2
Group 1
version 4
version 5
3
Group 1
version 4
version 5
4
Group 1
version 4
version 5
5
Group 2
version 4
version 5
6
Group 3
version 4
version 5
7
Group 4
version 4
version 5
8
Group 2
version 4
version 5
9
Group 3
version 4
version 5
10
Group 4
version 3
version 5
11
Group 2
version 4
version 5
12
Group 3
version 3
version 5
13
Group 4
version 4
version 5
14
Group 2
version4
version 5
15
Group 3
version 4
version 5
16
Group 4
version 4
version 5
17
Group 5
version 3
version 5
18
Group 5
version 4
version 5
19
Group 5
version 3
version 5
20
Group 5
version 4
version 5
SELECT EmployeeInformation.[Last Name], EmployeeInformation.[First Name], EmployeeInformation.[Job Title], ComputerInformation.Location, UpgradeInformation.[Upgrade Group], UpgradeInformation.[Upgrade Date]FROM (EmployeeInformation INNER JOIN ComputerInformation ON EmployeeInformation.[Employee ID] = ComputerInformation.[Employee ID]) INNER JOIN UpgradeInformation ON ComputerInformation.ComputerID = UpgradeInformation.[Computer ID]ORDER BY EmployeeInformation.[Last Name];
Is this the question you were looking for? Place your Order Here