Data Science SQL Interview Question Walkthrough | SQL Sundays #9

Hi friends! Here's a SQL Sunday as part of the SQL Sundays series in celebration of the launch of my SQL for tech and data science interviews course! I know I know it's Tuesday :x Can we let this one slide?

SQL for tech and data science interviews course with 10 mock interviews:
https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=DF947818F15A561AE84E ($12.99 promotion until July 18th, 2021!)

[expired] https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=A92E9C5BFB043A8FF039 ($9.99 promotion until June 6th, 2021!)


discord: https://discord.gg/5mMAtprshX
livestreaming google calendar: https://calendar.google.com/calendar/u/1?cid=cDBtOGgxOG1waW92bTJxYzdpZmkzNmgwODhAZ3JvdXAuY2FsZW5kYXIuZ29vZ2xlLmNvbQ
______________________________________________________________________
Timestamps

00:00 intro
00:08 question
01:51 assumptions
02:47 answer
10:43 check answer
11:53 announcement

______________________________________________________________________
Other videos you might be interested in

How to learn data science in 2021:
https://www.youtube.com/watch?v=Axu4tJl8gbM
The resume that got me into FAANG as a data scientist:
https://www.youtube.com/watch?v=vx-x-yXXE9I

______________________________________________________________________
Subscribe: https://www.youtube.com/channel/UC2UXDak6o7rBm23k3Vv5dww/?sub_confirmation=1
______________________________________________________________________
SQL for tech and data science interviews course with 10 mock interviews:
https://www.udemy.com/course/sql-for-tech-and-data-science-interviews/?couponCode=A92E9C5BFB043A8FF039 ($9.99 promotion until June 6th, 2021!)

Real SQL interview question walkthrough series:
https://www.youtube.com/watch?v=Td-cmLfQ7uU&list=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dA

Check out StrataScratch for SQL interview prep:
https://stratascratch.com/?via=tina
______________________________________________________________________
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!
linkedin: https://www.linkedin.com/in/tinaw-h/
email for business inquiries only: [email protected]

*If you're reaching out through linkedin, please leave a youtube comment just letting me know that you reached out :)

______________________________________________________________________
*The StrataScratch affiliate program give me a small portion of the sales price at no cost to you. I really appreciate your support in helping improve this channel! :)

#SQLSundays #DataScience #SQL #TinaHuang

Follow this podcast to get Tina Huang’s insights in audio format, perfect for learning on the go.

Disclaimer: This podcast is an independent audio adaptation of content originally created by Tina Huang. It was made by a viewer who values her insights and aims to make them more accessible for audio-first learners. This is not an official production of Tina Huang, and it is not affiliated with or endorsed by her. All rights to the original video content remain with Tina Huang. If you represent Tina and would like to discuss this project, please don’t hesitate to get in touch.

-

Learn more about your ad choices. Visit megaphone.fm/adchoices