![]() ![]() It’s especially useful for solving interview tasks as, given the stress, it’s lifesaving to have a systematic way to approach any interview question, but it also comes useful in general e.g. Because of that, while it’s not common to use SQL in practice to detect streaks, this makes a really good interview question that companies such as Amazon like to ask.įramework to Solve this Amazon Data Analyst Interview Questionīefore devising the solution, let us share the 3-step general framework to solve any data analyst interview questions with you. Something that can easily be solved in other programming languages using loops in SQL requires an elaborate and clever approach. ![]() This is one of the hard Amazon data analyst interview questions because the task of identifying patterns, especially in time, is difficult in SQL. We are also being asked to output the ID of the player or players and the length of the streak. This Amazon data analyst interview question also explains that a streak is a set of consecutive won matches of one player and that the streak ends once a player loses their next match. The task is to find the longest streak of wins. We are given a table of tennis players and their matches that they could either win (W) or lose (L). The title of the question is ‘player with the longest streak’ and that’s exactly what we need to find. This question has been repeatedly asked at Amazon interviews for data scientists and data analysts. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |