I just entered the world of window functions. I have a similar problem to solve as in this question.
I have this table:
The last column (%Grown)
is given by:
-(1 - price of row 2 / price of row 1) * 100
All the information I have found so far was related to sums, avg for all rows. I don't know how to bound two rows so I can calculate the percentage.
How do I translate this into SQL?