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:
Aggregate Functions -- Uber: https://bit.ly/37zCMcS
Ranking -- Twitter: https://bit.ly/3lOFArH
NTILE() -- Netflix: https://bit.ly/3lN0qI7
LEAD/LAG -- Airbnb: https://bit.ly/37tx6kE
Submit story/link
Login
Follow @dekut
Login
Search
Buy 4000 Karma points
Click here to buy Karma PointsHow your Dekut app enhances user functionality : Dekut.com will enhance user to like Youtube videos posted on the network. All the likes done by users will be with his own interest. We are not forcing any user to rate any videos. Though they will earn certain karma points based on their user activity.
Note: All Featured posts will be displayed randomly on top for 30 days only.
What is Dekut?
Dekut is all about user powered content .Everything is submitted and voted on by the Dekut community. Share, discover, bookmark, and promote stuff that's important to you. Earn Money from your Dekut account update your Google Adsense Publisher ID under profile.
| Newest Member | greatpackers |
| Total Members | 202586 |
| Total Stories | 268011 |
| Published Stories | 265925 |
| New Stories | 2086 |
| Story Votes | 687596 |
| Comments | 562 |
| Comment Votes | 129 |
| Groups | 354 |
Log in to comment or register here.