Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question was asked by Meta (Facebook) and is called "Number of Conversations".
Try this question on StrataScratch: https://platform.stratascratch.com/coding/2086-number-of-conversations?via=frederik
Find me on LinkedIn: http://linkedin.com/in/frederikmueller/
0:00 Intro
0:07 UNION Solution
8:26 CASE WHEN Solution
10:31 Outro
Playlists:
StrataScratch SQL Coding Questions: https://youtube.com/playlist?list=PLdrw9_aIADIO_l7hCd4xiJ2mBwiOb4jkU
LeetCode database SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS
LeetCode easy SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADINpdkxu_RHaY16QmG8-mRSm
LeetCode medium SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIMSQe_-m6xknIdPPNiYngKh
LeetCode hard SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIP0sYoOt2mql4Hb06Y1D0z2
