I have a table that contains monthly averages as follows:
Date(Datetime) fat_percent(Float), oil_percent(Float), MSG_Percent(Float), Quantity(INT).
For each year there are 12 entries. I would like to be able to calculate an average for each year.
The table hold 15 years of data, so I would like to return a row for each year with the with the values for each column.
Any help would be appreciated.
Some rows with actual data and the expected result.