How to calculate user posts

Question

I have table users with about 220 k users and each user made almost 1 post

table users and in field i have the number of he's post's postcount=5

I want to know the sum of all users postcount

thnakx in advance

Answer 1

SELECT SUM(postcount) FROM users;

Try this query.