CODEWITHSUNDEEP
mysqlsqlworkbench
rgf4gr
rgf4gr

Reputation: 3

Create new column storing average of rows from another column in MySQL

I am trying to create a new column that has stores the 'Average weight of the field'. For example, the answer for RaceID = 123 would be 54.5. The RaceID's are not organised from smaller to largest and are displayed randomly like the example below.

RaceID Weight No. Starters
123 56 2
124 58 2
123 53 2
125 60 2
125 51 2
124 62 2

Upvotes: 0

Views: 54

Answers (2)

DB08
DB08

Reputation: 181

Try below query, It will display current table data along with average column :

select t.*,
avg(Weight) over(partition by raceID order by raceID ) avg_raceID
from table t;

Upvotes: 1

praneeth sunkavalli
praneeth sunkavalli

Reputation: 71

SELECT RaceID, AVG(Weight) AS val_1
FROM dataset_name
GROUP BY RaceID;

By using above code we can get the average value of weights for every unique RaceID. Check the below image for better understanding.
https://i.sstatic.net/kMA68.png
Let me know if there are any modifications or error.

Upvotes: 0

Related Questions