This is a code block
elect
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;elect
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;