Calculate average of column from MYSQL query

mysql sum average
DoubleA picture DoubleA · Jan 6, 2012 · Viewed 91.4k times · Source

I've got a table that I am trying to calculate the average of the values in a column. Here is my lookup:

SELECT SUM(P1_Score) AS value_sum FROM tblMatches Where P1_ID LIKE $playerID

Any idea how I can determine the average (sum of values / total rows)?

Answer

zerkms picture zerkms · Jan 6, 2012

You can use AVG like so:

SELECT AVG(P1_Score)

Related questions

How do I get SUM function in MySQL to return '0' if no values are found?

Say I have a simple function in MySQL: SELECT SUM(Column_1) FROM Table WHERE Column_2 = 'Test' If no entries in Column_2 contain the text 'Test' then this function returns NULL, while I would like it to return 0. I'm aware that …

Read More
MYSQL Sum Query with IF Condition

I am building a query for a report with multiple IF conditions on the SUM. I am having problems with a multiple IF conditions on the SUM. Here is the query: SELECT SUM(`totalamount`) AS Total, SUM(`PayPalFee`) AS Fees, …

Read More
MySql sum elements of a column

I have a table with 3 columns (A,B,C). I want to select some rows from the table and then the MySQL to return a single row having the values added on each column... A B C 1. 2 2 2 2. 4 4 4 3. 6 7 8 MySql should return …

Read More