Data Science SQL Interview Question Walkthrough | SQL Sundays #9 | Tina Huang

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: hellotinah@gmail.com *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. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1 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. ---- Keywords: ai safety, tina huang, ai agents, programming, coding tips, ai development Learn more about your ad choices. Visit megaphone.fm/adchoices