SQL Window Functions on Data Science Interviews in 2021 | Asked By Airbnb, Netflix, Twitter, Uber

Показать описание

Let's cover 4 SQL window function interview questions asked on Airbnb, Netflix, Twitter, and Uber data science interviews. I cover the questions and how to solve them, and exactly what the functions are doing to the data.

Link to questions:

______________________________________________________________________

This series is for both beginner and intermediate data scientists and analysts interested in learning how to solve common data science interview questions in SQL.

______________________________________________________________________
Timestamps:

Intro: (0:00)
Aggregate Functions: (1:03)
Rankings(): (7:35)
Ntile(): (11:27)
Lag/Lead: (16:00)
Conclusion: (21:05)

______________________________________________________________________
About The Platform:

I'm using StrataScratch, a platform that allows you to practice real data science interview questions. There are over 1000+ interview questions that cover coding (SQL and python), statistics, probability, product sense, and business cases.

______________________________________________________________________
Contact:

If you have any questions, comments, or feedback, please leave them here!

#sql #datascience #sqlinterviews

Рекомендации по теме

Комментарии

LOVE the way you chart out your approach before you start coding. I'm adopting that stat. I learned so much from this video and then discovered you have a playlist of similar videos. Feels like Christmas.

AnnieCushing

Huge thumbs up for being so crisp and concise, which imho projects a more positive character than content with fluff and frills.

davidallantodd

Loving the way you lay out the problem and break it down to bits. That "VISION" is gold. Thank you for every second of your time you spend educating people.

alinazem

This is THE ONE video that I review before every single one of my interviews. Thanks for the video!

tamago_roe

Dude that was so helpful! You’re a great teacher as well

tarekelias

I love how you make every question so easy to understand after you break it down! Thank you for sharing your knowledge!

glin

Amazing video man, exactly what i was looking for

bananaboydan

This video has become my go-to refresher before any interview

stutidey

Loved the problems curated, and the way you explained the function with a problem to practice it upon! Awesome work!

luckykukreja

Really awesome mate. I subscribed and happy to know if you have a awesome courses you teach which is as unique and productive as these. Thank you

granand

Thank you for posting this video along with the website where we can practice the queries. Very well explained!
For the ranking part of the video I was able to get the same result with only one derived table instead of two and no grouping clause. I think this query is a bit easier to digest:

select distinct department, salary, ranking
from
(
select *, dense_rank() over( partition by department order by salary desc ) as Ranking
from twitter_employee
) DerivedTable1
where ranking < 4
order by department, salary desc

Also, for the Percentile Fraud section, your query returns 6 rows instead of 5 for Texas. I was able to fix this problem by incrementing Ntile from 100 to 101

hugomichaelnunezmejia

Excellent way of explanation. thank you for the video.

RaviTheVlogger

Really loved your video! Appreciate all the effort you put in it. From good selection on question to very good explanation.

abhishekarora

Great content I love your videos and clarity of speech!
Thanks

BellTollsForThee

Thanks a lot for creating this awesome channel, its amazingly well organized and makes things easy.

swapnilrana

Thank you so much. Your videos are really informative and helpful. Much appreciated 👍

shalinigarg

Love this tutorial. It's very easy to grasp everything.

kshitijdhakal

You are really good at this, best explained!!!

sugandhtiwari

Really awesome to clarify the concepts and their usage, loved it

niveditakumari

Awesome content, well presented. Thank you so much!

warnercooler

SQL Window Functions on Data Science Interviews in 2021 | Asked By Airbnb, Netflix, Twitter, Uber

SQL Window Functions in 10 Minutes

SQL Window Functions | Clearly Explained | PARTITION BY, ORDER BY, ROW_NUMBER, RANK, DENSE_RANK

SQL Window Functions Basics | Partition By, Order By, Frame | #SQL Course #3

SQL Window Function | How to write SQL Query using RANK, DENSE RANK, LEAD/LAG | SQL Queries Tutorial

SQL Window Functions: The Key to Succeeding in Data Science Interviews

Window Functions in MySQL | Intermediate MySQL

Data Analyst SQL Interview Question | Window Functions | Moving Average #sqlinterview #dataanalysis

SQL Window Functions (LEAD/LAG and RANK) and Common Table Expressions in 60 minutes on DataExpert.io

SQL Tricks: How to Solve the Next Purchase Problem! #SQL #WindowFunctions #LearnSQL #shortcuts

The Ultimate SQL Window Functions Course | Complete End-to-End Guide

SQL Window Functions: Explained (with examples)

SQL Window Functions for Interviews #sql #dataanalysis #interviews

Lead & Lag Window Functions in SQL (EXAMPLES INCLUDED)

SQL Window Functions for Beginners

WINDOW FUNCTIONS | Advanced SQL

WINDOW FUNCTIONS IN SQL USE CASES

Master SQL Window Functions for Data Science Interviews in 2023

SQL Aggregate Window Functions | COUNT, AVG, SUM, MAX, MIN | #SQL Course #4

Mastering SQL Windows Functions | SQL Book for Every Data Enthusiast

SQL Tricks | You Must Try This ! Windows Functions

How to write window function in SQL | window function in SQL | window function SQL example

SQL Tutorial - Window Functions (Follow Along)

SQL | Windows Vs Aggregate Functions

Intermediate SQL Tutorial | Partition By