Ace SQL Interviews: A Data-driven Approach for Data Scientists
Top N is the most frequently presented SQL question in interviews. In this video, I hope to help you understand how to answer questions like, “What are the Top 5 highest-rated movies?” and “What are the Top 3 highest paid employees per department?” I’ll demonstrate the problem using an example, and fill you in on how to modify the query when there are ties in the ranks.
🟢Get all my free data science interview resources
https://www.emmading.com/get-all-my-f...
🟡 Product Case Interview Cheatsheet https://www.emmading.com/product-case...
🟠 Statistics Interview Cheatsheet https://www.emmading.com/statistics-i...
🟣 Behavioral Interview Cheatsheet https://www.emmading.com/behavioral-i...
🔵 Data Science Resume Checklist https://www.emmading.com/data-science...
✅ We work with Experienced Data Scientists to help them land their next dream jobs. Apply now: https://www.emmading.com/coaching
// Comment
Got any questions? Something to add?
Write a comment below to chat.
// Let's connect on LinkedIn:
/ emmading001
====================
Contents of this video:
====================
00:00 Introduction
01:22 Get My Notion Pages!
01:44 Top N Problem
02:15 Sample Questions
02:33 Top N Records
03:02 LIMIT and OFFSET
03:47 Window Functions
05:30 Top N Per Category
07:40 Top N Per Category With Ties
08:50 Topic for Next Video
On this page of the site you can watch the video online Ace SQL Interviews: A Data-driven Approach for Data Scientists with a duration of hours minute second in good quality, which was uploaded by the user Emma Ding 30 January 2023, share the link with friends and acquaintances, this video has already been watched 11,574 times on youtube and it was liked by 296 viewers. Enjoy your viewing!
