Question: SQL SQL management 2009-2014 The following query for a small business database is supposed to select the names and salaries of all marketing staff who

SQL

SQL management 2009-2014

The following query for a small business database is supposed to select the names and salaries of all marketing staff who earn more than the average salary.

However, is not working and retrieves 0 rows.

What is wrong with the query and how would you fix it?

SELECT name, salary FROM staff GROUP BY name, salary, department HAVING salary > AVG(salary) AND department = 'Marketing'

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!

Please solve question 12 , SQL , SQL management 2009-2014 Hi From Ben Morning From ab hi Question 12 From Good Not yet answered The following query is executing very slowly on a large amount of data,...

I have problems understanding this case study for database. can someone help me solve this. Deliverables: 1. Create a list with the main business rules 2. Identify the main Entity types and their...

Assignment 1: Setting up Databases (15%) This assignment relates to the following Cowrse Learning Requirements: CLR 1 - Plan, Prepare, Install, Configure, and Use a market-leading Database Management...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

this is my assessment which are am going to send you and i need some things about my assessment : Adding some more detail and diving into the case study a bit deeper would really make your points...

Which do you recommendshould Vitality Health: Revert to not having a performance management program/process? Revise the current performance management program/process? Explain why you recommend this...

I need some help with both Case 1 and Case 2 of this assignment. See attached document for full assignment. Here is an excerpt from each. Case 1: Purchase Point Media Corporation (PPMC) Media...

This policy will be reviewed no later than 5 years of its authorisation date. At this point it will need to be re-authorised by the relevant authority at Xxz Financial Services Version Published...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

Assume a pool measuring 29 meters by 12 meters is surrounded by a path of uniform width, as shown in the figure. Express the area of the path, A, in square meters, as a function of its width, x, in...

The situation faced by Mike Holmes when he retired: Mike is 89 years old. His wife Rebecca died 2 years ago. Mike has 3 children and 10 grandchildren. Mike has banked exclusively with the same bank...

the concept of liabilityu of foregignness cecomes most relevant when

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

From a Comparable Worth Standpoint, what is the situation with regard to Federal Gender-based Employee Pay Equity?

Provide an example of how drilling down further into information can yield new results.

What do Dimensions represent in OLAP Cubes?