SQL ACADEMY • MODULE 24Advanced Window Analytics
Use advanced window frames, ranking, comparisons, and analytical calculations used in production data analytics.
Advanced📚 10 Lessons⭐ 0 / 16850 XP⏳ In Progress
0 / 10 Lessons Completed (0%) LESSON 151🔓 Partitioned Running Total
⏱ 3 Mins • ⭐ 1640 XP • Advanced
LESSON 152🔒 Partitioned Average
⏱ 3 Mins • ⭐ 1650 XP • Advanced
LESSON 153🔒 Salary Rank by Department
⏱ 3 Mins • ⭐ 1660 XP • Advanced
LESSON 154🔒 Previous Salary
⏱ 3 Mins • ⭐ 1670 XP • Advanced
LESSON 155🔒 Salary Change
⏱ 3 Mins • ⭐ 1680 XP • Advanced
LESSON 156🔒 NTILE
⏱ 3 Mins • ⭐ 1690 XP • Advanced
LESSON 157🔒 Cumulative Department Salary
⏱ 3 Mins • ⭐ 1700 XP • Advanced
LESSON 158🔒 Moving Average
⏱ 3 Mins • ⭐ 1710 XP • Advanced
LESSON 159🔒 First Value
⏱ 3 Mins • ⭐ 1720 XP • Advanced
LESSON 160🔒 Last Value
⏱ 3 Mins • ⭐ 1730 XP • Advanced