SQL Case Statements For Data Science Interviews in 2021

An explanation of three types of SQL CASE statements commonly asked in data science interviews, with walkthroughs of practice questions.

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-renta… - CASE statement for text: platform.stratascratch.com/coding/9738-business-inspection-s… - The most popular CASE statement on SQL interviews: platform.stratascratch.com/coding/10289-top-engagements?pyth… ______________________________________________________________________ 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_med… ______________________________________________________________________ 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_med… 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