Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the reference table below, please write a SQL query to show the data from the datable showing all the subordinates below the manager
Based on the reference table below, please write a SQL query to show the data from the datable showing all the subordinates below the manager of 'Vice President of sales' and the person who are reports to the subordinates including the level number of that person. Reference table: \begin{tabular}|111111111] Whline & Employeeld & FirstName & LastName & Title & DeptID & ManagerlD Thline 1 & 1 & Ken & Snchez & Chief Executive Officer & 16 & NULL W Whline 2 & 16 & David & Bradley & Marketing Manager & 4 & 273 Whline 3 & 23 & Mary & Gibson & Marketing Specialist & 4 & 16 W $\hdashline 4$ & 273 & Brian & Welcker & Vice President of Sales & 3 & IN $\hdashline 55 & 274 & Stephen & Jiang & North American Sales Manager & 3 & 273 W $\hdashline 6$ & 275 & Michael & Blythe & Sales Representative & 3 & 274 $\hdashline 75 & 276 & Linda & Mitchell & Sales Representative & 3 & 274 $\hdashline 8$ & 285 & Syed & Abbas & Pacific Sales Manager & 3 & 273 $\hdashline 95 & 286 & Lynn & Tsoflias & Sales Representative & 3 & 285 $\hdashlines \end{tabular Table Myemployee Sample of the results: \begin{tabular} [1]111]1) & Employeeld & ManagerID & Title & Level 1 Whline 1 & 273 & 1 & Vice President of Sales & ON Thline 2 & 16 & 273 & Marketing Manager &1W Thline 3 & 274 & 273 & North American Sales Manager & 1 W Whline 4 & 285 & 273 & Pacific Sales Manager & 1 Whline 5 & 286 & 285 & Sales Representative & 2 W Thline 6 & 275 & 274 & Sales Representative & 2 Thline 7 & 276 & 274 & Sales Representative & 2 Whline 8 & 23 & 16 & Marketing Specialist & 2 \end{tabular) CS.SD.6591
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started