Search code examples
mysqlsum

MYSQL- Finding the total amount of playtime (from a column) from all lines and getting a sum

https://www.dropbox.com/s/7i5y1aggfjzl39c/photo.png

I want to get a total amount of playtime from the 38,000 users.

In addition, I want the sql query that will add the previous amount on the "playtime" column from each line and find a final sum.

Edit: Im really unsure If I was specific enough, I never ever got in a hard situation like this at expressing myself with English.

Solution

  • SELECT SUM(Playtime) FROM players;

    That will give you the total amount of playtime from all users.