Learn & Practice SQL Complex Queries | 10 examples (Must DO for Interviews)
Learn how to write SQL Queries(Practice Complex SQL Queries)
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://know-star.blogspot.com/2022/0...
If this question helped, you’ll find more hands-on practice in my SQL Interview Practice Workbook, linked below.
https://knowstar.gumroad.com/l/gyaous
Must Do Data Analytics Certifications -
Google Data Analytics Professional Certificate
https://imp.i384100.net/OR37oQ
Google Advanced Data Analytics Professional Certificate
https://imp.i384100.net/eK1WmQ
Please do not forget to like, subscribe and share.
For enrolling and enquiries, please contact us at
Website - https://knowstar.gumroad.com/
Instagram - / learn.knowstar
Blog - http://know-star.blogspot.com/
Linkedin - / learn-at-knowstar
Instructor’s LinkedIn - / kriti-c-a83503145
Email - learn@knowstar.org
In questa pagina del sito puoi guardare il video online Learn & Practice SQL Complex Queries | 10 examples (Must DO for Interviews) della durata di ore minuti seconda in buona qualità , che l'utente ha caricato Learn at Knowstar 06 settembre 2022, condividi il link con amici e conoscenti, su youtube questo video è già stato visto 59,030 volte e gli è piaciuto 1.2 mille spettatori. Buona visione!
