15,793,609 members
1.00/5 (1 vote)
See more:
Suppose i have a table employee with salary column

now i want a single query which returns all the employees who have average 5 salaries.

If 65 employees have 90000 salary then all should come.

<pre lang="SQL">

What I have tried:

Suppose i have a table employee with salary column

now i want a single query which returns all the employees who have average 5 salaries.

If 65 employees have 90000 salary then all should come.

Posted
Updated 25-May-22 19:40pm
CHill60 26-May-22 3:13am
If you look to the right of this comment you will see a list of "Related Questions" - Research is always a good place to start and many, many people have posted the same homework question time and time again.
Beware! Your tutor will also have seen many, many internet answers and will know if you just copy something. Try to work it out for yourself

Solution 1

While we are more than willing to help those that are stuck, that doesn't mean that we are here to do it all for you! We can't do all the work, you are either getting paid for this, or it's part of your grades and it wouldn't be at all fair for us to do it all for you.

So we need you to do the work, and we will help you when you get stuck. That doesn't mean we will give you a step by step solution you can hand in!
Start by explaining where you are at the moment, and what the next step in the process is. Then tell us what you have tried to get that next step working, and what happened when you did.

And even if we did want to do it for you, that description is so loose that what we did probably wouldn't be exactly what you wanted. I'd suggest you go back to the assignment and reread it carefully - what you have written so far doesn't make a lot of sense in isolation!

If you are having problems getting started at all, then this may help: How to Write Code to Solve a Problem, A Beginner's Guide[^]