Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question was asked by Salesforce and is called "Highest Target Under Manager".
Try this question on StrataScratch: https://stratascratch.com/coding/9905...
Find me on LinkedIn: / frederikmueller
0:00 Intro
0:06 Problem Statement
2:14 MAX() Approach
5:11 RANK() Window Function Approach
8:46 Problem Discussion
9:24 Outro
Playlists:
• StrataScratch Coding Questions [SQL]
• LeetCode Database Problems [SQL]
• LeetCode Easy Database Problems [SQL]
• LeetCode Medium Database Problems [SQL]
• LeetCode Hard Database Problems [SQL]