How to pull out posts where 'likes > 10' (likes in another table, posts in another)?

Question

PHP

Good day. Help a newbie, I can't figure out how to organize this.
There is a _Likes table, it has 3 fields ("user_id", "post_id" which user put @ like on which post and ID)
and there is also a _posts table, it has a lot of things and of course that post_id

I want to pull out posts that scored more than 10 likes. How can I do it ?
how? php or sql query? show examples please indicate the correct path

Answer 1

I'm working with MS Sql server, not MySQL, so your syntax may be different, but the idea is this:
Make a grouping in the likes table by post_id
you will get post_id's that have more than 10 likes. You can then use this as a subquery.

Answer 2

You approached this issue from the wrong side.
You need to have a like counter in the post table and add 1 to it when the user likes it.
Then posts with likes > N will be easier to get.