Counting multiple rows in Mysql

Question

I'm currently having a table filled with likes and tweets of a certain post sorted on date.

I want to know the query to count the total of likes and tweets sorted by post_id. The result of the example below should be 50 likes and 20 tweets.

The structure of the table is:

post_id date    likes   tweets
1   2012-06-09  20  10
1   2012-06-10  30  10

Review the aggregate functions This is a rudimentary SUM(likes), SUM(tweets) GROUP BY post_id — Michael Berkowski
– Michael Berkowski, Commented Jun 10, 2012 at 14:26
What is your table structure and what have you tried so far? — Aleks G
– Aleks G, Commented Jun 10, 2012 at 14:26

Jonas Osburg · Accepted Answer · 2012-06-10 14:31:17Z

3

Have a look at this doc. Try this:

SELECT SUM(`likes`) AS `likes`, SUM(`tweets`) AS `tweets` FROM `table` GROUP BY `post_id`

answered Jun 10, 2012 at 14:31

Jonas Osburg

1,7831 gold badge14 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Maziar Aboualizadehbehbahani · Accepted Answer · 2012-06-10 15:16:01Z

0

In your case:

your table name assumed: tweets

select SUM(likes), SUM(tweet) from post_table group by(post_id)

General Form:

SELECT column_name, aggregate_function(column_name)
FROM table_name
WHERE column_name operator value
GROUP BY column_name

answered Jun 10, 2012 at 14:28

1,98318 silver badges37 bronze badges

He wanted the sum of both likes and tweets, this is just summing likes