Data Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #8 | Tina Huang

Marketers are increasingly concerned about the effectiveness of their advertising campaigns, particularly when metrics like impressions do not translate into actual revenue. This phenomenon, referred to as "bullspend," highlights the disconnect between reported ad performance and tangible business outcomes. The discussion emphasizes the importance of focusing on revenue generation rather than just reach, with LinkedIn being noted as a platform that delivers the highest return on ad spend among major networks.

In a separate segment, a technical question regarding email activity percentiles is explored. The conversation revolves around calculating the total number of emails sent by users and ranking them accordingly. The approach involves using SQL to group users by their email counts and applying window functions to determine their ranks. The discussion also touches on the potential for further analysis by calculating the actual percentiles for these users, encouraging listeners to engage with the problem and share their solutions.

Data Science SQL Interview Question Walkthrough (real interview style) | SQL Sundays #8Hi 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! :)Music Credit: TheFatRat & Laura Brehm - We'll Meet Again https://www.youtube.com/watch?v=hJqYc62NCKoFollow 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. If you represent Tina and would like to discuss this project, please don’t hesitate to get in touch.

--------------- Keywords: ai trends, tech career, programming, data science Learn more about your ad choices. Visit megaphone.fm/adchoices