Determine the average salary of the employees

Assignment Help Other Subject

Reference no: EM13717055

Calculate the answer of the following question

Question- Given a table employee (name, salary, department), write an SQL expression for each of these two queries:

Part 1- Find the average salary of the employees that earn more than 40K, for each department.

Part 2- Find the average salary of the employees for each department whose employees' average salary is more than 40K

I want assist to determine the average salary of the employees.

Reference no: EM13717055

Questions Cloud

What is the magnitude of the impulse given to the ball : A tennis ball of mass m = 0.044kg and speed v = 28m/s strikes a wall at a 45 degree angle and rebounds with the same speed at 45 degree What is the magnitude of the impulse given to the ball

Clarify the odds of marijuana : Researchers drew a random sample of youth in a community and reported an odds ratio of 3.0 for marijuana. What are the odds of marijuana use among those who did not report that they like bluegrass music?

Find the impulse imparted to the golf ball : A golf ball of mass 0.045 kg is hit off the tee at a speed of 37m/s . The golf club was in contact with the ball for 3.70 × 103s. Find the impulse imparted to the golf ball

What will be their speeds after the collision : Two billiard balls of equal mass undergo a perfectly elastic head-on collision. what will be their speeds after the collision

Determine the average salary of the employees : Find the average salary of the employees that earn more than 40K, for each department. Find the average salary of the employees for each department whose employees' average salary is more than 40K

How high will the block rise into the air : A gun fires a bullet vertically into a 1.40-kg block of wood at rest on a thin horizontal sheet. how high will the block rise into the air

How many forces are acting on the system : A pair of blocks of the mass M =25.9 kg, and 2 M are dragged over a rough, horizontal surface by two constant forces of magnitude F=72.0 N.How many forces are acting on the system

Find the flow into the well : The permeability in the reservoir is a constant 200 mD. The pressure in the reservoir is 3000 psi. The reservoir is 100 m thick. Calculate the flow into the well.

At what net angle was the queen moved : In two successive chess moves, a player first moves his queen two squares forward, then moves the queen five steps to the left (from the player's view). At what net angle was the queen moved

User Account

All Pages