Window functions (ROW_NUMBER, RANK, DENSE_RANK)
medium
1 of 5 Lessons
Aggregate window functions and moving averages
medium
2 of 5 Lessons
Common Table Expressions (CTEs) using WITH clause
medium
3 of 5 Lessons
String manipulation and date/time functions
medium
4 of 5 Lessons
Pivoting Data and Case Statements
medium
5 of 5 Lessons