select
    author,
    count(*) as total_articles,
    max(published_at) as most_recent_article,
    min(published_at) as earliest_article
from {{ ref('stg_articles') }}
group by author
order by total_articles desc