Tina Huang

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

Tina Huang

Summary

Marketers are increasingly voicing concerns over ineffective advertising spending, coining the term "bullspend" to describe campaigns that generate impressive metrics but fail to drive actual revenue. A recent discussion highlights the importance of focusing on tangible results, such as revenue, rather than superficial metrics like impressions. The conversation emphasizes that platforms like LinkedIn can provide a higher return on ad spend compared to other networks, encouraging businesses to reassess their advertising strategies.

In a separate segment, a detailed walkthrough of a SQL interview question demonstrates the process of writing a query to count unique users logging in from both iPhone and web platforms. The discussion covers the necessary steps, including joining tables, grouping data by day, and ensuring the query accounts for unique users. The presenter tests the query using dummy data, confirming its accuracy and underscoring the importance of validating code to avoid errors in real-world applications. This practical approach aims to equip listeners with skills for navigating technical interviews in the tech industry.

Show Notes

Real Data Science SQL Interview Questions and Answers # 1 | 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, chatbots, tech career Learn more about your ad choices. Visit megaphone.fm/adchoices

More from Tina Huang

Oct 25, 2026

my simple weekly planning routine (that actually works)

Oct 24, 2026

How I use Notion in 4 different ways

Oct 24, 2026

My career changing computer science masters degree in 15 minutes (Upenn MCIT)

Oct 24, 2026

How I consistently study with a full time job (9 months in and still going strong)

Oct 24, 2026

How I'm figuring out what to do with my life

See all episodes →