Question: plz answer this Question 9 (5 points) Based on Appendix A Write a select statement that returns the names of the employee(s) who are either

 plz answer this Question 9 (5 points) Based on Appendix A

plz answer this

Question 9 (5 points) Based on Appendix A Write a select statement that returns the names of the employee(s) who are either directly or indirectly managed by Kelly Luis (employees that Kelly manages and the employee that are managed by Kelly's subordinates and so on). Kelly's employee id is 230 Appendix A-HR Tables dbo.Countries to Depan o Column DEPARTMENT ID OK Elgint, not un DIPARTMENT NAME wachac250), ) MANAGERID (bant, null) LOCATION Dant, nu 1 Country JO OK, varchar(30), not Country Name (varchard 50l, nuit) D Pegion D Colegine, u do Employees Columns EMPLOYEUD PK bigint not nullo IST JAME(vardar (SOL) LAST NAME (archar(50. muth) EMAIL (varcharSolnud PHONE NUMBER barcharcsa) MORE DATE , NORD varchar(50i, nu 2 SALARY ( ) COMMISSION PCT now, MANAGERUD (bigunt, rull) DEPARTMENT JD Obligunt, mult Endellobe Column To Dachwou not to obce wachar, A MinSalary Om Mar Salary COLOCAMOR CUMA Located bun mot nu Stw No WCH UMNO) Potococco chy char) Pancho Com SMS do Regons Columns Ragion JD (PK bignon D Region Name (wcharda mull)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!