Skip to main content
Tweeted twitter.com/#!/StackProgrammer/status/175639279278620673
added 258 characters in body
Source Link
Morons
  • 14.7k
  • 18
  • 19

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query:

Select  CAST(year(p.CreationDate) as char(4))+'-'+CAST(DATEPART(wk,p.CreationDate) as char(2)) as week   ,count(1) as Cnt   ,avg(score) as Avg ,avg(VoteCount) as AvgVoteCount from Posts p JOIN (Select postid,count(1) as VoteCount from Votes group by postid) v on v.postid=p.id where p.CreationDate>dateadd(yy,-1,getdate())  group by   year(p.CreationDate)   ,DATEPART(wk,p.CreationDate)   order by year(p.CreationDate),DATEPART(wk,p.CreationDate)  

I then Graphed The Count and Average:

Count of Posts Average Post Score

Our Average Question Score is Down a full point over the last year, whats going on?

Count of Posts Average Post Score


Edit: I Updated the SQL and Added Average Vote count..

Average Vote Count


Edit 2: For Thomas SO Results enter image description here

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query:

Select  CAST(year(CreationDate) as char(4))+'-'+CAST(DATEPART(wk,CreationDate) as char(2)) as week   ,count(1) as Cnt   ,avg(score) as Avg from Posts where CreationDate>dateadd(yy,-1,getdate())  group by   year(CreationDate)   ,DATEPART(wk,CreationDate)   order by year(CreationDate),DATEPART(wk,CreationDate)  

I then Graphed The Count and Average:

Count of Posts Average Post Score

Our Average Question Score is Down a full point over the last year, whats going on?

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query:

Select CAST(year(p.CreationDate) as char(4))+'-'+CAST(DATEPART(wk,p.CreationDate) as char(2)) as week ,count(1) as Cnt ,avg(score) as Avg ,avg(VoteCount) as AvgVoteCount from Posts p JOIN (Select postid,count(1) as VoteCount from Votes group by postid) v on v.postid=p.id where p.CreationDate>dateadd(yy,-1,getdate()) group by year(p.CreationDate) ,DATEPART(wk,p.CreationDate) order by year(p.CreationDate),DATEPART(wk,p.CreationDate) 

I then Graphed The Count and Average:

Our Average Question Score is Down a full point over the last year, whats going on?

Count of Posts Average Post Score


Edit: I Updated the SQL and Added Average Vote count..

Average Vote Count


Edit 2: For Thomas SO Results enter image description here

added 40 characters in body
Source Link
Morons
  • 14.7k
  • 18
  • 19

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query: Select

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEPART(wk,CreationDate) as char(2)) as week   ,count(1) as Cnt   ,avg(score) as Avg  from Posts  where CreationDate>dateadd(yy,-1,getdate())  group by   year(CreationDate)   ,DATEPART(wk,CreationDate)   order by year(CreationDate),DATEPART(wk,CreationDate) 

I then Graphed The Count and Average:

Count of Posts Average Post Score

Our Average Question Score is Down a full point over the last year, whats going on?

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query: Select

CAST(year(CreationDate) as char(4))+'-'+CAST(DATEPART(wk,CreationDate) as char(2)) as week ,count(1) as Cnt ,avg(score) as Avg from Posts where CreationDate>dateadd(yy,-1,getdate()) group by year(CreationDate) ,DATEPART(wk,CreationDate) order by year(CreationDate),DATEPART(wk,CreationDate) 

I then Graphed The Count and Average:

Count of Posts Average Post Score

Our Average Question Score is Down a full point over the last year, whats going on?

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query:

Select CAST(year(CreationDate) as char(4))+'-'+CAST(DATEPART(wk,CreationDate) as char(2)) as week   ,count(1) as Cnt   ,avg(score) as Avg  from Posts  where CreationDate>dateadd(yy,-1,getdate())  group by   year(CreationDate)   ,DATEPART(wk,CreationDate)   order by year(CreationDate),DATEPART(wk,CreationDate) 

I then Graphed The Count and Average:

Count of Posts Average Post Score

Our Average Question Score is Down a full point over the last year, whats going on?

Source Link
Morons
  • 14.7k
  • 18
  • 19

Are we Going down hill?

From what I was seeing overall question quality is going downhill, so on that hunch, Using Stack exchange's Data explorer ran the Following Query: Select

CAST(year(CreationDate) as char(4))+'-'+CAST(DATEPART(wk,CreationDate) as char(2)) as week ,count(1) as Cnt ,avg(score) as Avg from Posts where CreationDate>dateadd(yy,-1,getdate()) group by year(CreationDate) ,DATEPART(wk,CreationDate) order by year(CreationDate),DATEPART(wk,CreationDate) 

I then Graphed The Count and Average:

Count of Posts Average Post Score

Our Average Question Score is Down a full point over the last year, whats going on?