distribution of number of votes in close/open queu

0

Please login or register to vote for this query.

(click on this box to dismiss)

Statistical Analysis

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

with a as (
   select 
     t.id,
     count(r.Id) as number
   from ReviewTaskResults r join ReviewTasks t
   on t.Id = r.ReviewTaskId
   where t.ReviewTaskTypeId in (2)
   group by t.id
), b as (
   select a.*,
          DATEPART(YYYY, CreationDate) +
          0.0*FLOOR((DATEPART(MM,   CreationDate)-1.00)/3)/4  
              as Quarter
   from a join ReviewTasks t2 on a.id = t2.id
)


select number, CAST(Quarter as char), (count(id)) from b
where Quarter < DATEPART(YYYY, GETDATE()) +
                0.0*FLOOR((DATEPART(MM,   GETDATE())-1.00)/3)/4  
group by number, Quarter
order by number, Quarter Desc

Enter Parameters

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