Some Migration target data (WebApps)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Physics

Q&A for active researchers, academics and students of physics

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

  from postHistory
  where  posthistoryTypeid in (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)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results