How to implement it (PHP, SQL)?

Question

SQL

There are 2 tables users and posts.
You need to display the login of the most active user per day, that is, the one with the largest number of posts per day. How can this be implemented?

Answer 1

With the first request, you pull the top active user ids, and either join, or simply select the second one, take the users.

select user_id, count(id) as count_ids from posts where `datetime`>{день назад} order by count_ids desc  limit 10