Real Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions

Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough.

This is another data science SQL interview question and answer done from beginning to end in a real interview style.

🔗Affiliates
========================
My SQL for data science interviews course (10 full interviews):

365 Data Science:

Check out StrataScratch for data science interview prep:

📲Socials
========================

🤯Study with Tina
========================
Study with Tina channel:

How to make a studying scoreboard:

Scoreboard website:

livestreaming google calendar:

🎥Other videos you might be interested in
========================
SQL Sundays Playlist:

How I consistently study with a full-time job:

How I would learn to code (if I could start over):

🐈‍⬛🐈‍⬛About me
========================
Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :)

📧Contact
========================
youtube: youtube comments are by far the best way to get a response from me!

========================
Some links are affiliate links and I may receive a small portion of the sales price at no cost to you. I really appreciate your support in helping improve this channel! :)

[TinaHuang]

Btw I still HIGHLY recommend you get a whiteboard! I can make an entire video about why I think whiteboards are a data scientist's best friend haha.

In any case, I hope this video is helpful for people doing quarantine interviews! When things get better (and if you guys like this type of video) I will go back to my beloved whiteboard 😂

[paulntalo]

What's beautiful about this video is that it doesn't just show the solution but the technique of how to approach the question to create better queries

[navarre]

I just started reviewing SQL yesterday after like a 2+ year IT/programming hiatus and got super excited after getting a decent chunk of the logic right :D no clue about timestamps and how to transform them though, so that's something I need to look further into.

Great stuff, keep it up!

[yuejiang]

This is amazing ! Thank you so much to make this kind of video! I especially like the way that you lay out all the assumptions before you writing the query!

[LayaWhite]

Thank you for making this! I use SQL in my current job and I was wondering what types of SQL knowledge a potential employer would be looking for. This was really helpful!

[jakelee]

For someone who lives and works in the Bay Area, this is SO RELEVANT! It is helping me immensely in my journey and the best part is that this very closely mimics technical SQL interview questions you will receive at tech companies here. Thank you and keep posting this type of content please! :)

[rhosseinipour]

this was so helpful, actually the most straight forward question+answer tutorial i've ever seen

[sanjaymehta]

Thank you! The moment when it threw that error and everyone's heart sank 🤣. Great video and walk through

[sog]

Tina I just want to say thank you A
I am so glad to see how to actually process a question!

[melat]

New subscriber and just wanted to say love your content, Tina!

[sehaj]

This was soo great. The unfiltered ones are the best. Could really see your thought process. Thank you! Subscribed definitely!

[SaurabhAgrawal]

Great stuff, thanks 😊 I am working as lead analyst - digital transformation and wish to be a data scientist. Learning a lot from you, Thanks 😊

[giulianobarrella]

This is amazing Tina, thank you so much!!! Please keep posting this amazing content!

[tqw]

I just completed my interview loop on Amazon. Thank you for the contents! All the best!

[torispadewtd]

I'm going through your Sql Mock Interview series. It's cool seeing a preview of what the Interviews would look like!

[owlcatxx]

"Let me know if I'm repeating myself repeatedly" 👌🏼Love the humor! Keep up these videos, they are super useful and your delivery is great - clear and easy to connect with

[winnumber]

This was really smooth haha—I learned a lot. Thanks Tina!

[drraxinarc]

I've started learning from the SQL Sunday resources. Its very useful. Thanks for the content

[kevinlandgraf]

video was amazing as a sql beginner, it was so fun to actually understand the coding <3

[PixelsWorkshopVideos]

excellent and on-point. Subscribed Tina!