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
https://knowstar.blogspot.com/2022/0...

Best Data Science / Analytics / SQL courses
Learn SQL Basics for Data Science Specialization
https://imp.i384100.net/qnXYk5

Data Science Fundamentals with Python and SQL Specialization
https://imp.i384100.net/mgVYre

Please do not forget to like, subscribe and share.

For enrolling and enquiries, please contact us at
Website http://knowstar.org/
Instagram   / learn.knowstar  
Facebook   / knowstartrainings  
Linkedin https://www.linkedin.com/company/know...
Email [email protected]