hey guys doesn't answer

Question

write a query to extract the sum of like for topic
SELECT post_id,Sum(topic)
FROM likes;

Answer 1

You code has many mistakes
1>You have to extract topic and total sum of likes as `sum`.But you are trying to find total sum of topic which result in error.
2>These things should extract by the table `posts` not `likes`.
3>Table should be grouped by topic.

So finally after fixed these problems your code will looking like this one:-

SELECT topic,SUM(likes) AS sum
FROM posts
GROUP BY topic

Answer 2

you gave good tips and thank you