Question: 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

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

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!

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...

Your manager has provided you the following matrix and asked that you use it to complete the design assessment phase of your testing. The manager has already performed a preliminary survey, and has...

A discrete sequence {xn} can be converted into a continuous representation x(t) = ts X n= (t n ts) xn, where ts is the sampling period. (a) State two characteristic properties of Dirac's function. [2...

ADMN 233 Assignment 4 Assignment 4 Instructions Assignment 4 is worth 20% of your final mark. It should be completed and submitted after you finish Chapter 13 in your textbook. This assignment is...

Chapter 12 Preparing To Write Business Reports Mary Ellen Guffey, Business Communication: Process and Product, 5e Copyright 2006 What Are Business Reports? Business reports are systematic attempts to...

mutiple chouse 1pts Question 11 pts Which of the following is a function of a database? Group of answer choices 1. Check all input data 2. Specify the type of data to be kept, stored and utilised for...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

TANGLEWOOD CASEBOOK for use with STAFFING ORGANIZATIONS 5th Ed. Kammeyer-Mueller 1 TANGLEWOOD CASEBOOK To accompany Staffing Organizations, fifth edition, 2006. Prepared by John Kammeyer-Mueller...

3. THE PACE OF AN ENGINEER IS 0.68m/pace. HE WALKS ALONG THE PERIMETER OF A TRIANGULAR LOT ABC AND FINDS OUT THAT HE MAKES 750 PACES ALONG LINE AB WHOSE BEARING IS $ 280 E AND MAKES 1520 PACES ON...

Find the expression for vo in the differential amplifier circuit shown in figure. RF ww R1 vio Vo R12 R1 R1

Resilient Distributed Datasets are for big data analytics and used in model. fault tolerant, distributed computing fault tolerant, parallel computing efficient, distributed computing scalable,...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

1. What are the advantages and disadvantages of using customer databases to recruit employees?

LO4 Identify three types of selection tests and legal concerns about their uses.

3. Describe how a local firm might be able to utilize college/university interns to generate future applicants for anticipated job openings within the next one to two years.