0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for amateur radio enthusiasts

with migrations as (
  select postID, comment target, year(creationdate) yr, month(creationDate) m

  from   postHistory
  where  posthistoryTypeid = 35
)

Select count(postID) M_Count, target, yr
FROM migrations
where target is not null
group by yr, target
order by yr, target, count(postID)

fork query

edited jan 1 14 hippietrail

created apr 13 12 conradfrix