Ace SQL Interviews: A Data-driven Approach for Data Scientists

Подписаться 56 тыс.

Просмотров 8 тыс.

50% 1

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
www.emmading.com/get-all-my-f...
🟡 Product Case Interview Cheatsheet www.emmading.com/product-case...
🟠 Statistics Interview Cheatsheet www.emmading.com/statistics-i...
🟣 Behavioral Interview Cheatsheet www.emmading.com/behavioral-i...
🔵 Data Science Resume Checklist www.emmading.com/data-science...
✅ We work with Experienced Data Scientists to help them land their next dream jobs. Apply now: 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

Опубликовано:

4 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 13

@davidskarbrevik Год назад

Nice concise explanations. Looking forward to a part 2

@romangirin772 Год назад

cool explanations with examples which easy to grasp

@nehusingh2006 Год назад

Hi Emma, your videos and contents are always super resourceful. If you ever have time please do a video on Correlation and how to handle strongly Correlated feature.

@krzysztofjarek6476 4 месяца назад

Thanks, great video - clear explanation ☺

@TheACG22 Год назад

Hi Emma, I bombed a coding interview just last week with a Top N question requiring window functions. Never again! Also, just wanted to say that I'd like to follow you on LinkedIn, but afraid that people at my company will see that I liked/follow a person giving advice on how to interview for jobs , which might tip them off on my job search. All this to say that there may be others like me who are closet followers :)

@emma_ding Год назад

Hi, Austin! Thanks for your comment. 💛 Imagining having secret followers made me chuckle. 😊 Also, I'm sorry to hear about your recent interview experience, but wanted to let you know I'm rooting for you!

@deenadayalan03 Год назад

Thank you ❤️❤️

@brittanybutterworth7994 Год назад

Really good content - I had to watch it over twice because the video was so technically dense. I really appreciate this kind of problem because its easy to see where you could logically be asked to do this type of query on the first day of the job rather than a nebulous situation. Thanks so much for making these videos!! ♥

@emma_ding Год назад

Thank you for the kind words, Brittany! Happy to help! 😊

@SanuSatyam Год назад

Nice Session. Your explanations are precise and clear. Can you please upload the notion page of this video?

@mhh5002 Год назад

7:35 where does "rating" column come from in the tables 'avg_ratings' and 'rating_rank'? Shouldn't it be 'avg_rating'?

@ayandakeith Год назад

Thought I was the only one that saw that.

@emma_ding Год назад

Many of you have asked me to share my presentation notes, and now… I have them for you! Download all the PDFs of my Notion pages at www.emmading.com/get-all-my-free-resources. Enjoy!