Jan  Wisozk

Jan Wisozk

1620292920

Step-by-step Approach to Solving Any Data Science SQL Interview Question (Twitch)

Here’s a step-by-step framework to solve any data science SQL interview question. We’ll cover a brand new data science interview question from Twitch where I’ll walk you through the steps on how to solve the problem and communicate with the interviewer.

Link to the question: https://bit.ly/319Gx60

Timeline:

  • Intro: (0:00​​​)
  • Interview Question: (1:16​​​)
  • Explore data schema: (2:20​​​)
  • First assumption: (2:38​​​)
  • Second assumption: (3:15​​​)
  • Third assumption: (3:40​​​)
  • Walk through the logic before coding: (5:15​​​)
  • Coding: (7:35​​​)
  • Answering follow up questions: (12:08​​​)
  • Collapsing or combining CTEs and subqueries for optimization: (13:03​​​)
  • Offering ways to optimize code to show off your knowledge: (14:22​​​)
  • Conclusion: (15:00​​​)

#sql #database #interview-questions

Step-by-step Approach to Solving Any Data Science SQL Interview Question (Twitch)