Jay Feng
Jay Feng
  • 304
  • 2 726 740
Cracking a Hard Data Science Interview Question: SQL Query for User System Response Times Explained
Are you preparing for your next data science interview and want to master SQL queries? In this video, we tackle a challenging SQL interview question that tests your ability to compute average response times for users. This is a common type of question that data science interviewers use to gauge your SQL and analytical skills.
Data Scientist roles require a deep understanding of SQL and the ability to write complex queries efficiently. Join us as we break down this hard-level interview question and provide a step-by-step solution.
In this video, you'll learn:
❓ How to approach this SQL interview question
📊 Detailed explanation of the 'User System Response Times' problem
💡 Tips for optimizing your SQL queries and interview approach
Prepare yourself with the best resources and increase your chances of landing that dream job in data science! Don't forget to like, comment, and subscribe for more data science interview tips and tutorials.
Get to know more about Sai here: www.linkedin.com/in/saibysani18/
Get to know more about Will here: www.linkedin.com/in/william-blumrosen-809b05128/
The question we're tackling: www.interviewquery.com/questions/user-system-response-times?
Use the code "datasciencejay" and get 10% off data science interview prep 🔥 : www.interviewquery.com/pricing?via=jay
Nail your next tech interview with Interview Query's Company Interview Guides: www.interviewquery.com/companies?
❓ Check out more Interview Questions: www.interviewquery.com/questions?
❓ Check out our data science course: interviewquery.com/learning-paths?
💵Find out more about data scientist salary: www.interviewquery.com/salaries?
🔑 Get professional coaching here: www.interviewquery.com/coaching?
🐦 Follow us on Twitter: / interview_query
📸 Follow us on Instagram: / interview_query
Read my personal blog: datastream.substack.com/
Follow me on Linkedin: / jay-feng-ab66b049
Find me on Twitter: / datasciencejay
Tags: data science interview questions , data science interview , data science , data scientist, data science interview questions , data scientist, sql interview question
Переглядів: 1 490

Відео

