Data Science SQL Scenario Based Interview Question [Facebook] – Date Manipulation

This Data Science SQL interview question is from Facebook, and tests your ability to filter out data based on date conditionals. I’ll walk you through solving the question like we’re in an interview and give you some tips on how to approach the solution as well as how to efficiently and effectively communicate with your interviewer.

Go to the question through the link below and follow along with me.

Link to the question:


👉 Subscribe to my channel:
👉 Playlist for more data science interview questions and answers:
👉 Playlist for data science interview tips:
👉 Practice more real data science interview questions:



Intro: (0:00​​​)
Interview Question: (0:33​​)
Framework to solve the problem: (1:08​​​)
Understand your data: (2:25​​​)
Formulate your approach: (4:16​​​)
Code Execution: (6:15​​​)
Additional Technical Concepts: (11:56​​​)
Conclusion: (14:40​​​)

About The Platform:

I’m using StrataScratch (, a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.

So, if you want more interview practice with real data science interview questions, visit All questions are free and you can even execute SQL and python code in the IDE, but if you want to check out the solutions from me or from other users, you can use ss15 for a 15% discount on the premium plans.



If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at


source by Nate at StrataScratch



Fondateur de summarynetworks, passionné des nouvelles technologies et des métiers de Réseautique , Master en réseaux et système de télécommunications. ,j’ai affaire à Pascal, Delphi, Java, MATLAB, php …Connaissance du protocole TCP / IP, des applications Ethernet, des WLAN …Planification, installation et dépannage de problèmes de réseau informatique……Installez, configurez et dépannez les périphériques Cisco IOS. Surveillez les performances du réseau et isolez les défaillances du réseau. VLANs, protocoles de routage (RIPv2, EIGRP, OSPF.)…..Manipuler des systèmes embarqués (matériel et logiciel ex: Beaglebone Black)…Linux (Ubuntu, kali, serveur Mandriva Fedora, …). Microsoft (Windows, Windows Server 2003). ……Paquet tracer, GNS3, VMware Workstation, Virtual Box, Filezilla (client / serveur), EasyPhp, serveur Wamp,Le système de gestion WORDPRESS………Installation des caméras de surveillance ( technologie hikvision DVR………..). ,

5 réflexions sur “Data Science SQL Scenario Based Interview Question [Facebook] – Date Manipulation

Laisser un commentaire