I am trying to add a calculated column that computes a rolling average of a sorted partition. I can make it work as a query but cannot seem to get the result to
I have two tables: The first one contains numeral values, it looks like this: The id column is the primary key; it has the attribute AUTO_INCREMENT. All col
I would like to calculate the daily average weight gain per day for each row and add the answer in a a new column. The variable to calculate the average are