SQL question

Question

A social media platform wants to analyze user engagement and preferences by grouping and counting reactions to posts ("likes").

Please help

Answer 1

I found the lesson finally, it is in Coding for Data / Coding Foundation > Data Analysis > Social Media Posts.
PS. A side note, Data Analysis doesn't exist in BOTH Introduction to SQL and SQL Intermediate. I think it should belong to introduction course.

Task full description:
A social media platform wants to analyze user engagement and preferences by grouping and counting reactions to posts ("likes"). You are given the following posts table:
post_id, name, topic, likes
1, Rock Concert, Music, 100
2, Beach Paradise, Travel, 200
...
...

If you haven't passed this exercise, please review Grouping page 4 and run the demo code.
It should give you inspiration.

Answer 2

You wrote a statement. What is your question?

Answer 3

Would you please mention the module name?
We need more info in order to help.

Meanwhile please read this before posting. It helps you and us.

https://sololearn.com/compiler-playground/WgUUoIFf6Fdm/?ref=app

Answer 4

The Right answer for this Practice query is:

SELECT topic, SUM(likes)
FROM posts
GROUP BY topic;