How to formulate an SQL query to fetch the most popular posts in WordPress?

Question

WordPress

The task is to display the most popular posts in WordPress for a month.
We have a standard table wp_posts in the database with posts. In this table, we are only interested in the ID
field. In addition, there is a wp_pp_stat table containing the post_id fields (they match the post IDs from the wp_posts table) and access_time - the access time to the post.
You need to create an SQL query that will return the 5 most viewed posts in the last month.
PS. Strongly do not kick, I'm new to SQL.

Answer 1

select
  posts.*
  , count(*) as '# of posts'
from wp_pp_stat as stat
inner join wp_posts as posts
  on posts.id = stat.post_id
where stat.access_time > now() - interval 1 month
group by stat.post_id
order by count(*) desc
limit 5

There is no way to check, so try it yourself.