*HARD* Amazon SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 10314) скачать в хорошем качестве

*HARD* Amazon SQL Interview Question for Data Scientists and Data Analysts (StrataScratch 10314)

Solution and walkthrough of a real SQL interview question for Data Scientist and Data Analyst technical coding interviews. This question was asked by Amazon and is called "Revenue Over Time". SQL Window Functions Row Clause Overview: https://learnsql.com/blog/sql-window-... 0:00 Intro 0:32 Problem Statement 2:44 Calculating Monthly Revenue 5:51 Calculating 3-Month Rolling Average 9:50 Problem Discussion 12:18 Outro Try this question on StrataScratch: https://stratascratch.com/coding/1031... Find me on LinkedIn:   / frederikmueller   Playlists:    • StrataScratch Coding Questions [SQL]      • LeetCode Database Problems [SQL]      • LeetCode Easy Database Problems [SQL]      • LeetCode Medium Database Problems [SQL]      • LeetCode Hard Database Problems [SQL]