Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question was asked by Netflix and is called "Top Percentile Fraud".
How to calculate percentiles in SQL:
https://docs.yugabyte.com/latest/api/ysql/exprs/window_functions/function-syntax-semantics/percent-rank-cume-dist-ntile/#comparing-the-effect-of-percent-rank-cume-dist-and-ntile-on-the-same-input
Check out this problem on StrataScratch: https://platform.stratascratch.com/coding/10303-top-percentile-fraud?via=frederik
Find me on LinkedIn: http://linkedin.com/in/frederikmueller/
Playlists:
StrataScratch SQL Coding Questions: https://youtube.com/playlist?list=PLdrw9_aIADIO_l7hCd4xiJ2mBwiOb4jkU
LeetCode database SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIPAMJW8I_S-S747oyiRtzpS
LeetCode easy SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADINpdkxu_RHaY16QmG8-mRSm
LeetCode medium SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIMSQe_-m6xknIdPPNiYngKh
LeetCode hard SQL problems: https://youtube.com/playlist?list=PLdrw9_aIADIP0sYoOt2mql4Hb06Y1D0z2
Download
0 formats
No download links available.
*HARD* Netflix SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 10303) | NatokHD