Uploaded December 2020 | Updated September 2026, 14 minutes ago

---

Let's cover 3 types of SQL case statements that show up on data science interviews and that you'd use daily as a data scientist. I'll cover 3 different use cases for SQL case statements, explain the nuances, and what goes on behind the scenes when you execute your SQL query. All of this hopefully to make you better on your data science interviews.

Follow along interactively by coding the solutions to the questions:
- CASE statement for numerical values: platform.stratascratch.com/coding/9632-host-popularity-rental-prices?python=&utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link
- CASE statement for text: platform.stratascratch.com/coding/9738-business-inspection-scores?python=&utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link
- The most popular CASE statement on SQL interviews: platform.stratascratch.com/coding/10289-top-engagements?python=&utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link

______________________________________________________________________

This series is for both beginner and intermediate data scientists and analysts interested in learning how to solve common data science interview questions in SQL. These are real data science interview questions. For some background context and an intro about what this series is about: bit.ly/36kKbxG

👉 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

______________________________________________________________________
Timestamps:

Intro: (0:00)
Categorizing based on numerical values: (1:13)
Case statement helpful tip #1: (3:33)
Case statement helpful tip #2: (5:30)
Categorizing based on text: (6:30)
SQL helpful tip #3: (8:41)
Quick & dirty Case statement: (9:52)
Case statement helpful tip #4: (11:46)
Outro: (14:00)

_____________________________________________________________________
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.

Head over to platform.stratascratch.com/coding?utm_source=youtube&utm_medium=click&utm_campaign=YT+description+link to solve a data science coding question.
______________________________________________________________________
Contact:

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

#sql #sqlinterviews #datascienceinterviews