Count of unanswered and unclosed android-tagged questions between 2014-01-01 and 2015-01-01

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for programmers

create table #android_qids (id int primary key, creationdate datetime)

insert #android_qids
select
  id, creationdate
from 
  Posts q
where 
  tags like '%<android>%' 
  and not exists(select * from Posts a where a.ParentId = q.Id)
  and q.ClosedDate is null
  and q.ParentId is null
  and q.CreationDate >= '2014-01-01' and q.CreationDate < '2015-01-01'


select
  datepart(wk, CreationDate) wk,
  count(*) Questions
from
  #android_qids
group by
  datepart(wk, CreationDate)
order by
  datepart(wk, CreationDate)

Enter Parameters

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