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 in (17, 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 aug 22 13 Jon "not doe" Ericson

created apr 13 12 conradfrix