In this video, we practice writing SQL Complex queries.
Below are the SQL Queries with their timelines -
1- Find employees with highest salary in a department - 1:27:36
2- Find employees with salary lesser than department average - 9:06:80
3- Find employees with less than average salary in dept but more than average of ANY other Depts - 11:50:16
4- Find employees with same salary - 15:42:90
5- Find Dept where none of the employees has salary greater than their manager's salary - 20:06:16
6- Find difference between employee salary and average salary of department - 25:41:96
7- Find Employees whose salary is in top 2 percentile in department - 28:02:56
8- Find Employees who earn more than every employee in dept no 2 - 31:19:63
9- Department names(with employee name) with more than or equal to 2 employees whose salary greater than 90% of respective department average salary - 35:41:40
10- Select Top 3 departments with at least two employees and rank them according to the percentage of their employees making over 100K in salary - 43:52:66
All the material related to this video can be found here -
know-star.blogspot.com/2022/0...
Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
imp.i384100.net/qnXYk5
Data Science Fundamentals with Python and SQL Specialization
imp.i384100.net/mgVYre
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - knowstar.org/
Instagram - / learn.knowstar
Facebook - / knowstartrainings
Linkedin - www.linkedin.com/company/know...
Email - learn@knowstar.org
5 сен 2022