Day 21: Learning SQL to Get Hired

Day 21 of my "Learning SQL to Get Hired" series!

Today’s problem:
- #1731 The Number of Employees Which Report to Each Employee

This challenge is all about self-joins — a common SQL technique for working with hierarchical data. By joining the employee table to itself, we can count how many subordinates each manager has. Then, we filter and order to present the results clearly.

Problem link:
https://leetcode.com/problems/the-number-of-employees-which-report-to-each-employee/

Timestamps:
0:00 - Introduction
0:48 - The Number of Employees Which Report to Each Employee
12:29 - Reviewing the Editorial
13:39 - Conclusion

#SQL #LeetCodeSQL #SQLInterview #LearnSQL #DataEngineer #MySQL #SelfJoin #GROUPBY #COUNT #AVG

Видео Day 21: Learning SQL to Get Hired канала Nicholas Facciola