Development of 'reinstate' usernames

0

Please login or register to vote for this query.

(click on this box to dismiss)

Anime and Manga

Q&A for anime and manga fans

with a as (
   select convert(decimal(12,0),CreationDate) CDate,
          Case 
             When OwnerDisplayname like '%Reinstate%' collate SQL_Latin1_General_CP1_CI_AS
             Then 1
             Else 0
          End Reinstate
   from Posts
   where PostTypeId = 2
)

select 7*round(CDate / 7,0),Reinstate,Count(CDate) from a
group by 7*round(CDate / 7,0), Reinstate
order by 7*round(CDate / 7,0)

Enter Parameters

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