Data Scientist Interview: Solving Decreasing Payments Problem | Data Science Interview Question
Переглядів 51519 годин тому
Are you ready to tackle real-world data science interview questions? In this mock interview, we dive deep into a common data scientist problem: Decreasing Payments. Imagine you work for a financial company and notice that the credit card payment amount per transaction has decreased. How would you investigate what happened? Join us as we explore step-by-step how to approach this complex issue, f...
Meta Product Manager Interview: Analyze Instagram Stories | MAANG Interview Prep
Переглядів 34321 годину тому
Are you preparing for a Meta Product Manager interview? In this video, we dive deep into the world of Product Metrics and Statistics to analyze a real-world scenario involving a feature change for Instagram stories. We'll guide you through interpreting key Product Metrics to understand user engagement trends and make informed, data-driven decisions. Whether you're an aspiring Product Manager or...
Meta Product Manager Interview Question Solved | Improving Search Feature | MAANG Interview Prep
Переглядів 644День тому
In today's video, we tackle the challenge of enhancing Facebook's search functionality for users looking for activities in San Francisco. If you're aiming for a product manager or data analyst role, this video is a must-watch. You'll learn valuable skills and strategies for identifying and measuring key performance indicators (KPIs) to optimize search results. Understand the crucial product met...
What Is a Marketing Analyst? - Responsibilities, Career Path & Skills
Переглядів 48414 днів тому
Explore the role of a Marketing Analyst in our insightful video. We'll delve into the essential responsibilities, uncover the career path opportunities, and discover the key skills needed to thrive in this position with a bonus of expert tips on navigating interview questions for aspiring Marketing Analysts. Learn how a marketing analyst interview could go and everything else you need to know a...
Meta Product Analyst Interview: Key Metrics for Facebook Stories | MAANG Interview Guide
Переглядів 71921 день тому
Meta Product Analyst Interview: Key Metrics for Facebook Stories | MAANG Interview Guide
Mastering Data Science Interviews: Three Levels of Data Science Interview Questions Explained
Переглядів 1,1 тис.21 день тому
Mastering Data Science Interviews: Three Levels of Data Science Interview Questions Explained
TikTok Data Analyst Interview Question: User Journey Analysis | Data Analyst Interview Guide
Переглядів 811Місяць тому
TikTok Data Analyst Interview Question: User Journey Analysis | Data Analyst Interview Guide
Python Interview Question: Longest Palindrome Explained by MAANG Software Engineer
Переглядів 860Місяць тому
Python Interview Question: Longest Palindrome Explained by MAANG Software Engineer
Python Coding Interview Question: Reverse a List from Index K | MAANG Engineer's Guide
Переглядів 892Місяць тому
Python Coding Interview Question: Reverse a List from Index K | MAANG Engineer's Guide
What a Netflix Data Science Interview Question Really Looks Like: Analyzing Churn Behavior
Переглядів 1,5 тис.Місяць тому
What a Netflix Data Science Interview Question Really Looks Like: Analyzing Churn Behavior
Cracking Meta's Most Challenging Case Study with Data Experts!
Переглядів 2,1 тис.2 місяці тому
Cracking Meta's Most Challenging Case Study with Data Experts!
Lead Data Analyst Easily Solves a Hard SQL Interview Question For E-Commerce! Can You?
Переглядів 3,8 тис.2 місяці тому
Lead Data Analyst Easily Solves a Hard SQL Interview Question For E-Commerce! Can You?
Watch a Senior Software Engineer Nails "Meta" Data Engineering Case Study Interview Question
Переглядів 1,5 тис.3 місяці тому
Watch a Senior Software Engineer Nails "Meta" Data Engineering Case Study Interview Question
ACE your Meta (Instagram) Data Science Case Study Interview Question - ULTIMATE GUIDE
Переглядів 1,5 тис.3 місяці тому
ACE your Meta (Instagram) Data Science Case Study Interview Question - ULTIMATE GUIDE
Tricky TikTok Data Science Case Study Interview Question - Best DAU
Переглядів 1,5 тис.3 місяці тому
Tricky TikTok Data Science Case Study Interview Question - Best DAU
Top 5 Insider Interview Questions Data Analysts Must Master Before Any Interview!
Переглядів 10 тис.3 місяці тому
Top 5 Insider Interview Questions Data Analysts Must Master Before Any Interview!
Watch a Data Analyst Nails Meta Case Study Interview Question: Romantic Reduction
Переглядів 2,7 тис.3 місяці тому
Watch a Data Analyst Nails Meta Case Study Interview Question: Romantic Reduction
Top 5 Reasons Tech Recruiters Aren't Calling You Back in 2024!
Переглядів 1,4 тис.4 місяці тому
Top 5 Reasons Tech Recruiters Aren't Calling You Back in 2024!
Watch a Senior Data Analyst Ace Google Case Study Interview Question: Ads' Revenue vs. User Searches
Переглядів 2,9 тис.4 місяці тому
Watch a Senior Data Analyst Ace Google Case Study Interview Question: Ads' Revenue vs. User Searches
Five Actionable Steps To Get Your First Data Science Job in 2024 - Real Experience, Real Results!
Переглядів 2,8 тис.4 місяці тому
Five Actionable Steps To Get Your First Data Science Job in 2024 - Real Experience, Real Results!
Watch a Data Scientist Ace the DoorDash Case Study Interview Question: Minimize Wrong Orders!
Переглядів 2,8 тис.5 місяців тому
Watch a Data Scientist Ace the DoorDash Case Study Interview Question: Minimize Wrong Orders!
Business Analyst Interview Questions ANSWERED for 2024
Переглядів 4,9 тис.5 місяців тому
Business Analyst Interview Questions ANSWERED for 2024
Ace Your Python Interview - 4 Common TRICKY Questions
Переглядів 1,4 тис.5 місяців тому
Ace Your Python Interview - 4 Common TRICKY Questions
What Is a Supply Chain Analyst? - Responsibilities, Career Path & Skills
Переглядів 21 тис.6 місяців тому
What Is a Supply Chain Analyst? - Responsibilities, Career Path & Skills
How to hunt the RIGHT data science job FOR YOU? 2024 UPDATE!
Переглядів 9936 місяців тому
How to hunt the RIGHT data science job FOR YOU? 2024 UPDATE!
META Machine Learning Interview Question: Mapping Names to Nicknames
Переглядів 1,9 тис.6 місяців тому
META Machine Learning Interview Question: Mapping Names to Nicknames
META Data Science Case Study Interview Question: Facebook users with more friends make fewer posts
Переглядів 4,7 тис.6 місяців тому
META Data Science Case Study Interview Question: Facebook users with more friends make fewer posts
Data Science Resume Transformation: From Intern Basic to 6-Figure Expert Level!
Переглядів 1,8 тис.7 місяців тому
Data Science Resume Transformation: From Intern Basic to 6-Figure Expert Level!
7 Types of Machine Learning Interview Questions!
Переглядів 10 тис.7 місяців тому
7 Types of Machine Learning Interview Questions!

