I am going through the Window Functions lesson of the Analyze Data with SQL skill path, and I have a question.
The definition of a window function in the lesson is this one:
Window functions , on the other hand, allow you to maintain the values of your original table while displaying grouped or summative information alongside in another column.
Another definition I found:
Window functions applies aggregate and ranking functions over a particular window (set of rows).
After a lot of thought (and Google searches), I thought I had gotten the hang of it.
So I went back to the Codecademy lesson and tried writing my own Window Function, but without an Aggregage function. It didn’t work. And I believe I did everything else correctly, cause when I changed it to include an aggregate function it did work.
So my question is, can window functions only be used with aggregate functions?