Salesforce SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 9905)

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-highest-target-under-manager?via=frederik Find me on LinkedIn: http://linkedin.com/in/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: https://youtube.com/playlist?list=PLdrw9_aIADIO_l7hCd4xiJ2mBwiOb4jkU https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS https://youtube.com/playlist?list=PLdrw9_aIADINpdkxu_RHaY16QmG8-mRSm https://youtube.com/playlist?list=PLdrw9_aIADIMSQe_-m6xknIdPPNiYngKh https://youtube.com/playlist?list=PLdrw9_aIADIP0sYoOt2mql4Hb06Y1D0z2