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