Some Migration target data (WebApps)

0

Please login or register to vote for this query.

(click on this box to dismiss)

Amateur Radio

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)

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results