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

[@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 - kzbin.info/www/bejne/e5CZmZR7lJZjm6c

[@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

[@Sanjay-gz2wj]

Nice explanation

[@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 - kzbin.info/www/bejne/e5CZmZR7lJZjm6c 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

[@aslamqureshi9234]

it is helpful but not audible and thanx for solution

[@Sanjay-gz2wj]

Not audible

[@sumitdantale3145]

Could you please re upload this video with better audio?

[@LearnatKnowstar]

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

[@rohitjaiswal8116]

Sound problem... Voice is very low

[@parantikaghosh4396]

solution is helpful but not audible

[@sm.prithiv7174]

Worst