LeetCode 1075 Facebook/Meta Interview SQL Question with Detailed Explanation | Practice SQL

In this video I solve and explain a leetcode SQL question using MySQL query. This question has been asked in Apple, Facebook, Amazon, Google, Adobe, Microsoft, Adobe interviews or what we popularly call FAANG interviews.
I explain the related concept as well. This question includes points to keep in mind to develop SQL queries.

LeetCode is the best platform to help you enhance your skills, expand your knowledge and prepare for technical interviews.

If you found this helpful, Like and Subscribe to the channel for more content.

#LeetCodeSQL #FAANG #SQLinterviewQuestions

[depanshusingh]

Why we are using left join instead of inner join?

[saisushanthdurvasulabitsian]

Thanks a lot for the video, one small doubt here, we could use inner join as well here correct as employee id is foreign key from Project to Employee and so we will not have any non matching rows (nulls) coming from Employee ? Or am I missing any scenario here, pls confirm, thanks

[manojjoshi]

Hello Sir,
I tried this question in SQL server with two different aggregation statement.
aS DECIMAL(10, 2))), 2) [average_years]
aS float)), 2) [average_years]
The second one with float did not pass the test after submission. Could you suggest why so!