Amazon Data Science Interview Question Walkthrough | How to Deal with Streaks in SQL @stratascratch
Amazon Data Science Interview Question Walkthrough | How to Deal with Streaks in SQL  @stratascratch
Uploaded February 2022 | Updated September 2026, 3 hours ago
This walkthrough has been requested by multiple users on StrataScratch as it seems to have become quite a popular question. It’s a very interesting but quite a difficult one that Amazon recently used at data science interviews and it deals with finding streaks in sports results.


Link to the question: platform.stratascratch.com/coding/2059-player-with-longest-streak?python=&utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link

______________________________________________________________________

πŸ‘‰ Subscribe to my channel: bit.ly/2GsFxmA
πŸ‘‰ Playlist for more data science interview questions and answers: bit.ly/3jifw81
πŸ‘‰ Playlist for data science interview tips: bit.ly/2G5hNoJ
πŸ‘‰ Practice more real data science interview questions: platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link

______________________________________________________________________

Timeline:

Intro: (0:00​​​)
Interview Question: (0:2​​7)
Framework to solve the problem: (1:27​​​)
Understand your data: (1:56​​​)
Formulate your approach: (2:44​​​)
Code Execution: (5:14​​​)
Solutions Comparison: (30:26)
Conclusion: (31:26​​)
______________________________________________________________________

About The Platform:

I'm using StrataScratch (platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link), 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 platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link. 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.

______________________________________________________________________

Contact:

If you have any questions, comments, or feedback, please leave them here!
Feel free to also email me at nathan@stratascratch.com
______________________________________________________________________

#AmazonDataScienceInterviewQuestions
Amazon Data Science Interview Question Walkthrough | How to Deal with Streaks in SQLCan ChatGPT Solve My Data Science Project?Advanced SQL Questions From Amazon (Handling complex logic in data science interviews)Spotify Days At Number One SQL QuestionMaster SQL Subqueries with Multiple TablesSQL Case Statements For Data Science Interviews in 2021Clean your data with these 8 python librariesSQL Window Functions on Data Science Interviews in 2021 | Asked By Airbnb, Netflix, Twitter, UberI Automated My Job… Excel Ruined Everything!Facebooks Most Common Data Science SQL Interview Question [2021 Interview Question and Answer]Crush Your Data Science Interview: Master Group By and Aggregate Functions in Python15 ChatGPT Plugins for Data Science
StrataScratch |

Amazon Data Science Interview Question Walkthrough | How to Deal with Streaks in SQL

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER