SQL | Find employees with salary greater than department average / and less than company average

This video is part of the series of videos on SQL Queries on Employee Salary database
How to find employees with salary greater than the average salary of department
How to find employees with salary greater than the average salary of department but less than the organizational average
Check out all the SQL Queries and TH-cam videos for this series here -
know-star.blog...
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Facebook - / knowstartrainings
Linkedin - www.linkedin.c...
Email - [e-mail]

[@LearnatKnowstar]

Sorry for the audio issue with this video. Similar queries with practice data are covered in one of our new videos here. Please check it out -
th-cam.com/video/E_6haE_10eE/w-d-xo.html

[@Sanjay-gz2wj]

Nice explanation

[@mezomezo8718]

Can u plz tell me if the join condition was just to join the two tables or does it have anything to do with the query question. I understand the statement after the on join condition but not understanding the on join caluse itself

[@aakashvaish3757]

Can you please share the data table script. As it is helpful for the practice.

[@LearnatKnowstar]

Sorry for the audio quality in this video. Similar query is covered in one of our new tutorials here - th-cam.com/video/E_6haE_10eE/w-d-xo.html
This has the link to sample data and associated queries. Hope it helps 🙏

[@kristyowens2284]

very useful. Thanks.

[@LearnatKnowstar]

Thank you

[@hv0032113]

Great explanation

[@LearnatKnowstar]

Thank you

[@rohitjaiswal8116]

Sound problem... Voice is very low

[@aslamqureshi9234]

it is helpful but not audible
and thanx for solution

[@sumitdantale3145]

Could you please re upload this video with better audio?

[@LearnatKnowstar]

Yes, we will be updating the entire series again. Thanks.

[@Sanjay-gz2wj]

Not audible

[@parantikaghosh4396]

solution is helpful but not audible

[@sm.prithiv7174]

Worst