КОМЕНТАРІ

  • @samw2066
    @samw2066 День тому

    1 of the best candidates I've seen so far

  • @Clammer999
    @Clammer999 День тому

    One of the best videos I’ve seen where I get a good insight into the thought process of a data scientist in terms of the whole process of applying ML to a business function from model selection (considering the pros and cons) to data collection and deployment considerations. Please do more of such videos!

  • @Smith281
    @Smith281 2 дні тому

    You should make more videos, excellent astrologer!

  • @stevestead8571
    @stevestead8571 4 дні тому

    Hi Jay. I am a corporate data scientist retiring from my job later this year. I was wondering how to use my skills to generate some extra beer money in retirement. You've given me some great ideas - thanks very much!

  • @_baller
    @_baller 5 днів тому

    Churn = turn

  • @harshdhamecha5301
    @harshdhamecha5301 5 днів тому

    2:45 To reduce Overfitting, we need to reduce the model complexity rather than increasing it. Your figure suggest to increase the complexity.

  • @ivanrubnenkov919
    @ivanrubnenkov919 5 днів тому

    the guy is nailing while in the flow. very nice

  • @diamondsandlipgloss
    @diamondsandlipgloss 6 днів тому

    1) for your IQ Coder & Premium pkg, for the practice questions, do you provide the answers or do you just hint at what's wrong? 2) what is the frequency & how many 1:1 sessions are offered with the Mastery plan?

  • @upgrade1015
    @upgrade1015 8 днів тому

    Unfortunately, people don’t vote educated. They vote on their emotions and the media controls most of the emotions..

  • @upgrade1015
    @upgrade1015 8 днів тому

    Voter suppression = voter ID. I’m pressed every time I drive a car and need ID, if I drink, I would need going to the bars and clubs. I am also oppressed. Buying paint at Home Depot I am oppressed. The list can go on, but I think you get the point..

  • @Jump-2-the-moon
    @Jump-2-the-moon 8 днів тому

    I guess you don’t make enough to afford a $100 microphone?

  • @Vonix634
    @Vonix634 8 днів тому

    Thank you so much this helps so much you made a sub

  • @markstuart901
    @markstuart901 8 днів тому

    Joe Biden got 81 million votes in 2020 election and democrats had the audacity to say there was no proof of widespread voter fraud with a straight face.

  • @stevegonzales4411
    @stevegonzales4411 9 днів тому

    LOL, this guy is so bad. He certainly did not NAIL it. Out of the gate he asked a question that was clearly outlined in the IQ question itself. Then he proceeds to architect the system, by entity? Really? I would fail this guy instantly.

  • @murthigowda471
    @murthigowda471 9 днів тому

    how to learn business analyst

  • @BUY_YOUTUB_VIEWS_448
    @BUY_YOUTUB_VIEWS_448 12 днів тому

    If only UA-cam had a repeat button.

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    Check out these problems you can expect to tackle in a business intelligence role! Subway Machine Learning Model: www.interviewquery.com/questions/subway-machine-learning-model? Listing Bookings Aggregation: www.interviewquery.com/questions/listing-bookings-aggregation? Clickstream Data: www.interviewquery.com/questions/clickstream-data?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    Check out these questions that data analysts tackle! Above Average Product Prices: www.interviewquery.com/questions/above-average-product-prices? Nightly Job: www.interviewquery.com/questions/nightly-job? Weighted Keys: www.interviewquery.com/questions/weighted-keys?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    Check out these problems that pricing analysts tackle! Netflix Price: www.interviewquery.com/questions/netflix-price? Testing Price Increase: www.interviewquery.com/questions/testing-price-increase? Above Average Product Prices: www.interviewquery.com/questions/above-average-product-prices?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    Aspiring to get a Master's in Data Science? Check out some questions that are tackled in the program: Pre-Launching Shows: www.interviewquery.com/questions/pre-launching-shows? Mouse Search: www.interviewquery.com/questions/mouse-search? Friendship Timeline: www.interviewquery.com/questions/friendship-timeline?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    If you enjoyed discussing this data analytics question with us, explore more on our website! Button A/B Test: www.interviewquery.com/questions/button-ab-test? Causal Email Journey: www.interviewquery.com/questions/causal-email-journey? Rolling Bank Transactions: www.interviewquery.com/questions/rolling-bank-transactions?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    If you enjoyed discussing this question with us, explore more on our website! Yelp-Like System: www.interviewquery.com/questions/yelp-like-system? Clickstream Data: www.interviewquery.com/questions/clickstream-data? Click Data Schema: www.interviewquery.com/questions/click-data-schema?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    If you enjoyed discussing these data engineer questions with us, explore more on our website! Subscription Overlap: www.interviewquery.com/questions/subscription-overlap? Employee Salaries: www.interviewquery.com/questions/employee-salaries? Empty Neighborhoods: www.interviewquery.com/questions/empty-neighborhoods?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    If you enjoyed discussing this machine learning question with us, explore more on our website! Keyword Bidding: www.interviewquery.com/questions/keyword-bidding? Dynamic Pricing System: www.interviewquery.com/questions/dynamic-pricing-system? Bank Fraud Model:www.interviewquery.com/questions/bank-fraud-model?

  • @iqjayfeng
    @iqjayfeng 13 днів тому

    Check out these Supply Chain Analyst Questions on our website: Demand Metrics: www.interviewquery.com/questions/demand-metrics? Customer Orders: www.interviewquery.com/questions/customer-orders? International E-Commerce Warehouse: www.interviewquery.com/questions/international-e-commerce-warehouse?solution=true?

  • @M3SANDERS
    @M3SANDERS 13 днів тому

    The problem with this is that there is no person who can’t legitimately vote if they want to. Voter suppression is a myth. There is no law or voter rule that makes the circumstances around voting identical for everyone. Just because I live further from the polling place than someone who could walk there does not mean my vote is being suppressed. Suppression means I am not able to vote because of some law. That does not exist in this country.

  • @lenkapang-ek4fe
    @lenkapang-ek4fe 13 днів тому

    haha,may i know where is the answer of behavior question then?

  • @samudra_dasgupta
    @samudra_dasgupta 14 днів тому

    Awesome

  • @carvalhoac
    @carvalhoac 14 днів тому

    Dude, you need to fix this mic or get a better one. This video is better than the last, but the audio is still painful to listen to.

  • @jsaaiman
    @jsaaiman 15 днів тому

    Nice one!

  • @bhumikasoni361
    @bhumikasoni361 17 днів тому

    You guys are doing a wonderful job in job preparation. Just one request, if you could increase volume of videos from you side it would be great as even at the highest volume in my system, the sound is a bit low. Thanks!

  • @victoruong1677
    @victoruong1677 18 днів тому

    Clarifying questions are a must for product type interviews, but Eshan asked wayyyy too many. I think a better way is to list out potential factors and then ask the interviewer to narrow down which issue it could be.

  • @malapasal-astoreofbeads9776
    @malapasal-astoreofbeads9776 20 днів тому

    Great Video! As a aspiring marketing analyst, I can relate the things you are explaining in the video. Thanks.

  • @adnansardi231
    @adnansardi231 20 днів тому

    Hey Jay, great video! If you ever get the chance to use a microphone, it could really improve the quality. Take care! :)

  • @vbfrenz
    @vbfrenz 20 днів тому

    Is this about how an ML design interview SHOULD NOT be conducted? The interviewee talks like a professor with his snide "right?" comments every now and then. Could also help if you took 2 extra seconds and chose a proper drawing software rather than make a gibberish puke of scribbles all over. And possibly slow down your speed to go over system components rather than stuff like HRNN etc.

  • @soumayahassan5040
    @soumayahassan5040 21 день тому

    Hi Jay, I recently started following you. Thank you for this great video. I will be starting my Masters in Business Analytics this summer. May I please have your email address to reach out and ask you questions privately. I don’t mind paying you either.

  • @sashwotkoirala3934
    @sashwotkoirala3934 21 день тому

    What will happen if it's a toy gun?

  • @harmanbaidwan1713
    @harmanbaidwan1713 24 дні тому

    No, this is def wrong. “Entry” level implies straight out of an undergraduate degree or straight out of a practical internship. The average you can realistically expect is like 78k - 90k. Those six figure jobs straight out of universities are usually FANG companies and you have to be the top 5% in data science to get that. This guy is talking more about intermediate to senior level positions

  • @ednahkerubo7874
    @ednahkerubo7874 24 дні тому

    Have a daughter who has done degree in data science and I want her to advance to masters. I would like her to apply for scholarship in Canada or UK . Kindly guide me on how to go about it. Am a Kenyan resident

  • @iam-mza
    @iam-mza 24 дні тому

    Question, if I have experience and skills in Excel, Microsoft Dynamics, Power BI, SPSS Modeler, Tableau, is Supply Chain Analyst a good field to consider?

  • @soumyajitganguly2593
    @soumyajitganguly2593 26 днів тому

    Its just join and group by.. how is this hard?

  • @soumyajitganguly2593
    @soumyajitganguly2593 26 днів тому

    LOL this is an easy problem! The fact that you can jumble up all the letters to form your palindrome makes this quite easy. If you want a good challenge: try solving the same problem where you cannot jumble up the letters (longest palindromic substring).

  • @soumyajitganguly2593
    @soumyajitganguly2593 26 днів тому

    why did you discard the first possible issue at 7:26? Its not just UI, it can be GPS location errors due to app update / OS update / specific kind of phones / specific locations where this is happening etc.

  • @conykuo4308
    @conykuo4308 26 днів тому

    Very informative video. Keep up the good work!

  • @diamondsandlipgloss
    @diamondsandlipgloss 27 днів тому

    8:10 since we don't know which is the actual cause just yet, how do you determine which cause to label the true positive vs the false positive? 8:51 how do i know what metric to use?

  • @diamondsandlipgloss
    @diamondsandlipgloss 28 днів тому

    glad this channel came up in my feed.... very helpful, thank you!

  • @pratik903
    @pratik903 Місяць тому

    Just out if curiosity, a weird question related to 3rd scenerio. As it is mentioned in the video that person who completed 10 projects in a week shouldn't be given more raise than a person who completes 5 project in a month. Ideally person completing 10 projects in leas time is more efficient and should be given more raise? Please suggest where I am wrong

  • @samuelhasudungan6476
    @samuelhasudungan6476 Місяць тому

    Wow

  • @mdnahidseo
    @mdnahidseo Місяць тому

    U need a Professional UA-cam thumbnail designer and video SEO expert?