0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those using, extending or developing Emacs

select
  cast(year(p.creationdate) as varchar) + '-' +
  cast(month(p.creationdate) as varchar) as ym,
  count(*)
from posts p
inner join users u on p.owneruserid = u.id
where p.posttypeid = 1
and p.tags like '%python%'
and lower(u.location) like '%italy%'
group by cast(year(p.creationdate) as varchar) + '-' +
  cast(month(p.creationdate) as varchar);

fork query

edited apr 1

created apr 1 anonymous