Introduction
1. Welcome to the Practice Field
Simple OVER()
PARTITION BY
Ranking functions
Window Frames
Analytic Functions
PARTITION BY ORDER BY
Order of Evaluation
Finished!

Instruction

Hello and welcome to our Practice Field! If you felt like the lesson exercises were not enough, here's your chance to solve all kinda of additional window function problems.

Window functions are a powerful tool that requires practice and review. This is why we created this part – it does not introduce any new knowledge, but it reviews everything you have learned so far, part by part. In each section, we'll quickly review what we learned by introducing a single example to refresh your memory. Then, you will be presented with some exercises. Know the answer right away? Fantastic! Need some help? Don't worry: each exercise has a hint which you can check.

Part 10 will contain the final quiz, which you must complete in order to successfully finish this course.

Exercise

Click Next exercise to continue.