Posting a codeblock

select
  channel_name,
 count(*) as message_count

from messages

where created_at >= now() - interval '7 days'

group by channel_name

order by message_count desc

limit 10;