Question

Question 7: Write a query to display EmployeeID, FirstName, LastName, Salary, DepartmentID, DepartmentName, NumberOfSubordinates of each employee who manages at least one other employee or who has the Salary greater than 10000 where NumberOfSubordinates is the number of employees that he/she manages; display the results in descending order of NumberOfSubordinates then in ascending order of LastName for employees having the same NumberOfSubordinates as follows: EmployeeID FirstName LastName Salary DepartmentID DepartmentName NumberOfSubordinates 1 100 Steven King 24000 90 Executive 13 2 121 Adam Fripp 8200 50 Shipping 8 3 122 Payam Kaufling 7900 50 Shipping 8 4 124 Kevin Mourgos 5800 50 Shipping 8 5 123 Shanta Vollman 6500 50 Shipping 8 6 120 Matthew Weiss 8000 50 Shipping 8 7 148 Gerald Cambrault 11000 80 Sales 6 8 147 Alberto Errazuriz 12000 80 Sales 6 9 146 Karen Partners 13500 80 Sales 6 10 145 John Russell 14000 80 Sales 6 11 149 Eleni Zlotkey 10500 80 Sales 6 12 108 Nancy Greenberg 12000 100 Finance 5 13 114 Den Raphaely 11000 30 Purchasing 5 14 103 Alexander Hunold 9000 60 IT 4 15 102 Lex De Haan 17000 90 Executive 1 16 101 Neena Kochhar 17000 90 Executive 1 17 174 Ellen Abel 11000 80 Sales 0 18 168 Lisa Ozer 11500 80 Sales 0 19 162 Clara Vishney 10500 80 Sales 0

          Question 7:

Write a query to display EmployeeID, FirstName, LastName, Salary, DepartmentID, DepartmentName, NumberOfSubordinates of each employee who manages at least one other employee or who has the Salary greater than 10000 where NumberOfSubordinates is the number of employees that he/she manages; display the results in descending order of NumberOfSubordinates then in ascending order of LastName for employees having the same NumberOfSubordinates as follows:

EmployeeID FirstName LastName Salary DepartmentID DepartmentName NumberOfSubordinates
1 100 Steven King 24000 90 Executive 13
2 121 Adam Fripp 8200 50 Shipping 8
3 122 Payam Kaufling 7900 50 Shipping 8
4 124 Kevin Mourgos 5800 50 Shipping 8
5 123 Shanta Vollman 6500 50 Shipping 8
6 120 Matthew Weiss 8000 50 Shipping 8
7 148 Gerald Cambrault 11000 80 Sales 6
8 147 Alberto Errazuriz 12000 80 Sales 6
9 146 Karen Partners 13500 80 Sales 6
10 145 John Russell 14000 80 Sales 6
11 149 Eleni Zlotkey 10500 80 Sales 6
12 108 Nancy Greenberg 12000 100 Finance 5
13 114 Den Raphaely 11000 30 Purchasing 5
14 103 Alexander Hunold 9000 60 IT 4
15 102 Lex De Haan 17000 90 Executive 1
16 101 Neena Kochhar 17000 90 Executive 1
17 174 Ellen Abel 11000 80 Sales 0
18 168 Lisa Ozer 11500 80 Sales 0
19 162 Clara Vishney 10500 80 Sales 0

Question 7:

Write a query to display EmployeeID, FirstName, LastName, Salary, DepartmentID, DepartmentName, NumberOfSubordinates of each employee who manages at least one other employee or who has the Salary greater than 10000 where NumberOfSubordinates is the number of employees that he/she manages; display the results in descending order of NumberOfSubordinates then in ascending order of LastName for employees having the same NumberOfSubordinates as follows:

EmployeeID FirstName LastName Salary DepartmentID DepartmentName NumberOfSubordinates
1 100 Steven King 24000 90 Executive 13
2 121 Adam Fripp 8200 50 Shipping 8
3 122 Payam Kaufling 7900 50 Shipping 8
4 124 Kevin Mourgos 5800 50 Shipping 8
5 123 Shanta Vollman 6500 50 Shipping 8
6 120 Matthew Weiss 8000 50 Shipping 8
7 148 Gerald Cambrault 11000 80 Sales 6
8 147 Alberto Errazuriz 12000 80 Sales 6
9 146 Karen Partners 13500 80 Sales 6
10 145 John Russell 14000 80 Sales 6
11 149 Eleni Zlotkey 10500 80 Sales 6
12 108 Nancy Greenberg 12000 100 Finance 5
13 114 Den Raphaely 11000 30 Purchasing 5
14 103 Alexander Hunold 9000 60 IT 4
15 102 Lex De Haan 17000 90 Executive 1
16 101 Neena Kochhar 17000 90 Executive 1
17 174 Ellen Abel 11000 80 Sales 0
18 168 Lisa Ozer 11500 80 Sales 0
19 162 Clara Vishney 10500 80 Sales 0

Added by Ricky B.

Question

Please give Ace some feedback