Menu
CodeSprout
Typo-tolerant search across every article, problem and post. to open

πŸ‘¨β€πŸ’Ό Employees Whose Manager Left the Company | MySQL SQL Query Explained πŸš€

kvi5hnu7 minutes 55 secondsWatch on YouTube
0comments

Notes

In this video, we solve the "Employees Whose Manager Left the Company" problem from LeetCode using MySQL. We explain how to find employees earning less than $30,000 whose manager no longer exists in the company using CTEs, NOT IN, and subqueries.

πŸ“Œ What You’ll Learn in This Video:
βœ… Using Common Table Expressions (CTEs) in SQL
βœ… Filtering data with NOT IN and subqueries
βœ… Writing optimized SQL queries for real-world scenarios
βœ… Sorting results using ORDER BY

πŸ”— LeetCode Problem: https://leetcode.com/problems/employees-whose-manager-left-the-company

πŸ”₯ If you found this video helpful, don’t forget to:
πŸ‘ Like the video to support the channel
πŸ’¬ Comment below with your questions or improvements

πŸ”” Subscribe & turn on notifications for more SQL tutorials!

Let’s sharpen our SQL skills together! πŸš€

#SQL #MySQL #LeetCode #SQLQueries #Database #CodingInterview #LeetCodeSQL #DataAnalysis #LearnSQL #SoftwareEngineering

Discussion

Sign in to ask a question or share what you learned.