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. 4 3 Reference table: Employeeld First Name Last Name Title DeptID ManagerlD 1 1 Ken Snchez Chief Executive Officer 16 NULL 2 16 David Bradley Marketing Manager 4 273 3 23 Mary Gibson Marketing Specialist 4 16 273 Brian Welcker Vice President of Sales 3 1 5 274 Stephen Jiang North American Sales Manager 3 273 6 275 Michael Blythe Sales Representative 3 274 7 276 Linda Mitchell Sales Representative 3 274 8 285 Abbas Pacific Sales Manager 3 273 9 286 Lynn Tsoflias Sales Representative 3 285 Table Myemployee 3 3 Syed WWUWW Sample of the results: Employeeld Managerl Title Level 1 273 1 Vice President of Sales 0 2 16 273 Marketing Manager 3 274 273 North American Sales Manager 1 285 273 Pacific Sales Manager 1 5 286 285 Sales Representative 2 6 275 274 Sales Representative 2 7 276 274 Sales Representative 8 23 16 Marketing Specialist 2. 2 3 4 5 09 N N N N

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

(a) What are bonding and anti-bonding orbitals? Please show with theory and diagrams. (b) In the case of bulk silicon, how can we predict the size and shape of orbitals theoretically? Please explain...

A telemarketer makes six phone calls per hour and is able to make a sale on 30% of these contacts. During the next 2 hours, find: a. The probability of making exactly four sales. b. The probability...

You expect to receive $ 1 8 2 , 0 0 0 at graduation in three years. You plan on investing it at 1 3 % until you have $ 2 8 2 , 0 0 0 . How long will you wait from now ( round your final answer to 2...

Belkin incorporated has 107,000 shares of $3 par value common stock outstanding. Belkin declares a 47%-stock dividend on March 2 when the stock's market value is $79 per share. Prepare the joumal...

3. Give an example of sexual harassment you may have witnessed or heard about. If you had been the HR manager, how would you have handled the situation?

4. Use the U.S. Department of Labor website (www.usdol.gov) to further research a topic discussed in this chapter. Be sure to understand what the particular law (act) is protecting and what the rules...

2. How would you evaluate the talent solutions framework developed for the Climate Solutions unit at Ingersoll Rand? Is the approach something that you could use as a line manager or as an HR...