Tina Huang

Real Data Science SQL Interview Questions and Answers # 2 | Data Science Interview Questions | Tina Huang

Tina Huang

Show Notes

Real Data Science SQL Interview Questions and Answers # 2 | 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):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📲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/UCI8JpGrDmtggrryhml8kFGwHow to make a studying scoreboard: https://www.youtube.com/watch?v=KAVw910mIrIScoreboard website: scoreboardswithtina.comlivestreaming google calendar:https://bit.ly/3wvPzHB🎥Other videos you might be interested in========================SQL Sundays Playlist: https://www.youtube.com/playlist?list=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dAHow I learned SQL from Scratch in 11 Days to Pass my FANNG SQL Interview: https://www.youtube.com/watch?v=vaD3ZFFNwhMHow I consistently study with a full-time job:https://www.youtube.com/watch?v=INymz5VwLmkHow 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 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] ========================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! :)

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. 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.

---------- Keywords: llm comparison, artificial intelligence, coding tips, ai projects, vibe coding, tech career, ai trends Learn more about your ad choices. Visit megaphone.fm/adchoices

More from Tina Huang

Oct 26, 2026

SQL Data Science Interview Question Walkthrough | SQL Sundays #6

Oct 26, 2026

🐙 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. ---------------------------

Oct 26, 2026

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. -------------------------

Oct 26, 2026

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. -- ---------------------------

Oct 26, 2026

Full Guide To Building AI Agents Leverage AI agents with the FREE Master AI Agents Playbook: https://clickhubspot.com/7002aa🤖 Sign up for my upcoming 4-week AI Agents Bootcamp! https://www.lonelyoctopus.com/ai-agent-bootcamp📈 Want to get ahead in your career using AI? Join my FREE workshop: https://www.lonelyoctopus.com/workshop✉️ 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 skills and how to apply them to real freelance projects! 🤝 Business Inquiries: https://tally.so/r/mRDV99🖱️Links mentioned in video========================OpenAI components: https://platform.openai.com/docs/guides/agentsAnthropic's building AI agents article: https://www.anthropic.com/engineering/building-effective-agentsOpenAI Agents SDK github: https://github.com/openai/openai-agents-pythonY Combinator YT channel: https://www.youtube.com/@ycombinator🔗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=INymz5VwLmkHow 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! :) 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.

See all episodes →