This advanced SQL question is from the Facebook data science interview that tests your ability to write window functions and rank data and use some advanced functions like coalesce. It’s a complicated question that involves subqueries and joins and also tests your knowledge in rankings.

Timeline:

Intro: (0:00​​​)
Interview Question: (0:33​​)
Framework to solve the problem: (0:58​​​)
Understand your data: (2:18​​​)
Formulate your approach: (5:38​​​)
Code Execution: (8:42​​​)
Conclusion: (23:05​​​)

#sql #datascience #interviewquestions #facebook