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 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
Get step-by-step solutions from verified subject matter experts
