Summary
A recent discussion focuses on estimating the annual growth of Airbnb by analyzing the number of registered hosts. The growth rate is determined by comparing the number of hosts in the current year to the previous year, using a formula that calculates the difference as a percentage of the previous year's total.
The analysis begins with a large dataset, which is streamlined to include only the relevant columns: year and host IDs, ensuring that each ID represents a unique host. The speaker outlines a strategy involving a Common Table Expression (CTE) to aggregate host counts by year, followed by a self-join to compare current and previous years' data. This approach allows for the calculation of the growth rate, which is then rounded and ordered by year.
The speaker also suggests that the task could potentially be optimized using a window function instead of a self-join, inviting listeners to consider this alternative method as an exercise. Additionally, an announcement is made regarding the launch of a new SQL course aimed at helping individuals prepare for data science interviews, featuring mock interviews and direct support.
Show Notes
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/5mMAtprshXlivestreaming 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 inHow to learn data science in 2021: https://www.youtube.com/watch?v=Axu4tJl8gbMThe 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=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dACheck 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 :) ______________________________________________________________________Contactyoutube: 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. Tina Huang on YouTube: https://www.youtube.com/@TinaHuang1Disclaimer: 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
More from Tina Huang
SQL Data Science Interview Question Walkthrough | SQL Sundays #6
🐙 Lunch & Learn: How to use AI to 10x Learning Things Part 3! Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop Reminder to add your study plan to the slides if you haven't already by Saturday September 7th, 9am PST. The the top 3 study plans will be awarded $100 each to fund your plan. Your study plan will be judged on alignment with personal/career goal, how well researched it is, and how feasible it is. Tina's study plan for example is slide 24 (it's not perfect and yours doesn't need to look exactly like this ofc) https://docs.google.com/presentation/d/1oXatgjPdHiormk_8RzDZJC-hw9pD0B61d8fhBqQPSI0/edit?usp=sharing 🤝 Business Inquiries: https://tally.so/r/mRDV99 🖱️Links mentioned in video ======================== 🔗Affiliates ======================== My SQL for data science interviews course (10 full interviews): https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training) Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina 🎥 My filming setup ======================== 📷 camera: https://amzn.to/3LHbi7N 🎤 mic: https://amzn.to/3LqoFJb 🔭 tripod: https://amzn.to/3DkjGHe 💡 lights: https://amzn.to/3LmOhqk ⏰Timestamps ======================== 00:00 intro 📲Socials ======================== instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX 🎥Other videos you might be interested in ======================== How I consistently study with a full time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈⬛🐈⬛About me ======================== Hi, my name is Tina and I'm an ex-Meta data scientist turned internet person! 📧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] ======================== Some links are affiliate links and I may receive a small portion of sales price at no cost to you. I really appreciate your support in helping improve this channel! :) 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. 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. ---------------------------
How to FINALLY Self Study Consistently Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop 🖊️ QUIZ: https://tina-self-learner.scoreapp.com/ Free quiz to determine your self-study archetype and how to unlock your potential. ✉️ NEWSLETTER: https://tinahuang.substack.com/ It's about learning, coding, and generally how to get your sh*t together c: 🐙 LONELY OCTOPUS: https://www.lonelyoctopus.com/ Check it out if you're interested in learning AI & data skill, then applying them to real freelance projects! 🔗Affiliates ======================== My SQL for data science interviews course (10 full interviews): https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training) Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina 🎥 My filming setup ======================== 📷 camera: https://amzn.to/3LHbi7N 🎤 mic: https://amzn.to/3LqoFJb 🔭 tripod: https://amzn.to/3DkjGHe 💡 lights: https://amzn.to/3LmOhqk 📲Socials ======================== instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX 🤯Study with Tina ======================== Study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw 🎥Other videos you might be interested in ======================== How I consistently study with a full time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈⬛🐈⬛About me ======================== Hi, my name is Tina and I'm an ex-Meta data scientist turned internet person! 📧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] ======================== Some links are affiliate links and I may receive a small portion of sales price at no cost to you. I really appreciate your support in helping improve this channel! :) 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. 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. -------------------------
101 AI Apps You Can Vibe Code Tina is a former data scientist at Meta. Her channel focuses on AI, coding, tech, career development, and self-study. Always striving to minimize effort while maximizing outcomes. In fact, she firmly avoids doing extra work to reach her goals - one of the many reasons she loves AI. 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. 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. -- ---------------------------
Real Data Science SQL Interview Questions and Answers # 2 | Data Science Interview Questions