Finding average, flooding table

[chris921]

Hiya,

I was wondering if its possible to find the average price (in my case the average price of footballers sold per football team) and sort it so I can say the average price sold per player at Man United is £11,000,000 or something?

I want to create a new column called average price and put it in there if possible, ive created the column, I can find the average price, but I cant get the two to link together, can someone please explain how?

Cheers,

Chris

 

[MissouriTiger]

It would have been nice if you had posted the code you tried that didn't work.

Try this:

UPDATE TABLE1
SET    average = (SELECT AVG(price) 
                  FROM   TABLE1 AS T2
                  GROUP BY team)
FROM   TABLE1 AS T1
WHERE  T1.id = T2.id ;

If this doesn't work, try something different.



On the other hand, you might always try punching it through a chaos engine...

________________________________________________
Constructed from 100% recycled electrons.