Simon Willison’s Weblog
Owned by simonw, visibility: Public
with content as ( select created from blog_entry union all select created from blog_blogmark union all select created from blog_quotation ) select to_char(date_trunc('month', created), 'YYYY-MM') as bar_label, count(*) as bar_quantity from content group by bar_label order by bar_label desc