php - SQL SUM values from column and dividide by number of rows

Solution:

useCOUNT to get the totalNumber of rows.

SELECT SUM(voto) / (COUNT(*) * 1.0) 
FROM   tablename 
WHERE  id = numberHere
Copy code

by adding* 1.0 on the query will allow decimal places on the result.

or simply as

SELECT AVG(voto)
FROM   tablename 
WHERE  id = numberHere
Copy code

Solution:

JW's answer is correct if you're looking specifically to do it by Summing/Dividing, but SQL has a function for that.

SELECT AVG(voto) FROM tablename WHERE id = numberHere
Copy code

AFAIK, it automatically returns the same type as you input (except date columns, which should be parsed to seconds then re-encoded to date).

Solution:

AVG should work, count(*) should work, you can also use @@rownum to get the number of rows returned by the statement if you need to do more with that number.